Recursive CTE performance depends on finding the next children efficiently. Compare identical rows and actual plans before accepting an index change.
SQLAuthority News – 4 Million Visits – over 675 SQL Server Articles
Thank you to every reader: this blog has reached 4 Million Visits and over 675 SQL Server articles, and I was awarded SQL MVP along the way.
SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server – Fix Connection Problems of SQL Server
Still stuck on Error 40, could not open a connection to SQL server? Here are more suggestions to fix connection problems, beyond my first two articles.
SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database
Configure Database Mail in SQL Server 2008 in three steps: create a profile and account, configure email, then send email. Video and screenshots included.
SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case – Part 2
Part 2 on Proper Case in SQL Server: a quick script that makes only the first letter of a sentence upper case, and how to do it for a table column.
SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log
Why does an LDF file keep growing even with hourly log backups? Imran Mohammed explains what goes on behind the scene of the Transaction Log and shrinking.
Spotting Agent Jobs That Run Longer Than Usual
Spot Agent jobs that run longer than usual by decoding msdb duration, comparing recent runs, and checking jobs still active now.
Finding the Client IP Address of a Connection
Find the client IP address of a SQL Server connection with DMVs and CONNECTIONPROPERTY, and understand proxy and local transport limits.
SQL SERVER – Disable All the Trigger of Current Database
Another way to disable all the trigger objects in the current database: a stored procedure by Manish Kaushik that loops over each table and disables them.
SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks
How do you find which table has a transaction lock and what lock type it is? Imran Mohammed explains it for SQL Server 2000 and 2005, and how to avoid locks.