This is like fixing bad parameter sniffing.  In order for the execution plan to change, there had to be a recompile.  Causing a recompile is frequently the fix for bad...

It's easy... just hit the "Go faster" button.

Its Solved i...

if you look at recursive CTEs you can build a list of dates within your boundaries

then use SELECT DATEPART (DAY,GETDATE()) and exclude the Saturday and sunday values then...

I've not checked but even if the documentation and every MVP in the world said "Yes, that'll work",  I'd try it on a couple of test systems first.  My recommendation...

You also have to remember that, on sys.dm_db_index_usage_stats, things may not be as they seem.  For example, you might have 1 "UserRead" (UserSeek, UserScan, UserLookup) per day and tens of...

We had a person at my old job.  She was ALWAYS on the phone.  I got curious as to why and so I discreetly "hung around" for a...

One of my favorite bosses in times past had a wonderful saying that...

Just to add to what John has stated, I've found that a lot of the code that fails really needs a rewrite anyway.  If you can't fix a piece of...

Oh yeah... almost forgot... a "Coding'n'Formatting" standard goes a hell of a long way when it comes to readability during troublshooting or modifications.  I do 100% peer reviews for the...

The flower box in code is absolutely essential and just about the only place where documentation won't accidentally get lost.  Someone would have to make an effort to delete it. ...

oooh points, that gamification that gives you a sense of achievement on a website. sadly it's quite a hook for newbies, but you get a lot of "trawlers" that...

I don't think it helps that there are many, on certain websites (cough Stack overflow cough) that don't help the situation by answering the questions for these people, just...

I've got mixed emotions here.  First, I do agree that the best of us will make mistakes.  No question about that.

But that's also why we have certain procedures at work...

I don't recall the syntax off of the top of my head but there's some code to tell SQL Server to use the old cardinality estimator, which is what this...

I guess we need to back this truck up a bit.  I made the mistake of assuming that since you said you wanted to replace the table, that there wouldn't...