There are two drawbacks to that function:

1. It is undocumented and therefore unsupported.

2. As with all scalar functions, it is invoked once per row. That makes it slow.

There are...

One Dairylea triangle to four bottles of Merlot...? 😀

Any CLI language will do...let's not forget the VB guys out there (Barry) or those that...

Jeff Moden (6/29/2010)

---

Heh... yeah... my trusty 9 year old desktop at home is still 32 bit. "It takes a lickin' and keeps on tickin'!":-P It also helps me...

Very nice, Gaby!

Agreed. One other important caveat - anyone running 32-bit SQL Server (why?) should go with a Tally solution too. SQLCLR and 32-bit servers are not a good fit...

Hey Simon,

For my part, I think it's important to understand how the...

When I saw the England goal on TV, first time and at real-time speed, I had no idea if it was over the line or not. I'm sure it's...

Jeff, yes you're right - the table spool (or some other blocking operator) only appears in update plans because it is there for Halloween protection. The optimiser is smart...

Table definition?

Row count?

Lynn Pettis (6/25/2010)

---

Steve Jones - Editor (6/25/2010)

---

PASS. No interest in flying 64 hours to ski for a couple days.

Send me pix, I'm happy to wait for Oct here. I went...

Tara,

How many records will be left in the table after the delete?

Lynn asked that before but I think you missed it.

Run the following query to give the answer:

select count(*) from...

It has been known 😀

I'm off to bed (3:20am!), so I'll leave Tara in your capable hands for the bulk load stuff....

The South Island resorts have good skiing most of the year 🙂

Mount...

As a general rule, always do 🙂

If you change an existing...