SQL SERVER – Trace Flags
To know about a topic we usually ask questions. Here I used the same method to explain about trace flags of SQL Server. Below are some basic questions and its answers …
Read MoreTag: TSQL
T SQL code formatter
An important aspect of writing code is formatting. No one likes badly formatted code. It’s hard to understand/maintain for people inheriting it and even for the author, when he/she checks it …
Read MoreSQL Server – Understanding Logical Query Processing (LQP)
“TSQL is 2 faced!” – cried the app team member “Have you been watching Batman?” Recent conversation with application folks made me think and I decided to break it down on Understanding …
Read MoreIdentify TCP Port Number of a SQL Instance
There are a lot of instances when you are asked to identify TCP port number for a SQL instance unless you use default port (1433) across the board. There are several ways to …
Read More