Looks like Jeff isn't getting his answer.

Yes it is neat. If you are interested in a...

Jeff Moden (3/14/2010)

---

You can access a VIEW from a UDF. One like the following allows for the use of NEWID() in a function... Same goes for GETDATE() and...

Without knowing the details, my gut-feel about multiple-tempdbs is all bad.

Many shops struggle to get tempdb genuinely on its own drive/controller/bus (think SANs).

I find it hard to see how making...

I tend to disagree.

GoGreen (3/14/2010)

---

I am using multiple INSERT Statement to build large SQL statement...

For eg

I read from file differnet column values and...

Smurf. (The blue kind, with the white hats)

The posted procedure is interesting in itself, but does not match the execution plans. We need the code for GetDMSDocumentInformationForSearch, not the procedure that calls it.

By the way, you...

Difficult to say anything definitive from that estimated execution plan. Actual plans are much more useful since they contain run-time information, such as the distribution of rows between threads,...

Absolutely yes. More details:

http://blogs.msdn.com/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx

I am going to take a...

Same here.

I had a 2005 database once, many years ago, that absolutely refused to shrink, even when in single-user mode, with all the user objects in the database dropped completely. ...

rd_in_sd (3/14/2010)

---

Using GUID's is fine, but when the primary key is a clustered index, then you end up with half-or-less empty data pages which creates a lot of I/O and...

True. I worked with an application once that shared a schema across all customers...and any customer could ask...

Jeff Moden (3/14/2010)

---

...only...if it's Tuesday, it's raining on the next block but not this block, and a certain colored walking catfish is crossing an East bound lane wth double yellow...

I do not count math among my stronger skills 🙂

The idea was that...