MS SQL Server Book of Wisdom - Andrew Calvett

MS SQL Server Book of Wisdom

Published 21 May 2008 18:07

This blog has been migrated to blog.calvett.co.uk. Please update your feeds.
This post can be found here.

 

Filed under:

Comments

# steveh99999 said on 22 May 2008 11:09

Your friend is a comedy genius ;)

# ACALVETT said on 22 May 2008 11:20

Or maybe we just don't get out enough.  :D

# robcarrol said on 22 May 2008 11:27

LOL, very funny post :-)

# steveh99999 said on 22 May 2008 11:53

A few more...

always put your transaction log on the same disk as your data. the disk has less distance to move then....

RAID mean redundant disks. Why waste money on disks which are redundant ?

Regularly test your DR plan but randomly pulling disks on your production system

instead of buying expensive new hardware. Use virtual server and allocate your databases extra disks this way...

SQL injection is only a problem if you insert data into your database. Disable all your triggers to get around this...

DBCC Checkdb - this is a really old command, no-one uses it anymore..

High availability is a waste of time and slows down performance.

adventureworks is important. never delete it...

SQL is more efficient if you write as much as your query on one line as possible. it's faster to parse....