Let it go dude 🙂

Speak for yourself! I pride myself on having a rather average mind :laugh:

It will be interesting to see how this pans out. I would be surprised if your results...

Well yeah it's all cool an' all, but as you say - expensive. SSDs aren't a panacea of course - we just found they solved a particular problem quickly,...

Charles Kincaid (4/20/2009)

---

First, if I offended anyone I apologize. I am a sarcastic twit and I do need to be called on it. Yes, everyone has a right to...

TheSQLGuru (4/20/2009)

---

Any situation where a set-based solution CANNOT be used. One example is where you need to call multiple sets of sprocs with inputs from a single row and...

Matthew,

You removed the -g1024 correctly.

Drop the assembly if it exists, add re-create it from a local disk. Good stuff.

Lock pages in memory will do nothing, as you know. ...

Thanks Gail.

I cannot believe I actually went off to see if there was any way I could get a variable assignment to generate reads in profiler :blush:

The guidance on rows...

Matthew,

Thanks for that.

Did you remove the -g start up option? That is most likely casing the 'memory pressure' message. Once that goes away, moving the DLL to the...

sward (4/20/2009)

---

Can you not just distinct on one column only then display the rest of the columns based on the results for the distinct column person_code?

Seems crazy i can't get...

Hey everyone,

Just to add to the whole solid-state reliability thing: we serve two thirds of all the web pages viewed in New Zealand daily and use four Ram-San 400s for...

The question is answered, but for anyone interested:

There is another type of split, new to SQL2K5. Individual columns on an existing page can be 'split' onto a ROW_OVERFLOW allocation...

Hey Tim,

MSDN

---

A logical read occurs every time the database engine requests a page from the buffer cache. If the page is not currently in the buffer cache, a physical read...

$0.02:

SYNONYMs are very cool, but beware of incompatibilities with any (usually legacy) code which might barf when it sees a synonym instead of a 'real' object.

We had an instance where...

Thanks for the details Matthew (though you forgot to include whether it is SQL Server Enterprise, Developer, Standard or Workgroup!)

Before I get too deeply into your post, I've just noticed...