SQL Server Code,Tips and Tricks, Performance Tuning

After interviewing Ken Henderson I decided to try my luck with Louis Davidson. By now you already know that he said yes ;-). Louis is the a...

My post from last night triggered something in me to write a little bit about SCHEMABINDING. If you create a view and someone drops one of t...

I am in the process of interviewing people for a position at work. The people I have interviewed so far have between 8 and 10 years SQL expe...

Microsoft TechNet has a page named SQL Server - Best Practices ; this site has white papers, scrips a toolbox and top 10 lists From the site...

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