SQL_VARIANT_PROPERTY makes underlying types visible. Inspect explicit decimal widths, int, Unicode capacity and a missing variant value.
SQL SERVER – How to Rename a Column Name or Table Name
How to rename a column or a table in SQL Server with sp_RENAME, with a video and a simple AdventureWorks example for each case.
Recursive CTE Performance: Index the Child Lookup
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.