Daily Archives: October 27, 2010

The Hybrid

Posted on October 27, 2010 by way0utwest

I’m off to SQL Server Connections next week and looking forward to the conference. This is my first time attending, but I have wanted to go for some time. This is one of the few events that is not specifically … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Hybrid

The SQL Rally – Who Would I Vote For?

Posted on October 27, 2010 by way0utwest

I was looking over the pre-conference sessions submitted for the SQL Rally event taking place next May in Orlando. I think it’s great that the community gets the chance to vote on the submissions and help decide what will be … Continue reading →

Posted in Blog | Tagged , | 1 Comment

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