Thanks Tim. I will add this to my tool-set.

Elliott W (3/10/2010)

---

I'm wondering if any of the "regulars" would be interested in peer-reviewing an article related to SSIS processing concurrency. I've had a lot of questions lately in...

HAHAHA

I look forward to the weekly comic. Helps the week go by faster.

Lynn Pettis (3/10/2010)

---

GilaMonster (3/10/2010)

---

I'll give my standard answer here.

Memorising questions will not help you in an interview. An experienced interviewer can easily tell the difference between someone who knows the...

Fair enough.

Yes, I have done it hundreds of times. I use it to...

YSLGuru (3/10/2010)

---

Jason - In our particular case, for just this one server it actually would take less time to switch over to the standby server and while it is in...

Steve Jones - Editor (3/10/2010)

---

OK, OK, some funny replies in here. The question was badly worded but let's not scare someone away from posting. I'm sure there is a valid...

perturbed (@ idiot family members)

Chris Morris-439714 (3/10/2010)

---

Aha, I think you mean...

sanketahir1985 (3/10/2010)

---

better use foll script

-- Create the temp table for further querying

CREATE TABLE #temp(

rec_idint IDENTITY (1, 1),

table_namevarchar(128),

nbr_of_rowsint,

data_space_KBdecimal(15,2),

index_space_KBdecimal(15,2),

total_size_KBdecimal(15,2),

percent_of_dbdecimal(15,12),

db_sizedecimal(15,2))

-- Get all tables, names, and sizes

EXEC sp_msforeachtable @command1="insert into #temp(nbr_of_rows, data_space_KB,index_space_KB) exec sp_mstablespace...

Kimberly L. Tripp (3/10/2010)

---

Hey there everyone - I know people are feeling like was trying to trick them in the question but I guess the "always" part is what I...

sameerchachad 69959 (3/9/2010)

---

A

So, when you are saying that IF a Clustered Index already exists, then your what you are mentioning is valid. Else the Primary key, which is usually created...

Ha nice pun. See, the...

Floors - wouldn't it be rack?:-D