Three ways to build a Comma Separate Values List from a table: COALESCE, a smart SELECT, or a cursor. Written for SQL Server 2005 with VARCHAR(MAX).
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – UDF – Function to Convert List to Table
A UDF, udf_List2Table, to convert list to table with any delimiter you choose. Written for SQL Server 2005 with VARCHAR(MAX), and easy to adapt for 2000.
SQL SERVER – 2005 Enable CLR using T-SQL script
In SQL Server 2005 the CLR is off by default. Here is the sp_configure script to enable CLR, turning on show advanced options and then clr enabled.
SQL SERVER – UDF – User Defined Function to Find Weekdays Between Two Dates
A user defined function that returns the number of weekdays between two dates, skipping Saturday and Sunday. It was written by Alexander Chigrik.
SQL SERVER – Fix : Error : Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset DBSCHEMA_TABLES_INFO for OLE DB provider SQLNCLI for linked server LinkedServerName
Msg 7311 comes up when a 64-bit SQL Server 2005 runs distributed queries against a linked 32-bit SQL Server 2000 or 7.0. Running instcat.sql with osql fixes it.
SQL SERVER – Download SQL Server Management Studio Keyboard Shortcuts (SSMS Shortcuts)
After many requests following my Query Analyzer post, I put the SQL Server Management Studio Keyboard Shortcuts from MSDN into one easy PDF to print.
SQL SERVER – DBCC Commands to Free SQL Server Memory Caches
You do not need to restart the server to clear SQL Server memory caches. DBCC FREESYSTEMCACHE and related DBCC commands do it, for the rare times you need it.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.