SQL Worst Practices Part4

Making Databases Case Sensitive…..

Thanks to Andy Warren

Download ; read the full article at:

SQL Worst Practices Part3

Not Using Primary Keys and Clustered Indexes…..

Thanks to Andy Warren

Download ; read the full article at:

SQL Worst Practices Part2

Objects Not Owned by DBO…..

Thanks to Andy Warren

Download ; read the full article at:

SQL Worst Practices Part1

In our business we spend a lot of time talking about ‘Best Practices’ – ways of doing things that over time have proved to be the most effective (or accurate, or whatever..). There are a couple problems with Best Practices. One is that there is no ‘book’ of them, they are scattered across a hundred books and web sites and you often need one sentence out of all that information. Another is that whether something is a Best Practice is often less than clear – it depends on your attitude towards problem solving, your experience, your situation. Finally, sometimes Best Practices (let’s just use BP from here on) can be a trap, keeping you from looking at solutions that clearly defy BP but yet might be an ideal solution to your problem.

Interesting so far?

Thanks to Andy Warren

Download ; read the full article at: