1) It has been my experience that queries are almost NEVER as optimized as my clients think they are.

2) You can pick up tremendous throughput improvements with appropriate data placement.

3)...

That is exactly the kind of statement I was addressing when...

Get SQLNitro from http://www.dba24hrs.com. Tell them TheSQLGuru sent you to get a discount. Really an amazing product designed for EXACTLY your problem.

Jerome (1/7/2008)

---

In SQL Server, the DBA has no "real" control over sorting and cache memory allocation. The memory allocation is decided only globally in the server properties memory folder, and...

I don't recall there being a requirement to encrypt data within an 'appropriately protected' network. I do recall 128bit encryption being the minimum for external data transfer over open...

Carl Federl (1/6/2008)

---

"5. Just TRY to write a set based trigger in Oracle... just go ahead and try!" This can be done.

1. For the triggering table, create two...

Tony Mungor (1/6/2008)

---

OK, now that we have picked on Oracle let's point out a few of its good or unique features.

1. Spatial data is an interesting feature hardly anybody uses....

Does Oracle really not have temporary tables, or is it just non-performant to use them??

I, like Jeff, would be happy to rework this for you at my normal work-from-home consulting rate (which is a good bit less than my onsite rate). And I...

Go to tpc.org to see that all the major players have TREMENDOUS scalability on current hardware. We have lots of options for maximum performance or cost optimization. Not...

One thing I note on the test script is no tlog truncation or checkpoint or delay to ensure that those things (tlog growth for example) didn't affect the timing. ...

With autogrow maintaining your database size you have virtually no chance of having non-fragmented data and indexes. Double or triple the size of the database and then try some...

It can often be both faster and more 'concurrent' to do large-scale deletes in smaller batches on some indexed key. You need a small enough batch size to ensure...

A nested loop query plan is usually optimal when there are small numbers of rows in one table (think 10s to perhaps 100s in most cases) that can be probed...

DBADave, you state "In terms of disk space I have enough free space to accomodate the rebuild of the indexes for the table in my example.". Free DISK space...