Zen and the Art of SQL Server Maintenance

VHD Resizer for Virtual Server or Virtual PC

Found this tool that is good for VHD / Virtual Hard drive / Virtual Machine resizing. I have been running SQL Server on a VM and the performace thus far is good. The December 2007 edition of SQL Server Magazine had some good articles about virtualizing Read More...

SQL Server 2008 (Katmai) New Features Overview

C:\Program Files\ProClarity\ProClarity Dashboard Server\ Nice article on SQL 2008 (Katmai) New Features: http://blogs.mssqltips.com/blogs/chadboyd/archive/2007/10/15/katmai-sql-2008-the-list-of-new-features.aspx I have attached a PowerPoint file that Read More...

Searching for a specific table name

Here is a way to search the Information_Schema to find all tables that have the letter 't' in them, can be helpful to search the metadata of your database schema select * from INFORMATION_SCHEMA.columns where table_name like '%t%' order by column_nam Read More...

Searching the MetaData of a SQL Server Database, Stored Procedure Text

This has been a favorite stored procedure of mine to search the text of my stored procedures for certain phrases... really helpful as the number of stored procs you have grows quite a bit: -- xps '%procedure%' --search for the word 'procedure' in all Read More...

SQL Server Unattended Install Script

Here is a SQL Server Unattended Install Script I wrote last week... was nice to get it working finally!!! ;the PIDKEY will show up in greyed out text boxes during a MANUAL Install... use this for the PIDKEY Parameter IF NECESSARY (probably not necessary) Read More...

Disable and Enable Constraint Checking on SQL Server Tables

Found this script to disable/enable constraint checking here : SELECT 'ALTER TABLE ' + object_name(parent_obj) + ' NOCHECK CONSTRAINT ' + name FROM sysobjects WHERE xtype = 'F' ORDER BY object_name(parent_obj) and to enable: SELECT 'ALTER TABLE ' + object_name(parent_obj) Read More...

Using SELECT INTO to create an on-the-fly IDENTITY Column

Here is a nifty way to add an IDENTITY column on the fly... select distinct id = IDENTITY ( int , 1 , 1 ), usr into dim_usr from fact_eyeballs Read More...