You really should not be adding people as server admins who only need to be able to query the cubes!! That means the person can log into the AS and...

If you use this option, be sure to explicitly drop the table when done with it. However, this option has the problem that the option can only be used one...

The reason your first method did not work is that the optimizer does not parse conditional when it generates a query plan. So it tries to generate a plan for...

in SQL Server 2005+, they no longer drop all temp tables from the tempDB. A small cache of 16 temp tables are saved in a special area of cache. This...

There's lots of ways.

1. Parameter sniffing: SQL Server generates a plan based on parameters passed to a procedure. That plan may work great most of the time but for...

I agree with peleg about it not being an appropriate job for SQL Server. Beyond that, it is an interesting use of the OLE Automation procedures.

One recommendation, I would suggest...

Well, knowing what I know about the person who wrote DBCC, I believe his advice at this point would involve updating your resume ... just in case.

Try the tool that...

From my own observations, this appears because there are multiple plans in the cache for the procedure. If you query for the entries that have duplicate object_id's, you will see...

You get the MCTS if you pass any exam. It doesn't have to exam 431. However, I agree that 431 is probably the best choice to start with. No matter...

How many logical processors? Is SQL Server Enterprise Edition or Standard Edition?

You do understand that the recommendation to limit the number of mirrored databases is due to thread consumption, right?...

That's a bad, bad idea.

400 databases? On how many servers?

That's why I like term "Business Continuity" rather than HA or DR. You're absolutely right, the two are...

That's really dependent on your external drive source. If you just throw on and external drive bank via iSCSi with no redundancy or anything, then you're right.

That's why most people...

Jeff Moden (3/31/2010)

---

Heh... bean counter semantics... does training make money for Microsoft in one form or another or not? I don't have a problem with it if MS does...