As for newsequentialid() not being able to be referenced directly, here's a kluge I've been using (not my idea, but liked it's simplicity):

-- default to one value returned

create proc get_newsequentialid

...

I know it sounds silly, but if your database is for a 3rd party application, check support for it. We have a database we're migrating from 2000 to 2005...

Such as an introduction? Try this link.

Mohan Kumar (9/9/2009)

---

I executed the script twice. There are some indexes still with 40-55% fragmentation and page_count ranging from 9-151.

Eg.

tbl1 Frag 38.88 PageCount18

tbl2 Frag 11.11PageCount9

tbl3 Frag 7.01 PageCount57

tbl4...

Kit G (9/10/2009)

---

No, I haven't seen Spamalot. I probably should, I hear good things about it, just too lazy to go to an actual theater and I don't think...

Kit G (9/10/2009)

---

This particular coconut/swallow reference is from Monty Python and...

True, in the best of all possible worlds, all reporting would be...

Thanks. So hopefully the windows admins have set it up the server properly. 🙂

Sourav (8/24/2009)

---

Hello SQL Experts

How to check when the indexes of a particular table \ all the tables of the DB was rebuilt??

Can you suggest me a good site to "create...

Kit G (8/11/2009)

---

GabyYYZ (8/11/2009)

---

Anyone here planning to watch District 9 (this week I think)? It looks like a totally interesting sci-fi.

Any of our South African members hearing some buzz...

Anyone here planning to watch District 9 (this week I think)? It looks like a totally interesting sci-fi.

Any of our South African members hearing some buzz about it or...

Here's a thought.

Given that a binary representation of a value is as unambiguous a way to represent a value as you can get, explain how this occurs:

select convert(varbinary, convert(nvarchar(3),'674')); ...

Love cppwiz's answer. LOL, wonder if the person ever did send the email.

Really? Is it so hard to Google "Database Design" for this person?

GilaMonster (7/27/2009)

---

Not necessarily true either. Think about fragmented indexes, fragmented file system, striping,...