Personally, if you're going to go through the effort of maintaining separate file groups, you need the separate physical spindles to get the true benefit from them for optimization. ...

drew.allen (12/8/2010)

---

How does the 'GO' in the dynamic @sql stop the proc from compiling correctly? It doesn't, because it compiles and executes just fine on my system. The...

traughberk (12/8/2010)

---

I just looked at the data to find some columns to create the clustered index and there aren't any combination of columns that are consistently unique in the entire...

Nope, got one stiffened into a kneeboard, though.

I'm pretty sure I'm underqualified too, but I can't resist sometimes.

Jack Corbett (12/8/2010)

---

GilaMonster (12/8/2010)

---

Jack Corbett (12/8/2010)

---

Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long. There isn't any...

You're welcome. If there's any bits and pieces of that you don't understand come back and ask. You're going...

SELECT

drvStart.ResourceID,

DATEADD( mm, DATEDIFF( mm, 0,...

Jack Corbett (12/8/2010)

---

Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long. There isn't any of you that...

GSquared (12/8/2010)

---

You're getting a clustered index scan on the PortSecAgg_staging table per the execution plan. An index with BatchGroup as the leading edge, and the rest of the columns...

jayoub1 (12/8/2010)

---

Is there a way that in SSMS query window I can determine how many records are effected by an update or insert query before running it.

I support...

teutales (12/8/2010)

---

Hello,

I'm new to ServiceBroker. I want to rebuilt the indexes on an express server every night with the service broker. So my target is one servicebroker which manages all...

Randy, I believe this is what you're looking for, but honestly, not entirely sure:

ISNULL( <FIELD>) = TRUE ? NULL(DT_DATE) : (DT_DBTIMESTAMP) <FIELD>

CirquedeSQLeil (12/8/2010)

---

Grant Fritchey (12/8/2010)

---

Yeah, I'm looking forward...

Well, the first thing I'd ask is what grunt work would you like to be able to offload to these interns? Are these first year interns (so I'd assume)?

First...

I broke this into CTE's because it's easier to see the methodology that way. You could do this all in one query if you wanted. The key is...