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...

Do You Have Other Opportunities Open?

Imagine you’re talking with a recruiter about a position that seems like a good fit and during that conversation they...

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....

Notes from MySQL Enterprise Lunch and Learn With Representatives from Sun & Oracle (MySQL 5.5 Now Downloadable)

 
Today we sat through a pizza ‘n pop lunch while listening to a MySQL Offering and Licensing for the company...

Postponing SQL Lunch Presentation Until Next Week

I woke up this morning about 3 AM with clogged sinuses and a fever. Great. The changing weather patterns that...

SQLSaturday #59 - Speaker Interview Series # 12 with Ayad Shammout

 SQLSaturday #59 - Speaker Interview Series # 12 - with Ayad Shammout
Today, we bring you the immaculate interview.  If his sessions are as...

The SQL Rally - Who Would I Vote For?

I was looking over the pre-conference sessions submitted for the SQL Rally event taking place next May in Orlando. I...

Virtual Presentation Tomorrow

I’ll be presenting a practice run at one of my PASS Summit presentations, Identifying Common Performance Problems using Execution Plans,...

Vote For The SQLRally Pre-Con Seminars

Do you know a real-life Pointy Haired Boss? Maybe you don’t work for him, but I bet you’ve met one.
In...

When is that Restore Going to Finish?

I spent a good portion of last weekend restoring databases from backup due to a large release. Nothing went wrong,...