SQL Server Code,Tips and Tricks, Performance Tuning

I don't know if I should laugh or cry after looking at this code. This could not have been written by a human right? Anyway here it is, ...

This is a frequent request in newsgroups and fora. People want to sort the column in ascending order but don't want the NULLS at the beg...

I am a big fan of Inside Microsoft SQL Server 2005 The Storage Engine so when I saw that yet another book got published in this series I ju...

There are some good katmai whitepapers appearing on microsoft.com. The list is available here http://www.microsoft.com/sql/2008/learning/whi...

What do you think will be the output? DECLARE @d datetime SET @d = '20071010' SELECT DATEADD (yy, DATEDIFF (yy, 0, @d)+1, -1) Aft...

In this clinic, you will learn about the new and enhanced features included in SQL Server 2008. You will explore the new data types and the ...

Found this here: http://jobs.perl.org/job/6883 Senior Software Engineer – Linux/Apache/Mysql/Perl We are a small, San Francisco-based co...

How do you find out the recovery model for all the databases on your SQL Server box? On a SQL Server 2005/2008 box you can use the sys.datab...

Here is a small teaser, can you guess the output? SELECT d.c-d.b/d.a FROM ( SELECT 1,2,5)d(a,b,c)

SQL Server Analysis Services is a very powerful tool, which was introduced with SQL Server 2000. In SQL Server 2005 it is far more powerful...

What will be the outcome of this script? First we create a table with a total of 6000 bytes Next we increase col2 from 1000 to 2000 bytes, t...

What is SQL Injection? From wikipedia : SQL injection is a technique that exploits a security vulnerability occurring in the database layer...

Cumulative update package 3 for SQL Server 2005 Service Pack 2 is available. How to obtain Cumulative Update 3 for SQL Server 2005 Service P...

This is for SQL Server 2000 only, SQL Server 2005 is a lot smarter which is another reason to upgrade. When running the following query you ...

Microsoft SQL Server 2008 CTP 4 has been released 20070831 (yes that is ISO format) So I have been sleeping for the last couple of days and ...

Can't wait for C# 3.0 and LINQ? Well you don't have to! Dynamically query SQL databases today in LINQ: no more struggling with antiq...

Hahaha, is this a babelfish translation? FROM: BILLY BANGURAABUJA,NIGERIA E-MAIL: billy_bangura2005@yahoo.co.uk DEAR ONE PERMIT ME TO INFOR...

Hi and welcome to another fascinating SQL summer teaser. Summer it is except inPrinceton where it was 50 degrees this week. There was no tea...

Channel 9 has posted a SQL Server 2005 Integration Services screen cast. From the site: This geekSpeak is all about SQL Server 2005 Integrat...

I have too many CDs and decided to throw out some 'old' software. I either have newer versions or no need for it anymore.