A simple puzzle using UNION and UNION ALL: guess the output of two short scripts before you run them. The hint is my article on UNION vs. UNION ALL.
SQL SERVER – 2005 – Retrieve Any User Defined Object Details Using sys objects Database
The sys.objects catalog view has a row for every schema-scoped object, so you can retrieve any user defined object details, like foreign keys, by object type.
SQL SERVER – 2005 – What is CLR?
CLR is the Common Language Runtime. A diagram of its architecture, and why CLR stored procedures in C# help with the loops and recursion that slow down T-SQL.
SQL SERVER – Transfer The Logins and The Passwords Between Instances of SQL Server 2005
How do you transfer the logins and passwords between instances of SQL Server 2005 after a hardware upgrade? I summarize Microsoft KB 918992 and its script.
SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon
How to use Perfmon: three ways to start Performance Monitor, how to add counters, and how to log them over time so you can compare later.
SQL SERVER – Introduction to Three Important Performance Counters
Three basic but very important Performance Counters: % Processor Time, Avg. Disk Queue Length and Disk Read and Write Bytes/sec, and what their values mean.
SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server
How to import CSV file data into SQL Server with BULK INSERT: create a table, point to the comma delimited file and load every row in a few quick steps.