SQL Server Code,Tips and Tricks, Performance Tuning

In SQL Server 2000 if the engine determined that the statistics are out of date it would update the statistics and then run the query. If yo...

This is not going to be a SQL post (again) So to have at least some SQL I am going to link to a post I did last year: Calculating Thanksgivi...

There is a Windows Vista Consumer Launch Countdown Gadget available. There are 3 versions of this gadget (widget for you Mac fans) available...

At work we are required to get training at least once a year. So I decided to take the Upgrading Your Database Development Skills To Microso...

O'Reilly came out with their latest SQL book: SQL Hacks From their site: Whether you're running Access, MySQL, SQL Server, Oracle, o...

The SQL Server Product Team will have a web chat later today From their site: If you have any questions regarding Service Pack 2, please joi...

At work I overheard two people getting excited about the Twisted Sister Christmas album. What? How in the world can you get excited about th...

Microsoft has made a couple of announcements at PASS today; one of them is that the release to manufacture date for Visual Studio Team Editi...

Channel 9 has a podcast about SQL Server Compact Edition. From the site: " Do you remember when having a mobile phone was a big deal? I...

You want to create an indexed view; however creating an indexed view is not as straight forward as creating an index on a table. The view mu...

By now you probably know that Service Pack 2 has added new functionality in the SQL Server 2005 Enterprise Edition to provide an alternate s...

The other day I wrote that SQL Server 2005 Service Pack 2 CTP would be available; here are the download links: SQL Server 2005 Service Pack ...

Vista has been released to manufacturing! Windows Vista Blog http://windowsvistablog.com/blogs/windowsvista/archive/2006/11/08/it-s-time.asp...

Microsoft is releasing the SQL Server 2005 Service Pack 2 Community Technology Preview Tuesday, November 7th. Here are some of the changes: ...

Found this on the TechNet site; sample scripts and stored procedures for managing and working with SQL Server 2005. However on the TechNet s...

Internally dates are stored as 2 integers. The first integer is the number of dates before or after the base date (1900/01/01). The second i...

Straight from the man himself comes this statement posted in the microsoft.public.sqlserver.programming forum : " You need to read ISO-...

Try to guess what the output will be of the following SQL Select statement (don't worry, you can't get it right ;-) First guess the...

Below are the top 5 posts according to Google Analytics for the month of October 2006 in order by pageviews descending Five Ways To Return V...

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