SQL Server Code,Tips and Tricks, Performance Tuning

Below are some undocumented SQL Server 2000 procedures for information about files, drives and directories. You should not depend on this be...

Happy Thanksgiving, here is some SQL code to calculate the next 11 (including today) Thanksgiving days CREATE TABLE #NumberPivot (Number IN...

There are virtual labs available for SQL Server 2005 You get a downloadable manual and a 90-minute block of time for each module. You can si...

How many times did you open up a table in design view to find out if a table has a delete trigger a clustered index an identity column a pri...

The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes: Latest versi...

I have attended the SQL Server 2005 Launch In Philadelphia. It was very informative I learned some stuff I didn't know and saw some usef...

To find all your foreign and primary keys in your database run the code below. The ouput will return the primary key, primary key table, for...

I have 2 store credits one for Borders and the other one for Barnes and Noble. So I decided to buy the Pro SQL server 2005 and SQL Server 20...

Well this is one of those very friendly error messages that when you look at it you know immediately what is going on. Of course I am being ...

Let's say you have a table with integer values below 100000 and you want them in the same format with leading zeros. For example 500 has...

Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL Server 2005, the next generation data management and analysis softwa...

Let's say you have names stored in the format [Klein, Barbara] but would like it to be [Barbara Klein] How do you accomplish that in SQL...

SQL Server has limited support for regular expressions, You can run the code below to see what some of the results are by searching for data...

These are the top SQL Searches on this site for the month of October. I have left out searches that have nothing to do with SQL Server or pr...

Use the numbers 3,4,5,6 and the operators +, -, / and * to get the number 28 You can use each number only one time and also each operator on...

Sometimes you want to know what the percentage is of null values in a table for a field Or you might want to know what the percentage of all...

For all of you people who don't have a MSDN subscription, Amazon is selling the developer edition of SQL Server 2005 for $59.99 with fre...

SQL Server 2005 and Visual Studio 2005 are available for download at the MSDN site For people who have a subscription go here http://www.msd...

Below are the links for the SQL Server Certification exams Microsoft Certified Technology Specialist: SQL Server 2005 Microsoft Certified IT...

This is my top 3 SQL server books. They are not in any order. I use all 3 of them frequently The Guru's Guide to Transact-SQL by Ken He...