I would say to modify your trigger's logic to not log the mod's you don't want logged. paul's idea would work, and seems sound enough, but if you could build...

I don't understand, heda_p. None of the conversation has been under the assumption of each raid being a seperate one. What made you think that?

Quite a few of our raid...

He's saying that unless you have profiling set up to catch the login, you won't be able to accurrately map the spid back to the Login using it. Same as...

In a clustered index, the values are there once. They ARE the data.

I build my clustered indexes as light as possible as the data values as keys will be used...

Excellent points Ferguson. Mylex has an Ultra Wide adapter with three channels, up to 128MB cache (32MB standard), that has a battery backup for the cache on the adapter to...

We alias databases for our different enviroments. We create a linked server pointed at the database and give it whatever name we like, In our case: Prod, QA, TEST, and...

I have been doing this for years with stored procs, BCP, and a few control tables. Multiple Import sources, multiple import structures within the same file, going to multiple tables...

What your dealing with is a standard EBCDIC to ASCII translation. There are many different flavors of this, but do a search for "EBCDIC to ASCII" and you'll get tons...

Put quite simply:

The more distributed your IO across available disk platters the better, balanced against needed redundancy.

I like RAID 5 for my data, Raid 10 for my logs and Tempdb,...

Its my belief that the tempdb for a database should be of a size to accommodate the largest transaction that will hit your database. Currently, one of mine is 11...

When you see pageiolatch wait states in EM, it means that your process is having to wait on the disk io to free up some resources. This is further supported...

You could use a case statement to select the greater of the dates into a single field in a correlated subquery, then criterialize in the outer query's where clause.

If you'll...

I know that, greg, I was talking about what you asked, sa defaulting to dbo, but thanks, I wasn't very clear...

Based on a profile workload trace for Disk and Processor IO, we saw a 37% gain in performance by going to active/active clustering with federated servers in our production enviroment....

I make it a habit to use the sa account to create databases for that very reason, and have never encountered any issues from it. Like antares686 though, I don't...