A handy script to list all columns with specific data types in a database. We used it to find TEXT columns and change them to VARCHAR(MAX) in SQL Server 2005.
SQL SERVER – 2005 – List Tables in Database Without Primary Key
A simple script to list tables in database without primary key, using sys.tables and OBJECTPROPERTY TableHasPrimaryKey in SQL Server 2005.
SQL SERVER – Fix: Error 2596 The repair statement was not processed. The database cannot be in read-only mode
Error 2596 stops a DBCC repair because the database is read only. Here is the safe order: back up, single user, read write, repair and check again.
SQL SERVER – Stop SQL Server Immediately Using T-SQL
Need to stop SQL Server immediately? Run SHUTDOWN, or SHUTDOWN WITH NOWAIT to skip checkpoints. I also note which roles have permission to run it.
SQL SERVER – Two Different Ways to Comment Code – Explanation and Example
SQL Server has two different ways to comment code. Let us learn all of them here in this blog post. Various the options in the blog posts.
SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
My Data Warehousing interview questions and answers complete list, with links to every part of the series and one PDF to download.
Replacing a Cursor With a Set-Based Query
Replacing a cursor with one set-based update can simplify row processing; this worked example shows correctness checks and fair timing.