Common SQL Server Mistakes – Functions in the WHERE Clause

This continues my series on Common SQL Server mistakes, looking at more T-SQL mistakes.

What’s Wrong?
If you saw a query like...

Have You Grabbed the SQL Sentry Plan Explorer Yet?

I won't say I despise SQL Server Management Studio's (SSMS) display for execution plans, but it's about at that level....

Sitting in Judgment

I have been meaning to write this for a while, but i wanted to wait for a break in SQLDrama....

SQL Saturday #49 in Orlando - Plus Run SharePoint Locally

Ok so I know this is late, but I wanted to thank Jack, Andy and the team at the Orlando...

Are you Living under a SQLRock ?

I don’t mean a LaRock aka SQLRockstar, but an actual rock.

I was at dinner last week after our all...

You know you want it! - SQLRally Precon Voting

For those of you who have seen our team present, we always do our best to make it really informative,...

Motivational Monday (On a Tuesday)

Hey Gang,

Sorry for the absence. I have been offline for a bit dealing with some family stuff. All if good...

PASS SQLRally Pre-con Voting Is Open

I'm happy to announce that voting for the 2011 PASS SQLRally Pre-con sessions is now open! There are four tracks:...

SQL Rally Cast Your Vote!

Pre Conference seminar voting is up now.  Go make it happen!  Here's the description of our session:
Title:

Business Intelligence Workshop
Speaker:Patrick LeBlanc,...

SQL Rally: One Day on Query Performance Tuning

The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This...