« The Dangers of Failing to Understand T-SQL’s DISTINCT and GROUP BY | Main | Philly.Net Code Camp presentation – The Fine Art of Stored Procedures and User Defined Functions »
Tuesday
May042010

Debunking SQL Server Myths

DateTuesday, May 4, 2010 at 3:51PM

Paul Randal of SQLSkills has completed a nice series on debunking misconceptions of SQL server.

http://www.sqlskills.com/BLOGS/PAUL/category/Misconceptions.aspx

Some of the things I knew, some I was completely wrong about and others I just didn't know about.  The bulk of the misconceptions I had stemmed from working with SQL Serve since the mid 90’s going back to version 6.5.  You do your best to learn and keep up with the new releases but can get caught in the trap of not knowing some detail you once knew has changed.

Focusing on just the new features is not enough.  We must also take the time to learn the details and some internals of things that are changed.  They can have real implications of who database should be designed and optimized.

AuthorJoshua Lynn | CommentPost a Comment | Reference1 Reference | |

References (1)

References allow you to track sources for this article, as well as articles that were written in response to this article.

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.

Notify me of follow-up comments via email.