SQL Server Code,Tips and Tricks, Performance Tuning

As I promised earlier today, here is the first of many posts about the Dynamic Management Views in SQL Server 2005. What does the sys.dm_exe...

Dynamic Management Views Blog Post Series Coming To A Screen Near You Since I don't always know what to write I decided to give myself e...

Ken Henderson promised to give away a signed book to the person who made the best Celko superhero Tom Øyvind Hogstad has created one on his ...

The Register has a review on their subsite Regdeveloper about Visual Studio 2005 Team Edition For Database Professionals (also know as Data ...

Let's say you have a value of 13.33 and you want to round this up and down to the nearest .25 in other words for 13.33 you want to displ...

That's right you can win one of the following three books The Guru's Guide to Transact-SQL The Guru's Guide to SQL Server Archit...

Since it's Friday today I will keep it light Let's start with a joke that I read in Wired magazine yesterday What do you call a blon...

I created a Frappr Map and would like for you (yes you the reader) to add yourself to the map because it would be interesting to see where ...

Quest Software, Inc. announced the newest version of its award-winning Toad™ database management product family. Toad for SQL Server 2.0 inc...

Many many moons ago I wrote about DDL Trigger Events I promised that I would find out all the events that you can combine for example DDL_VI...

Channel 9 has an interesting video and podcast about the microsoft.com architecture with SQL Server From the site: "At the heart of mos...

"Query Multiple Databases" This search term has been used 13 times in the last week on this blog. So here is a little blog post ab...

The Analysis Services Stored Procedure project is a set of sample stored procedures for Analysis Services 2005. These samples have been writ...

In mathematics, the Sieve of Eratosthenes is a simple, ancient algorithm for finding all prime numbers up to a specified integer. It was cre...

Quest has a nice little give away. They are giving away 40 2GB Apple Nano iPods to people who are willing to try LiteSpeed for SQL Server. I...

Tim O’Reilly has posted his latest State of the Computer Book Market article. Here are 2 excerpts: “Looking at the Database rollup, we again...

I saw this technique in the Inside Microsoft SQL Server 2005: T-SQL Querying T-SQL and today I saw it also here The OPENROWSET Trick: Acces...

These are the top SQL Searches on this site for the month of July. I have left out searches that have nothing to do with SQL Server or progr...

This article will show you how to get the current identity value from a table and also some things that might act a little different than yo...

Here I go again linking to other people's posts instead of writing my own ;-( Louis Davidson has a nice little entry on his SQL Doctor b...