Jeff: Don't ever let the defaults for auto-growth on a database occur... it takes 73 disk fragments just to reach 1GB using the default settings.

I believe you are way...

Two very important points:

1) having multiple files for the log is just plain bad practice. Do not do that.

2) You said multiple files on the same drive in the...

bcronce (10/1/2008)

---

I get this issue quite often with the data I work with and I've found doing an update statistics helps in most cases. SQL randomly estimates the 1 row...

1) cost

2) complexity

3) may be sql server only app (although doubtful)

4) ease of development

5) did I mention cost?? 😀

If the database (or at least the tables of concern) can be unavailable for a while I would recommend a drop/create cycle since it seems you have never done index...

What version are you on? I would recommend testing and moving to SP2 + Cummulative Update 6 (or perhaps CU8). There were a BUNCH of regressions in the...

Let me add my recommendation to the other two about getting professional help. You have absolutely no chance of success in this endeavour. There are only a handful...

I highly recommend the free Performance Dashboard.

1) is affinity masking being used?

2) is the batch job query(s) limited in parallelism, either explicitly or by maxdop setting or cost threshold for parallelism?

3) do a simple test while...

blogs.msdn.com/sqlprogrammability/archive/2007/06/29/detecting-overlapping-indexes-in-sql-server-2005.aspx

blogs.ameriteach.com/chris-randall/2007/8/15/sql-server-2005-detecting-overlapping-indexes.html

http://blogs.msdn. com/mssqlisv/archive/2007/06/29/detecting-overlapping-indexes-in-sql-server-2005.aspx

http://blogs.msdn.com/mssqlisv/archive/2007/06/29/ detecting-overlapping-indexes-in-sql-server-2005.aspx

Amazing what a very simple web search can do for you.

I can think of another "pain point" to SYNONYMS - someone (as in me, a consultant) having to step in and debug/tune the queries that use synonyms. I absolutely...

Colin brings up a good point. Have you verified that your memory configuration is correct given that you have 32 bit sql server EE with a large-ram box? ...

Isabelle (9/18/2008)

---

colin Leversuch-Roberts (9/17/2008)

---

I'm going to ask what I normally ask - do you have problems with waits and schedulers and are you monitoring them so that you see this...

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...