Basically, we do not have enough information to answer this question in...

Agreed.

Paul S. Huebner (5/15/2009)

---

1.) I understand (maybe incorrectly) that in a filegroup with multiple files, any table created or moved to that filegroup will be distributed across all files in...

Um, how is a NULL represented in a CSV? Especially if you do not (or cannot) have text delimiters defined?

Then yes, in the CSVs the "%" counters come out as "99.99".

I have read several (including some mentioned here) but I cannot say that I was very pleased with any of them. They all seem very spotty in their coverage...

starunit (5/15/2009)

---

RBarryYoung (5/14/2009)

---

If you have a *very* small number of constants and their speed is *really* important, then you could make a constant scan in a View or an inline...

Suresh B. (5/15/2009)

---

A single Log files is sequential....

fjmorales (5/15/2009)

---

Those the counters Processor(*)\% Processor Time, Processor(*)\% User Time, Processor(*)\% Interrupt Time come with the...

Lee Hart (5/15/2009)

---

The part of this issue that still doesn't make a whole lot of sense to me is why it would perform in under 15 seconds on a slow...

Here's a script demonstrating the problem, using your current code example, Natasha, along with the code that Sam provided showing how to get CASE into the WHERE clause:

--====== First Create...

Luke L (5/15/2009)

---

I live near here

View Larger Map

For all you folks out in Mass, I'm planning a trip trough Boston up to the Cape this summer. Any...

Natasha:

That's actually not a bad way to go. Your instinct might be to combine all of these into one big master query that uses the parameters...

Dude! We're practically neighbors!

Paul White (5/14/2009)

---

Hey, that looks pretty sweet!

Real flat too - do you have *any* hills or...