A Splitting Strings puzzle: take a column holding delimited values, split them and return how many values each row has. How would you solve it?
What You May and May Not Do With SQL Server Developer Edition
Understand Developer Edition rights, identify the installed SQL Server edition, and keep shared test systems separate from production work.
SQL SERVER – Identifying Application vs Network Performance Issues
But what do you do? Let us learn in this blog about How to Identify Application vs Network Performance Issues and their solution.
SQL SERVER – SSMS Tip: How to Get Larger Fonts for Results in Grid Output
At GIDS I could not read a speaker’s SSMS output from the back row. Here is a quick SSMS tip to get larger fonts for results in grid output.
SQL SERVER – Configuration Manager – MMC could not create the snap-in. The snap-in might not have been installed correctly
Opening SQL Server Configuration Manager failed with: MMC could not create the snap-in. A reader on Facebook asked, and here is how to fix it.
What is NOT NULL Constraint? – Interview Question of the Week #073
A client table full of NULL values was hurting query plans. Here is what a NOT NULL constraint is, how to add one and why it helped performance.
SQL SERVER – Finding Waits For Any Session with Extended Event wait_info
It becomes a great win-win situation. Let us learn about Extended Event wait_info in this blog post. Do you think this script will be useful for you?