Tag Archives: presentations

Common SQL Server Mistakes

Posted on March 7, 2011 by way0utwest

This presentation is designed to cover some of the basic mistakes that I find people making quite often when working with SQL Server. It is a mix of development and administrative items, designed to help beginners get a grounding in … Continue reading →

Posted in Presentations | Tagged , , | Comments Off on Common SQL Server Mistakes

Common SQL Server Mistakes – Functions in the WHERE Clause

Posted on October 27, 2010 by way0utwest

This continues my series on Common SQL Server mistakes, looking at more T-SQL mistakes. What’s Wrong? If you saw a query like this, would you see a problem? select   o.OrderID   , o.CustomerID   , o.Qty from Orders o where datepart( yyyy, … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Common SQL Server Mistakes – Functions in the WHERE Clause

Common SQL Server – Not Indexing FKs

Posted on October 20, 2010 by way0utwest

This series looks at Common SQL Server mistakes that I see many people making in SQL Server. Foreign Keys It’s way too often that I see people building databases without including declared referential integrity (DRI) in their databases. Even when … Continue reading →

Posted in Blog | Tagged , , , , , | Comments Off on Common SQL Server – Not Indexing FKs

Common SQL Server Mistakes – Indexing Every Column

Posted on September 29, 2010 by way0utwest

If one index helps speed up queries, than more indexes should help more, right? They do, but they also come at a price. Both in performance during data modifications (insert/update/delete), and in terms of space since each index must be … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Common SQL Server Mistakes – Indexing Every Column