Script Table Data to Insert Statements - Handles Unicode datatypes (nchar, nvarchar, ntext). This script works with SQL 2000 and has been improved to handle properly the nchar, nvarchar, and ntext data types for Unicode, as well as handle apostrophes in data correctly. Usage is to run the script to create the stored proc in […]
2006-01-24 (first published: 2006-01-11)
571 reads
This is a script you can run on a per-server basis, from any database in Query Analyzer or incorporate into a stored procedure, that will examine all databases on that instance of SQL and show what Maintenance Plan(s) they are part of, if any. Shows clearly any databases that are not currently part of a […]
2004-10-01
484 reads
I know I’m a weirdo. I’ve always been a weirdo. When I was a...
I realized in my last #PowershellBasics post that I was talking about running a...
Adrian has a look at the performance benefits of instant file initialisation Below is...
Comments posted to this topic are about the item Leveling up Core Skills: A...
Comments posted to this topic are about the item Database Normalization in SQL with...
Comments posted to this topic are about the item SELECT and Locking
Ask SSC