SQL Server Code,Tips and Tricks, Performance Tuning

Omnibuzz has posted the following challenge: A scenario to ponder #1 This challenge is about returning a random number of customers and retu...

That great company Red Gate has released a public CTP of their latest tool SQL Refactor. Thanks to Louis Davidson for sharing this info, you...

Channel 9 has three screencast about Team Edition for Database Professionals Team Edition for DB Pros 5 min Demo "I'd like to intr...

Here is a quick SQL Server teaser Create the following table CREATE TABLE [barney ] ( barneyId INT ) Then look at the following 4 statement...

Below are the top 5 posts according to Google Analytics for the month of September 2006 in order by pageviews descending Login failed for us...

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

How I wish I had more time and needed less sleep (less than the 4-5 hours I am getting now) I am very excited about this book and will for s...

So this Prime Number challenge won't die, the other day I wrote about it in THIS post. Rob Farley from Down Under let me a comment with...

If you want to use the ISDATE function to convert a value to a SMALLDATETIME you also have to take into consideration that SMALLDATETIME sto...

Channel 9 has a two part podcast with Roger Wolter about SQL Server Service Broker. WMA, MP3 and Video formats are available for download Fr...

That's right! What is more cool or sexy than Query Optimizations? It doesn't matter how beautiful or complex your data model is, if ...

Sometimes you are asked by the front-end/middle-tier developers to return a rowcount as well with the result set. However the developers wan...

So here we are one year and 236 posts later. I can not believe that it has been one year already. First of all I will make 2 small changes. ...

That is right folks; SQL Server is capable of returning all 78498 prime numbers between 1 and 1000000 in 3 seconds. Who said that SQL Server...

I have answered a bunch of questions over the last couple of days and some of them had to do with returning values from stored procedures Ev...

There seems to be a misconception that when you issue a TRUNCATE command against a table you will not be able to roll back. That simply is n...

A while back I wrote about DDL trigger events in a post named DDL Trigger Events Revisited And I claimed that this stuff wasn't document...

Do Not Concatenate VARCHAR and VARCHAR(MAX) Variables, what happens is that the whole string will be implicitly converted to varchar(8000) R...

Here is something handy: Announcing O'Reilly Code Search, where you can enter search terms to find relevant sample code from nearly 700 ...

If you are not a consultant and you work for a company then does your company have a corporate standard for development languages/products? ...