Interesting question that took some thought. Thanks for the explanation Hugo.

David Burrows (3/6/2012)

---

John Hanrahan (3/6/2012)

---

Glad you all enjoyed the question. I enjoyed the 'whininess' and 'pendaticness' of some of the responses. It's all good.

At least I got a...

george sibbald (2/28/2012)

---

explains the deja vu.

now we need a question on which role...

Very nice. Thanks for sharing this.

Henrico Bekker (2/24/2012)

---

Erm....the answer options were incorrect. only 1 option was correct.

select * from sys.dm_service_services --<-- As in the question, this doesnt exist

select * from sys.dm_server_services --<-- As in the...

Kalen Delaney's SQL Server 2008 Internals is a...

I have never seen the term Grace Hash Join before and I have been doing this for a long time. Is it named for Grace 'The Great' Hopper per...

L' Eomot Inversé (2/18/2012)

---

Cliff Jones (2/18/2012)

---

DBA_Dom (2/17/2012)

---

bitbucket-25253 (2/17/2012)

---

SQL Kiwi (2/17/2012)

---

This is completely the wrong approach,...

DBA_Dom (2/17/2012)

---

bitbucket-25253 (2/17/2012)

---

SQL Kiwi (2/17/2012)

---

This is completely the wrong approach, in my opinion. I...

SQL Kiwi (2/17/2012)

---

Nothing always works :-). FORCESEEK will result in a plan with a seek operation on the hinted table...

cengland0 (2/14/2012)

---

Cliff Jones (2/13/2012)

---

Yes, that was the way I always did it also. It was very fast but then you had to deal with all those pesky named constraints...

bminch (2/14/2012)

---

While its certainly easier to use brackets/parenthesis around @sqlstring don't forget about sp_executesql.

declare @sqlstring nvarchar (255)

set @sqlstring = 'use ' + 'master' + ' dbcc showfilestats'

execute sp_executesql...

L' Eomot Inversé (2/13/2012)

---

Great question, very well presented.

In the bad old days of SQL 2000 I used to solve this sort of problem using sp_rename.

Something like

if exists (select *...

The question could have been worded a bit better but a good question none the less and an interesting discussion as always.

ganci.mark (1/31/2012)

---

Great article David. Thank you.

I thought that there were limits imposed on the various memory components based on on the total amount of memory given to SQL Server.

For example:...