Yup, it's all about ARITHABORT. The default for the database is OFF. The default...

Grant Fritchey (6/9/2015)

---

Differences in parameter values or WHERE clause criteria? Use of hard coded values or parameters (either of which is sniffed) vs. local variables (which are not, except during...

spaghettidba (6/9/2015)

---

The SQL Agent job is probably running a different execution plan compared to the one you get when you run the query in SSMS.

The reason might be one among:

*...

TomThomson (6/6/2015)

---

Nice question.

To me it seems rather obvious that if you disable the clustered index then no other index on the table will work because all the other indexes identify...

kevriley (4/26/2012)

---

Wait a minute! What about that "ASC," after the END of the first CASE statement, above? If that CASE statement does not produce output, then wouldn't the...

Small spelling error in the tagline: "introdused" should be "introduced"

Brian J. Parker (6/1/2015)

---

This also got me thinking of another real-world example I've faced. Let's say you have a third-party product that includes a really complicated stored procedure that does...

Have you enabled snapshot isolation on the db?

ALTER DATABASE MyDatabase

SET ALLOW_SNAPSHOT_ISOLATION ON

more here: Snapshot Isolation in SQL Server

Oh, I see you are!

Anyway, what this does is allow continued...

[snip]

This is way slower, it takes, like, 30 seconds to run; however, over in my original window, the delays go up only slightly: they're about 25 ms to 40 ms.

I...

wbrianwhite 33048 (6/1/2015)

---

There are some operations where you don't want to do straight set based because it will lock an important table for too long. My usual compromise is...

pietlinden (6/1/2015)

---

Not a very helpful article. A really helpful article would have gone something like...

Here are some places where you might consider a cursor...

Here are places where you...

ray 64276 (6/1/2015)

---

Cursors can have a higher performance in many cases where dealing with large updates. There are a couple reasons for this:

- The deleted and inserted tables...

LOL!

+1000

Dear Andy,

I'm working through the BIML stairway series as SqlServerCentral and I think I've hit a wall.

I have several instances of SQL Server on my laptop, so I need to...

Bill Talada (6/1/2015)

---

Having read the entire article and all responses, I'm wondering if people benefited at all or just managed to strengthen their ego positions. I think a much...