Jeff Moden (11/1/2010)

---

Damn! There is a trade off. If you don't know there's going to be dupes or not, pray for dupes when you use it.... Still,...

Thanks. It's a fair while ago now, so I don't remember exactly what the...

Super-fast DISTINCT using a recursive CTE:

USE tempdb;

GO

DROP TABLE dbo.Test;

GO

CREATE TABLE

dbo.Test

...

I'll post one in a minute.

...in the meantime, here's another simple and obvious use of rCTE's. No timings because I've...

To verify that the bottleneck is network/client speed, try running:

SELECT COUNT(*) FROM table WITH (INDEX(1));

That will force SQL Server to read every row in the table, but only return one...

The majority of the time taken to run the query is probably taken up in moving that much data across the network for display on the client. From the...

Wow!

gmrose (10/28/2010)

---

Thanks again for everyone's suggestions. I ended up rewriting the script to use Wayne's "quirky update solution". That script processed over 300,000 records in 18 seconds. ...

Eric Russell 13013 (10/28/2010)

---

I still think that combining a logical identifier like client_id or store_id with another column containing either a date/time stamp or sequential integer makes more sense than...

Thank you! So, spackle (USA) = PolyFilla (rest of world)

edit: thanks also to Tom

Jeff Moden (10/27/2010)

---

We need a catchy category name for these types of articles. You mentioned you wanted to "fill holes". How'z about "SQL Spackle" for a name? ...

Jeff Moden (10/27/2010)

---

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

---

Some of the smaller manufacturers aren't careful. In the 90s we had two separate NICs have duplicate MACs when we bought an off...

Jeff Moden (10/27/2010)

---

BWAA-HAAA!!! Oh no... Not quite what I meant. I know that 48 bit MAC addresses are larger than they'll ever use and when they run out...

Jeff Moden (10/26/2010)

---

]If they thought it was that much of a security risk as to make such a change as the GUID no longer being globablly unique, I'll probably go...

Yup.

So, does anyone know of an article that...