SQL Server Code,Tips and Tricks, Performance Tuning

Yes it looks like it is a done deal: News Corp. Appears to Have Enough Votes to Clinch Deal Bancroft family members owning 32% of Dow Jones...

You set up your linked server, you write a query which joins two tables, you execute the query and the error message is this Cannot resolve ...

Tomorrow 300 is coming out on DVD. Have you seen 300? Are you going to buy it or rent it? I did not see it but I ordered the Widescreen Two-...

This one is not so much a teaser but it will show you what you can do in case you want to insert data in a logging table after a rollback oc...

Visual Studio Team System 2008 Beta 2 Team Suite (VPC) Microsoft Visual Studio 2008 is the next-generation development tool for Windows Vist...

Here is an update of what I accomplished in the first 10 days Read the book lifehacker Read the book Microsoft SQL Server 2005 Integration S...

http://www.tek-tips.com/viewthread.cfm?qid=1391668&page=1 here is the question I have a situation where a person can have more then one ...

Visual Studio Team Edition for Database Professionals Service Release 1 has been Released Overview This service release addresses the top is...

SQL Down Under has made available their latest podcast. From the site: Announcing show 23 with SQL Server MVP James Luetkehoelter. In this s...

Here is another quick teaser. What will be the values of the print statements? Try to guess it before running this code SET ANSI_DEFAULTS ...

Without running the following two blocks of code what do you think will the output be? /* code 1 SELECT GETDATE() GO */ SELECT GETDATE () /...

I have uploaded some pics on Flickr that I took a while back. There is Paris, Amsterdam, Hawaii, Croatia and New York. Two of them you can s...

Don't worry they got it back to work, watch the video here: http://www.scaryideas.com/video/3017/

HTML Source EditorWord wrap Today my twins are one year old . It is supposed to be a little easier from now on (until they hit 2 that is). H...

I just listened to the latest Hanselminutes podcast: Be a Better Developer in Six Months Scott Hanselman asks “what are you going to do in t...

What if I told you to take your latest production backup, restore it on a different machine and try using the database? Are you comfortable ...

Over the last year, Tom Davidson has been working on a tool called DMVstats with some of his CAT colleagues. DMVstats collects performance o...

Okay one more quick teaser You have this date '2007-01-01 00:00:00.001' When adding 1 or 2 milliseconds to that date what will be th...

First create this table CREATE TABLE #DateMess (SomeDate datetime ) INSERT #DateMess VALUES ( '20070710' ) INSERT #DateMess VALUE...

I know a lot of us don't just work with SQL Server so I decided to share this one Oracle today introduced Oracle(r) Database 11g, the la...