Hey Threadizens,

I've got a confusion that I could really use your assistance with in regards to some strangeness out of the optimization engine. Well, strange to me. If...

Lutz, that is wild. I like it. Thanks. :w00t:

Have you done that on huge recordsets? Does it perform well?

A serial update might work for this, but the implementation would require me to see the underlying DDL for the table and indexing, specifically the clustered index.

For the proper rules...

Steve Jones - SSC Editor (10/20/2010)

---

The presentation talks about people writing "=null" not "is null", and gives the latter as the proper way to test for NULL.

Multi-row triggers are something...

I'd start with doublechecking the ssrs is looking at the correct database and doesn't have a filter you aren't seeing. After that I forget if data cache'ing can cause...

Well, apparently sign me up, shame I'm nowhere near it.

Anyone give me the short form as to why these two are included?

IS NULL

Multi-row triggers

I wouldn't consider auditing an edge...

LutzM (10/20/2010)

---

Is it just because I'm in a bad mood today or why do I have the feeling that todays questions are more demanding with even less effort than on...

SkyBox (10/20/2010)

---

Would like some other opinions on hourly intervals for the differentials. I agree with Pavan in the sense that this is the cleanest and quickest approach, but considering...

valeriepobeda (10/20/2010)

---

What I am trying to understand is: I calculated all databases and I got 61586.55 MB in databases memory,on sql server max memory I have 8115 MB, on the...

What GSquared is talking about and is a slightly different approach than what I mentioned would be something like this. It's just as valid and may or may not...

Unless I seriously missed something, your code and his sample data will...

There's no simple way of getting this out of a view because the view won't easily be able to create data on the fly. I can see a way...

jrbass81 (10/20/2010)

---

A lot of things I have read indicate that I should be processing all changes as set-based transactions, and that looping is BAD. But, I am trying to...

Short Answer: DECLARE CURSOR

Longer Answer: What are you trying to do? Most of the folks around here know many, many ways to avoid actual row loops and still get...

Steve Jones - SSC Editor (10/19/2010)

---

I think there's a little elitist mentality, but someone ought to know how to do this in scripting. It's much more efficient, especially when you...