SQL Server Code,Tips and Tricks, Performance Tuning

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

I just received an email from Quest Software. Quest is giving away 15 Xbox 360™ game systems in 15 days! Download a free trial of Spotlight®...

I will be working four days a week only until next year. I did not take a vacation this year since my wife was pregnant with twins. We could...

Try to guess without running the code which of the following 3 queries will return a value for maxvalue that is not null Is it A, B or C? --...

This is one of the reasons I participate in SQL Server newsgroups and forums A person had the following update statement Update Object_data ...

I have difficulty picking a movie to watch on Halloween. Did any of you (my readers) see any of these movies below? Which movie would you pi...

Microsoft Corp. today announced first quarter revenue of $10.81 billion for the period ended September 30, 2006, an 11% increase over the sa...

This question popped up in a newsgroup today. How do I enable xp_cmdshell in SQL Server 2005? Well you can do it two ways; one is with a scr...

This blog is currently ranked 90,981 on Technorati Rank: 90,981 (65 links from 30 blogs) Not bad I guess, I wonder how long it will take to ...

Just saw The Island the other day and I must say I liked it a lot. I don't know why the movie didn't do as well as expected. The sta...

Do you use between to return data that has dates? Do you know that between will get everything since midnight from the first criteria and up...

Ken Henderson has posted a sample chapter from the forthcoming book SQL Server 2005 Practical Troubleshooting: The Database Engine on his b...

Adam Machanic has made available beta 1 of the SQLQueryStress tool. It provides some support for query parameterization and options for coll...

Gert Drapers has announced that CTP6 of Visual Studio Team Edition for Database Professionals is available for download This is an overview...

SQL Server Hosting Toolkit Released The goal of the SQL Server Hosting Toolkit is to enable a great experience around SQL Server in shared ...

I am having Scrum training tomorrow. So what is Scrum anyway? Scrum is an agile method for project management. Scrum was named as a project ...

SQL Server 2005 has added an optional OUTPUT clause to UPDATE, INSERT and DELETE commands, this enables you to accomplish almost the same ta...

How do I save a DTS package on another server? I have answered this question so many times in the past year or so that I decided to write a ...

I decided to capture everything that my 2 and a half year old son says, store it in a SQL server 2005 database and run some statistics This ...

Hugo Kornelis has posted an interesting article about using STUFF The link to that article is here He has a challenge in that article, the ...