CirquedeSQLeil (4/12/2010)

---

Are all instances running the same version of SQL server (same patch level)?

I have seen where the patch level has an impact on query performance - very similar description...

Piotr.Rodak (4/12/2010)

---

Are you sure that you have exactly same schema on this database and others? It maybe that lack of an index on other table triggers scan on the big...

No, the problem continues to exist only on the one server. It works fine everywhere else I've tried it including on our dedicated volume testing environment where the data...

Great article but I had one question. The reference about when temp tables can cause recompilations takes you to an article relevant to SQL Server 2000 and when stored...

paulgrahamster (3/23/2010)

---

Robert Frasca (3/23/2010)

---

From a design point of view I think I might take a simpler approach to solving the training issue. We know that because "the training item...

First of all, while I have no issues with the Employee_FunctionalArea construct used in this article I wish we could all reach an agreement on what to call a table...

I feel your pain. I should probably have prefaced my remarks with "when it's possible". It's much easier to take the approach I recommended at the beginning of...

I'm not a big fan of de-normalization in OLTP databases. If I need to run queries I'll run them against a structure that's is optimized for queries such as...

We install our products on servers of clients who have little or no technical expertise in-house. It's in our best interest to make sure that some fundamental safeguards are...

There's no guarantee that those names will stay the same. Also, from my perspective, the Reporting databases are system databases as well. Since the names of the four...

The fact that the names can vary based on whether it is a named instance is one of the reasons why I don't want to hard code. Of course,...

I'm trying to generate some canned Maintenance Plans and I want to logically filter out the System db's or, as the case may be, filter out the user databases. ...

Okay, that solves the problem of seeing the string.

The whole point of this exercise is to set MAXDOP just for this query but the number of cpu's can...

Ah...there used to be a line that said

SET @CPU_String = CAST(@CPU_Count as varchar(2))

in there. I must have accidentally deleted it. Good catch. Thanks a million.

Nadrek (2/12/2010)

---

Alan Vogan (2/12/2010)

---

Wow. Reading everyone's post, it sounds like many have a problem with 'IT' or 'System Admins' whining about DB's taking up to much disk space. Disk space...