If you want to understand indexes get along to an event by either Kimberley or Kalen ( delaney ) I can guarantee you'd find it money well spent!!

As for DTA...

Unless I'm forced otherwise I've always worked with the o/s and binaries seperated, although they could be on the same physical mirror just divided.

I always split tran logs, data and...

reads and writes are page ops which isn't always the same as table row/column updates.

If you create a table just over 4k wide, each insert should generate a page write.

If...

It all depends upon the actual error, I haven't had too many but I recollect that a backup which contains an error will not usually restore so you get an...

This is well documented on ms website. You certainly don't have to be logged in to use an outlook client, whoever told you this is talking rubbish. There are many...

assuming your server is a dedicated sql server then I'd advise making the min and max memory settings the same.

You say it runs slower - with regard to what?  The...

If you get a copy of the resource kit, included in msdn and technet subscriptions, there is an electronic interactive view of the system tables.

sysobjects and sysindexes are local to...

I'm not a great lover of stats vs indexes. I'd look at the query plan myself. You do have the option of profiling your query, add the stats, then profiling...

Where are the Darwin awards when you need them!!!

I'd check your logic with the dates .. do you use the exact same query in QA or just the last statement?

btw you shouldn't really need the set commands inside...

very nice!  adds more leverage to the power of sql server, and as you say would produce excellent olap cubes. excellent article.

A good DBA test is to figure out how many different methods you can employ to identifiy and remove duplicate rows.

I find common causes of duplicates include, assuming an identity...

I have a proc I use to return job data including last run, it uses three functions too otherwise I'd just post it. send me a private message with an...

Having worked with SOX for a number of years I'd take exception to the statement SOX requires disabling RPC connections - sorry that's absolute Tosh !! If your systems talk...

oops! I just realised my previous post might be taken the wrong way <grin > directed to Praveen.