Isabelle (8/14/2008)

---

Hi,

In monitoring some performance issues that we are having, I see that the SQL:User Connections counter shows on the average about 800. I read online that if this...

While XML may be a solution to this particular design issue, I would take a good look at SQL 2008 and it's Sparse Columns feature. I really bet that...

Steve Jones - Editor (9/15/2008)

---

I tend to agree with the two posts above. I separate things out for two reasons:

- security, you can secure things, but the more co-located things...

In addition to the recommendation by others that you need to set lock pages in memory permission for the domain account now used, 30720 MB is too high for a...

Junior, you really, really need to get a consultant in for a day or two to explain to you what types of HA are available in SQL Server and to...

I'm with GSquared on this one. If you are asking multiple open-ended questions like that it is almost certain that you do not have the skills, training or experience...

jcrawf02 (9/9/2008)

---

Ok, so I've seen some half-answers to this question, but my pea-brain needs a clear response to this:

I'm working in an environment where the reporting server is only updated...

It's usually the other way round, though only if a bookmark lookup is required. The optimiser will only pick a plan with a bookmark lookup if it feels that the...

The first one is the reason so many database developers like Nolock. They notice that the query runs faster pretty much every time, get excited about that, and then...

1) Turn off autoshrink. No back talk - just do it. :hehe: There are a ton of bad things that happen when this fires (which is does...

Yes: call PSS and pay them the $275 or whatever it is. Had you done this...

I suggest you contact PSS. There are quite a number of bugs that can cause this (the Broadcom adapter one mentioned in the linked article, HP iLO driver, Windows...

WOW! Doesn't get much better than that! You even get to take advantage of the long drive for some "me time"! Congrats.

Roy Ernest (9/3/2008)

---

I am not a big fan of SAN. We had our prodiction set up with Clustering (Ofcourse SAN as well) . Everything was redundant and there is one...

The hardware has 8 CPU (Hyper-Threading). CPUs 0 to 5 are Processors Affinity while 6 to 15 are I/O Affinity (because I was seeing entry like this on e...