Wow, this is really useful. I would finish this off with

ORDER BY DUPE1.schema_name, DUPE1.table_name, DUPE1.key_column_list

which shows how many hits we're getting :crazy:

I've got a bunch with the same or...

Good demo and explanation of this warning. I don't know how many times I've seen this and blown right...

Larry, I'm trying to do something similar in a user DB, get the minimum dates in their tables to see if there's an opportunity to implement a data retention policy....

Thanks for this. I've always wondered how to get the current state of these SET options; @@Options!

Ken

brad_bowzer (10/2/2015)

---

I wrote a system in MS access in 1993 and upsized it to SQL Server in 1996. Its been updated constantly but the core is much the same...

However I do believe we need to test our code. We all do test our code, even if it's with a few before/after queries. What I don't get is why...

chill8 (8/7/2015)

---

At Ford in the group I am currently in we don't do any team building since the team is of a global nature. So it makes it hard...

sgmunson (6/26/2015)

---

Jacob Wilkins (6/26/2015)

---

In 2012 you still have to enable 2371 to get the new auto update behavior. It's easy to confirm following the same methodology as used here: http://www.sqlskills.com/blogs/erin/understanding-when-statistics-will-automatically-update/.

I...

Thanks everyone. Even on a 120M row table SQRT(1000*<num rows>) is only a 350k row threshold. I'm bringing in at least that many every night. So not sure why they...

In SQL Server, I believe a Differential backup solves some of this problem.

Ken

Can you squeeze all that into 15 characters?

Where I work, we host thousands of servers for hundreds of clients, so we have to be organised about server naming. The first 3-4 letters indicate the overall system, then...

Nice, thanks for this article. When you deploy, at least the 1st time, you have to go find the .ispac file. You should be able to deploy straight from Visual...

Gail Wanabee (4/24/2015)

---

I've seen code reviews required in some shops, little or none in others.

My personal execution: I almost always ask for a code review from a co-worker, even if...

Jeff Moden (4/23/2015)

---

The key is that because we do 100% peer reviews and the code runs the gauntlet setup by our wonderful QA team, we've only had 4 such emergencies...