The ESTIMATED execution plan says it's...

I find the report of DBCC CHECKDB useful.

Why doesn't "SELECT COUNT(*) FROM table" look at an index, which apparently it doesn't(?)

jacroberts (8/25/2009)

---

---

11. More WHERE clause hints - Avoid unnecessary conditions in the WHERE Clause. Also try to avoid a function in the WHERE clause as it presents SQL engine to...

Lynn Pettis (8/24/2009)

---

I understand that what you wrote was an illistration of how IN works. My point is if you actually write a WHERE clause like that, you would...

Jim in Arizona (8/20/2009)

---

Yea, it's not my day, let me tell ya. It sounded good though....

Wait, isn't that backwards? IN...

Re SET and SELECT, is there a realistic scenario OTHER than capturing previous statement's @@ERROR and @@ROWCOUNT where a single statement must be used? I think it's the only...

I repeatedly forgot that the point of the article was performance - assume that processing of IPv4 address data is critical, how do you best store it?

Processing is likely to...

I was on that in another discussion. It doesn't...

How about if you do a two-stage conversion - from octets to binary(4), and then CAST to int? Does that hold the same 4 bytes internally? Does that...

lhowe (8/19/2009)

---

Darn it HansVE, you beat me to the punch! I was going to say exactly the same thing. I don't see why someone would go to all...

Cliff Jones (8/19/2009)

---

If you rely on implicit conversion, is it going to convert the CHAR to DATETIME or DATETIME to CHAR? You are never really sure so you...

Is there a way to specify a constant date/time that isn't

" SET @date = '2009-08-19' " ?

(Or "CONVERT" from the date encoding of your choice, I suppose.

Or "SET...

Well, since you want a live application database to have no CHECKDB faults, and the recommended way to remove faults is to restore... Of course you can rename the...

Paul Randal (8/18/2009)

---

No it doesn't - can...