Tom.Thomson (2/22/2011)

---

For good performance, the partition offset has to be a multiple of both the stripe size and of the allocation unit (but sensible people never build systems where the...

Thanks for the question!

Tom.Thomson (2/20/2011)

---

Good question, but the explanation says that WIndows 2008 always succeeds in doing the alignment needed. This is not correct. Windows 2008 will align the partition by...

Thanks for the question, I think it is good to bring attention to this. (I just wish there was a better/easier/more reliable way to get everything lined up through the...

Great article, thanks!

Tom.Thomson (2/18/2011)

---

That somewhat throws me. How do you get better performance out of RAID 5 than out of RAID 10 for the same data size? An array of...

SQL Prompt 5.0.1 has problems with CTEs that cause SSMS to be really slow. They say that it will be fixed in 5.1, or you can contact support to get...

One of the problems came back to me that occurs when you use a column from a table outside the sub-query without qualifying it, because it is unique now, and...

lnoland (2/18/2011)

---

Really? I've been doing correlated subqueries that way for quite awhile and never had any problems. I would have thought that if the compiler did not give...

Les,

I see you basically came up with the same solution as mine, but you didn't alias the tblCaseLog table in your NOT EXISTS query, so it has ambiguous columns and...

How about something really simple like this:

SELECT

C.CaseID

FROM tblcase C

WHERE

C.closedate = ''

AND c.casetypeid in(100, 101, 102, 131)

AND EXISTS (SELECT NULL FROM tblCaseLog...

Did you see the solution that Jeff posted just prior to your...

Nice little script, but it will return multiple rows for partitioned tables. Here is an updated version that takes care of that:

SELECT

o.name AS "Table Name",

SUM(i.rowcnt) AS...

Tom.Thomson (2/18/2011)

---

If your data is sufficiently important to need...

Thanks for the question! I was surprised to see the number of incorrect answers, I thought this was pretty much common knowledge.