While my primary focus is on SQL Server Performance Tuning, we will see questions related to adding default value to the existing table.
SQL SERVER – Creating System Admin (SA) Login With Empty Password – Bad Practice
I realized that their DBAs are logging into their server with a blank or empty password. This is an extremely Bad Practice. Let us discuss it today.
SQL SERVER – Disable Statistics Update on a Specific Table
Just earlier today when we were fixing the performance of a database during, we found a unique requirement to disable statistics update on a table.
SQL SERVER – Network Protocol and IP Address
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.