Great, great article Ed!

I am better now Jeff, thank you for asking. I dislocated a rib last week. Got it fixed this weekend. All better now. No more softball for me until next...

Luis - I completely flaked out and missed this message. I am truly sorry and feel like a jerk. I fixed the my code and...

Jeff Moden (7/17/2014)

---

Alan.B (2/7/2014)

---

Using the tests below: at a million rows PIVOT generates a parallel plan and is like 4X faster. At 5million they both produce parallel plans and...

I think I know what Post you are talking...

Jeff Moden (7/10/2014)

---

To that, I say... are you sure?...

aochss (7/10/2014)

---

Please, please make the error/warning messages better and more precise...Nothing worse than something like this:

Msg 8152, Level 16, State 14, Line 1

String or binary data would be truncated.

The statement...

Phil Factor (7/10/2014)

---

Here is a LTRIM function that works for whitespace

[font="Courier New"]

    -- does a particular procedure  exist

IF EXISTS ( SELECT  1

            FROM   information_schema.Routines

            WHERE   ROUTINE_NAME = 'LeftTrim'--name of procedire

                    AND ROUTINE_TYPE = 'FUNCTION'--for a...

ISNUMERIC('-') returns a 1. Discovered that this week (at an inconvenient time no less).

It's worth noting that these are referred to as Compound Assignment Operators and you can use them for multiplication (*=), division ( /=), modulo (%=), and a few bitwise...

Great article, 5 stars. I new nothing about this. Learned something new today already!

Two key books:

I don't know what version you are considering but...

No prob. Glad to help!

Eirikur Eiriksson (7/8/2014)

---

No need to complicate things, the only thing needed here is correct window specification for the row_number function.

😎 ...This brings the cost of execution for this code...

+1

Hey, thanks for the smart-*** remark. I'm looking for alternatives to using a cursor here. If...