Jeff Moden (10/26/2010)

---

Haven't had the pleasure of working with sequential GUID's in 2k8, yet. You're correct... it's plain to see that they're not type 4's but are you sure...

Not for NEWSEQUENTIALID - that uses version 1. I mentioned...

:laugh: Yes, this is always a hotly-debated topic. I'm not really...

GSquared (10/26/2010)

---

This works, but does have the disadvantage of things like accidentally re-assigning an existing register ID. Of course, either can suffer from someone doing something like copying a...

Eric Russell 13013 (10/26/2010)

---

Two instances of SQL Server on the same machine would share the same network card, and if they are running the same database application, then it seems...

I was thinking more of backup compression than compression inside the database. For that, we have tools like LiteSpeed, HyperBac,...

We should probably also consider that large databases would...

On the subject of storage size:

SQL Server stores data on pages with a fixed size of 8192 bytes. After 96 bytes are reserved for the page header, 8096 bytes...

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

Eric Russell 13013 (10/18/2010)

---

In Oracle there is an object called a SEQUENCE, which is used in situations where we would typically use an identity in SQL Server. The difference is...

Jeff Moden (10/24/2010)

---

That's what I thought. My recommendation would be to avoid global temp tables because (as you know) they're visible and usable by anyone. The big problem...

ChrisM@home (10/24/2010)

---

Thing is, it's so darned easy to get the correct results out of a rCTE. It's only when you want it to run quickly that you have to resort...

Hi Jeff,

The most accurate answer is...

Forgot the attach the C# source code (the meat of the thing is in the parallelWorker class, at the bottom):

using System;

using System.Collections;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.Data.SqlTypes;

using AdamMachanic.QueryTools;

using Microsoft.SqlServer.Server;

public partial class UserDefinedFunctions

{

...

This problem isn't ideal for a SQLCLR solution because it produces the same number of rows it consumes, and there is very little calculation...