SQL Server Code,Tips and Tricks, Performance Tuning

Go to DotNetRocks, download show number 300, fast forward to 57:45 and start listening. It is the funniest geek story I have ever heard. You...

These are the best posts according to me, it might have been the content or it might have been the comments. Either way here are the 21 + 1 ...

Red Gate have released Red Gate SQL Data Generator 1.0 Beta From the site: This tool is aimed at generating test data for SQL Server databas...

This is the final part of this series. You can find the first two parts here Part 1 The Phone Interview Part 2 The face to face interview. A...

This is priceless Alien VS Predator picture In case you wonder which one the predator is, here is a hint one of them preys on children :-)

Posted here at the microsoft.public.sqlserver.programming forum Hello world. I had some problems with my business. My name is Noor Hisham ...

CDC or Change data capture is a new feature in SQL Server 2008, which is an ability to record changes to table data into another table witho...

Sole, Shrimp, White Wine, Herb de Provence, Tomato Paste, Shallots, Onion, Garlic, Parsley, Pepper and Salt make for a great dinner

blah!bLaH!BLOG has a couple of posts about SharePoint and SQL Server Reporting Services SharePoint and Reporting Services - Introduction Sha...

My wife let each of the kids open one present already because they might become overwhelmed tomorrow This is the biggest nonsense I have eve...

Stop the press, Internet Explorer 8 Passes ACID 2 Test Britney Spear's sister is pregnant Aliens seen crossing the border, these are not...

I noticed that Joe Celko has a new book coming out soon: Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL ....

Let's say you have the following transaction BEGIN TRANSACTION TranA BEGIN TRY DECLARE @cond INT ; SET @cond = 1 END TRY BEGIN CATCH P...

Do you use this IF ( SELECT COUNT (*) FROM SomeTable WHERE SomeColumn = SomeValue ) > 0 Or do you use this IF EXISTS ( SELECT * FRO...

When I visited http://www.gnet.com/ today I got greeted by the following error messages. These messages should never be seen by users. Wha...

Amazon launched a database in the cloud. Amazon SimpleDB is a web service for running queries on structured data in real time. This service ...

Channel 9 has posted a lot of Business Intelligence screencasts. In case you are bored below is the list. Strangely enough they skip numbers...

Okay it is not Dr. Jekyll and Mr. Hyde but I had to come up with a title. This was a question someone asked yesterday in the sql programming...

Have you ever needed to find your most expensive queries and quickly grew weary of writing T-SQL against trace tables to try to ferret them ...

This should trip up some people..... Without running this code what do you think will LEN and DATALENGTH return? DECLARE @i int SELECT @i ...