That wouldn't work if there were FK from the license_message_value table id --> license_message table.

MichaelMontgomery (6/8/2012)

---

I have run the script and no triggers exist on the database or server...Hopefully this makes it a little clearer.

When you run the follow script in SSMS, which of the outputs do you expect to be returned?

SQL* (6/6/2012)

---

How about if we create COLUMNSTORE index on SupplierName (How the index page will be?)

sundeep38 (6/6/2012)

---

UPDATE test1

SET

count = '3'

WHERE

fileid = ISNULL(null, fileid) AND

count= '' AND

CONVERT(datetime, CreationDate, 112) > GETDATE()

Greg J (6/6/2012)

---

Another table references this first "queue" table via FK (no cascade), and those records have similar INS/DEL activity.

Jeff Moden (6/4/2012)

---

I had considered it only so briefly because it's about 8 times slower than the traditional NEWID() method...

Jeff Moden (6/4/2012)

---

Didn't know if you changed the 2 million row test to a million or not.

Jeff Moden (6/4/2012)

---

I had considered it only so briefly because it's about 8 times slower than the traditional NEWID() method...

SQL Kiwi (6/4/2012)

---

the methods presented so far to generate a million rows run for around 15-20 seconds on my laptop