SQL Server Code,Tips and Tricks, Performance Tuning

I haven't posted for a while because I have been working on SQL Admin Hacks, Tips and Tricks lately. it is still a work in progress but...

SQL Server 2008 Release Candidate 0 has been made available to the general public. There are 2 versions (and 3 flavors of each) ISO or DVD D...

There is a puzzle on LessThanDot The goal is to identify all friday the thirteenths for a given timeframe. We'll use a relatively small ...

Myself and a bunch of friends have been working on Less Than Dot for a while now. The site has a forum , blogs and a wiki . More info why w...

Create this table CREATE TABLE #bla (SomeVal uniqueidentifier) INSERT #bla VALUES ( 'D903D52D-DBFA-4904-9D95-F265152A391F' ) what ...

I have interviewed Erland Sommarskog, you can find that interview here: Interview With Erland Sommarskog About SQL Server and Transact SQL E...

I interviewed Craig Freedman about Indexing, Query Plans And Performance and more. You can find that interview here: Interview With Craig Fr...

Last week Kalen Delaney wrote Did You Know? I have a question for you on DBA Blunders! I though the comments were very interesting, S we di...

I did some spring cleaning yesterday, I got rid of some old or obsolete books. I asked some people at work if they want any of these books a...

Mladen Prajdić just released SSMS Tools PACK 1.0 . SSMS Tools PACK is an Add-In (Add-On) for Microsoft SQL Server Management Studio and Micr...

This question came up today and here is one way of doing it. It requires running xp_cmdshell so this is probably not such a good idea. The ...

Without running this what do you think will be printed? SET ROWCOUNT 0 DECLARE @ int SET @ = 6 IF @@ROWCOUNT = 1 PRINT 'yes' E...

I was asked by a developer at work the other day why SQL Server does not have the create or replace syntax. I started thinking and there wer...

In the Who do you want to see interviewed next? (sqlblog) and Who do you want to see interviewed next? (here) blog post I asked for some nam...

In the Who do you want to see interviewed next? (sqlblog) and Who do you want to see interviewed next? (here) blog post I asked for some nam...

HTML Source EditorWord wrap I answered this question on the MSDN forums: How can I search all my sprocs to see if any use a function? Severa...

I found this SQL Server Testing (not unit but vulnerability) page and decided I would post a link to it since it has some useful stuff. The ...

I have interviewed a bunch of people already, some of them on this blog and some of them on SQLBlog Below is the list of all the people so f...

This one is a little sneaky, don’t send me hate mail for it. What does this return? SELECT ISNUMERIC ( '+' ), ISNUMERIC ( '–...

If you have a table and you want to rename a column without using the designer, how can you do that? First create this table CREATE TABLE T...