SQL Server Code,Tips and Tricks, Performance Tuning

Get it here and start messing around with LINQ: http://www.microsoft.com/downloads/details.aspx?FamilyID=b533619a-0008-4dd6-9ed1-47d482683c7...

How many times have you asked/been asked the following question: Does rebuilding a clustered index rebuild nonclustered indexes? Well Ken He...

The Google engineers published a paper on Failure Trends in a Large Disk Drive Population . Based on a study of 100,000 disk drives over 5 y...

I always wondered why Condoleezza Rice never smiles, now I know ;-)

What do you think? Can you answer these very difficult questions?

Okay so many many moons ago you created a bunch of tables and those tables have columns of course. You want to know how to find the columns ...

As if you did not download enough in the last 3 days here is one more: SQL Server 2005 Best Practices Analyzer (February 2007 CTP) The SQL S...

If you have downloaded SQL Server 2005 Service Pack 2 you probably have noticed that it does not come with Books On Line. You can download t...

Yesterday I told you that SQL server Service Pack 2 has been released. Microsoft also released the February 2007 Feature Pack for Microsoft ...

If you are a SQL developer then you have probably heard of Dr. Peter Chen, he is the person who wrote the original paper on Entity-Relations...

Microsoft Corp. today released Microsoft® SQL Server™ 2005 SP2, an update to its award-winning data management and analysis platform. Custom...

Chuck Boyce left me a comment on the Celko post yesterday. I decided to make it a separate post since most people who use a RSS reader don...

I won't comment on the Britney madness but here is another gem: A man who was fired by IBM for visiting an adult chat room at work is su...

All right look, there's only one return, okay, and it ain't "of the King," it's "of the Jedi." I own the ext...

I have been waiting for sooooo long for this, I just want to hear these words by Celko himself "Rows are not records; fields are not co...

Buck Woody one of the Technical Writers in the SQL Product Group has started a blog about documentation. His first post SQL Server Books Onl...

Mark Russinovich the guy who revealed to the world that Sony CDs had that nasty rootkit installed has made available a single suite of tools...

Today at Embedded World 2007, Microsoft Corp. announced the availability of the software development kit (SDK) for the Microsoft® .NET Mi...

Below are 10 SQL Server functions that are hardly used but should be used a lot more I will go in more detail later on but here is a list of...