SQL Server Code,Tips and Tricks, Performance Tuning

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...

I decided to interview Stéphane Faroult, the author of The Art of SQL because it is one of my favorite SQL books. Stéphane told me he has a...

Volunteer Moderators and Answerers who support the Microsoft MSDN SQL Server Forums have launched a Wiki with Solutions for Common T-SQL Pro...

This is how you return all the tables with their last generated identity values in a SQL Server Database SELECT IDENT_CURRENT (table_name),...

Here are the links for this week Database SQL Server 2005 Memory Limits and Related Questions Microsoft to Increase Use of SQL Server 2005 B...