Grant Fritchey (5/16/2008)

---

Just so long as you quantify your post to read "some knowledge" because I'm basically a newbie on SCOM myself. I've been working with it for, probably close...

Grant, thanks so much for all this info, this is great!

I will definitely look at the links you have posted and make use of them. It's also great to know...

Thank you all for the great turnout and discussion, please keep it coming! 🙂

Here is the modified query I use to determine which indexes in my database to run UPDATE STATS on:

SELECTid

,indid

,OBJECT_NAME(id)

,[name]

,rowcnt

,rowmodctr

,STATS_DATE(id, indid) AS Date_LastUpdated

FROM sys.sysindexes WITH ( NOLOCK )

WHERE indid > 0...

Another question I have on this issue:

Is there a performance hit when SQLCLR objects are invoked from code residing on another database on the same instance? In other words, is...

tom (5/15/2008)

---

I'm interested if the script you run in step 2 is generated dynamically via another script?

I don't want to have to mod the script every time I...

Just got notice on this interesting link:

Tips for moving from SQL Server local disk storage to SANs:

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1313715,00.html?track=NL-421&ad=639679&asrc=EM_NLT_3656686&uid=6474375#

TheSQLGuru (5/15/2008)

---

Spot-on Mario!

Oh, and for this one "It's as if people naively think the tool itself will solve all their problems with no tuning necessary. I've witnessed this all too...

TheSQLGuru (5/14/2008)

---

colin Leversuch-Roberts (5/14/2008)

---

Actually i was just thinking that each time a thread gets going on storage and SANs it really generates a lot of interest making me more than...

The SSIS package I created loops through a table containing the server instances and local paths to which I wish to deploy the SQL CLR objects and dll file and:

(1)...

The only extra thing I can think of right now is tempdb usage. In SQL 2005 tempdb usage is greatly increased. Make sure tempdb in the new SQL 2005 instance...

At the very least, you must update the stats.

anthony.green (5/14/2008)

---

The /PAE and /3GB stay in the boot.ini file yes.

The server still shows 16 in the lowest value for max server memory but the maximum shoots back up to...

After changing the compatibility level to 90, do the following:

(1) At the very least run sp_updatestats on all user databases, OR preferably run:

UPDATE STATISTICS WITH FULLSCAN on all user databases.

(2)...

These...