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 stamping the network...

Looking at the Actual Execution Plan of the query may not tell you the internals of what the UDF is doing, but it should give you an idea of how...

chrisn-585491 (10/27/2010)

---

The sad part is that the folks at the top of the heap make...

I'm in the process of making myself a SQL Server / Oracle / Data Analyst / Business Analyst hybrid. I've had experience with all of the above over the years,...

lavien (10/26/2010)

---

I don't know why it has to rollback. The server have more than 30 process that the select statement using the full text catalog for some days(I had been...

Thomas-282729 (10/26/2010)

---

Eric Russell 13013 (10/26/2010)

---

I'm not intentionally trying to throw gasoline on the fire, but I'd just like to point out that, since a GUID is basically a combination of...

I'm not intentionally trying to throw gasoline on the fire, but I'd just like to point out that, since a GUID is basically a combination of various attributes like machine...

GSquared (10/26/2010)

---

Eric Russell 13013 (10/26/2010)

---

This why I keep saying that some type of identifier unique to each instance of the application or user, like client_id or cashregister_id, when combined with...

This why I keep saying that some type of identifier unique to each instance of the application or user, like client_id or cashregister_id, when combined with a sequential integer or...

Paul White NZ (10/25/2010)

---

NEWSEQUENTIALID calls the Windows API function UuidCreateSequential, which uses version 1 of...

GSquared (10/25/2010)

---

"If" statements have to make sure every possible outcome can compile and run without errors. That's why they give errors as if an option had run that really...

jeff.mason (10/25/2010)

---

Thomas-282729 (10/24/2010)

---

Robert Frasca (10/12/2010)

---

Other than for merge and updatable transactional replication, I've yet to hear an argument as to why an identifier has to be globallyunique. Sure, it...

Thomas-282729 (10/24/2010)

---

1) DISK SPACE isn't what is important, it is THROUGHPUT, and that is dramatically affected by the quadruple-int-sized GUIDs. MEMORY is a precious commodity (on most systems) for the...

Here in the US, SOX regulations require certain types of companies retain printed hard copies of critical financial and operations related reports, and this the source for a lot of...

Jeff Moden (10/21/2010)

---

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

---

Eric Russell 13013 (9/20/2010)

---

Whenever someone requests the creation of a new report, and the specifications don't seem clear or feasible (for example 50...