Robert Frasca (3/4/2008)

---

"Some of these shouldn't be allowed in my mind, like RAID 0 disks, which wouldn't be in a production system. "

I don't understand this line. I've seen...

Is this thread supposed to be about something posted by Jeff Moden? What is the link to it?

I was just kidding about the correlated sub-query; I wouldn't use it.

I locked horns with Celko on this very issue about 12 years ago on the old Compuserve SQL Server...

Of course, you could go old-school with a correlated sub-query. Celko would be so proud of me…

select

RowNumber =

(

select

Cnt = count(distinct b.VatCode)+1

from

Partner b

where

a.VatCode...

Do queries like this as a selection against a range in this form:

where date >= @StartOfRange and date < @EndOf Range

In the following code, it will be the same as...

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

tosscrosby (2/28/2008)

---

We have low volume of transactions here and a user "loss of data" threshold of one hour so the hourly log backups work fine (for now). I appreciate the...

I usually recommend running log backups much more often; every 15 minutes, 24x7, is a good place to start.

As long as you apply all the log backup files in the...

Logs can be applied to a DB restored from any full backup.

You have to have all of the logs, so you have to apply more logs for the older full...

Script to analyze table space usage

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

Look to see if there a an HBA adapter installed and if it is active.

Olja (2/28/2008)

---

This has been an very insightful problem to have. Next time we'll keep in mind the performance penalty of combining the views. As it turns out the culprit was...

Use datatype SYSNAME.

You can't do that with a restore.

A restore will create files that are exactly the same size as when the backup was run.

Sean Grebey (2/26/2008)

---

Oh, well if you look at it in the actual list...