The question was if there is a way to know how many sessions are connected to current SQL Server instance with their network protocol as well as IP address.
SQL SERVER – Wait Statistics from Query Execution Plan
Recently one of my clients asked if I know a way to find the Wait Statistics from the Query Execution Plan. Yes, there is a way to do it.
Does BIT Datatype Equal to 1 or TRUE in SQL Server? – Interview Question of the Week #282
Question: Does BIT Datatype Equal to 1 or TRUE in SQL Server?
Answer: Very interesting question. Let us learn about it today.
SQL SERVER – Single Table Scan for Multiple Aggregated Operators
Today we will discuss how a single table scan for multiple aggregated operators helps to improve performance. Let us learn about it today.
SQL SERVER – sys.dm_os_sys_info and Lock Pages in Memory
This time DBA called me as he wanted to know if how to confirm that lock pages in memory is enabled for the SQL Server instance.
SQL SERVER – Queries Waiting for Memory Grant – Performance Tuning
He asked me if I can provide it scientifically my findings and he will immediately approve the budget. Let us see Queries Waiting for Memory Grant.
SQL Puzzle – IN and IS NOT NULL – Strange Results
Today, let us see a very simple puzzle where we are getting strange results when using NOT IN and IS NULL in a T-SQL query.