UMG Developer (3/16/2011)

---

mtillman-921105 (3/16/2011)

---

My understanding is that for most current SQL applications, SSD is used for the TEMP DB (for performance). If the drive dies, swap another one in...

Easier way: Slap a GO between each statement.

As mentioned above, please provide DDL and sample data inserts. It will make this easier.

And I want...

2 things.

1) Check the metadata that the excel file is expecting in design manager. My guess is it's sampling the rows and is determining it needs to drop the...

Use UNION ALL, not Union. Union forces a distinct out of the final result.

Rich Yarger (3/16/2011)

---

P.S. Yes - I want the files overwritten each night when the job runs, so when they do their backup to their nearline media device for on-site/off-site...

You don't necessarily want very few VLFs, but that's another discussion...

RESTORE DATABASE [Database1]

FILE =...

Isn't that like saying you're a 'nice' barbarian because you only rape and pillage? 😛

*runs...

Sky, 3 things.

1) How is 7-9AM a single hour? That's 2 hours.

2) You want to use a dateadd/datediff method to get each timestamp to be equivalent in a derived...

And people say there's no good reason...

I...

Travis, I know the kind of shops you're fighting with, but those are actually rare. Apparently, not from your experience, but one of us has had either good or...

quackhandle1975 (3/16/2011)

---

Very well written article, even someone of 10+ years experience its nice to read something and think, I haven't touched on that area of SQL for a while (or...

I think you may have started a new SSC mantra...

Depends on how you build the index and the selectivity of two of the three options.

On a smallish table, you're looking at the speed to load the pages (5 or...