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 – SSMS – Enable Autogrowth Database Property
How to enable Autogrowth for a database in SSMS: open the database Properties, go to Files and click the small button in the Autogrowth column.
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 – One Thing All DBA Must Know
The one thing all DBA must know is to backup database fully. I also answer reader questions on the best time for a backup and how often to take one.
SQLAuthority News – Download SQL Server 2005 Samples and Sample Databases
Microsoft has bought GitHub for 7.5 billion dollars. It is home to 28 million developers, and to Microsoft’s SQL Server samples and sample databases.