WMI - Windows Management Instrumentation

http://www.microsoft.com/whdc/system/pnppwr/wmi/default.mspx

WMI Administrative Tools

http://www.microsoft.com/downloads/details.aspx?FamilyId=6430F853-1120-48DB-8CC5-F2ABDC3ED314&displaylang=en

Its a 'must have' thing if you use SMS and MOM at your site. From a SQL Admin perspective...

I do not know for sure but I would check out the IE settings on the PC tthat worked and the one that did not. In particular, security, active-x and...

You are correct John. I copied the build steps from one of my clusters that has 8 Gb of RAM. However the SP4 issue is something to look at on...

I do not know of any articles on this specifically. But I do have a question:

"Would you leave a wallet stuffed with money on the dashboard of your car...

First things first. If this cluster is dedicated to SQL Server then you can configure your SQL Server cluster nodes to use more memory. 3 Gb fro SQL Server and...

For hit ratios and wairts the Windows perfmon tool already exists. Poor running queries need SQL profiler. MOM will also handle these things. In either event you should check out:

Who says you can't teach an old dog new tricks ... Thanks Jeff !

 I do not care about underscores one way or the other. There is one point missed when using capitalization. It concerns collations. If you are binary or case sensitive it...

Beware though ... sp_change_objectowner does not work for SPs !

Here's my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE STATISTICS (with FULL scan) for all tables

    exec sp_recompile for all tables

    exec sp_refreshview for all views

Round II

    DBCC DBREINDEX

   ...

It depends ... but generally I'd say yes. It depends on the the following:

• The OS
• # of CPUs
• CPU speed
• Are the CPUs Xeon or not
• the amount of RAM
• Disks
• number of them
• their size
• the speed of...

system tables - none

stored procedures - again, I believe none

system functions - there may be one or two. check out BOL

Her's a handy link no programmer should be without:

http://www.connectionstrings.com/

MOM 2K5 - Microsoft Operations Management

Here's a handy link no DBA shopuld be without:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx