SQL Server Code,Tips and Tricks, Performance Tuning

Sometimes you want to have your money fields properly formatted with commas like this: 13,243,543.57 You can use the CONVERT function and gi...

I stumbled upon this SQL Server technical bulletin and it gives one example of how to resolve a deadlock. Typical methods you can use to res...

A couple of days back I reported that the current issue of SQL Server Magazine includes a poster of all the SQL Server 2005 System Tables . ...

Below are a couple of small SQL query optimization tips I have include the execution plan pictures for some of the queries so that you can s...

Sometimes you get a request to create a login and you want to test the permissions before letting the user know that he can use the login. y...

SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach This book has been published it is 768 pages and published by Apress and you can...

Whether you are interested in database administration, database development, or business intelligence, there is some free * E-Learning to he...

Below is some code that will show how to test for updated field values in an update trigger. As you can see the IF UPDATE (field) is true ev...

I had a scheduled job that runs every hour and took about a minute to complete. Somehow for no good reason this job suddenly takes hours and...

If you have never bought an issue of SQL Server Magazine then this is the month to do it. The latest issue comes with a huge SQL Server 200...

Updated versions of Books On Line and Sample Databases are available from the links below SQL Server 2005 Books Online (December 2005) SQL S...

These are the countries where the bulk of the visitors for this blog are coming from. As you can see most off the visitors are from the US a...

Below is a list of the SQL Server 2000 system tables and the corresponding SQL Server 2005 system views in the master database SQL Server 20...

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

Karen's SQL Blog has a blog post with a list of SQL Server 2005 sample chapters. Since I did not want to duplicate or copy the work tha...

SQL Server 2000 System Table SQL Server 2005 System View syscolumns.....................sys.columns syscomments....................sys.sql...

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...