1) forums are for targeted, usually straight-forward questions or problems. Your post is neither. You cannot possibly expect to get all the information you request via a forum...

sjimmo (3/15/2011)

---

The /3GB switch is not set. The locking is occuring during the weekly load which is performed using an openrowset from various other servers. Once we are through the...

My gut tells me that something unusual is going on for a DW to be consuming so many locks. Normally (in my experience) DW queries take few high-level locks....

You can find scripts online to do what you want although they are not guaranteed to catch every single object/column/etc. But AFAIK this action is UNSUPPORTED BY MICROSOFT. ...

once you find out what is NOT being done, go to ola.hallengren.com and start to use the awesome FREE database maintenance scripts there to handle all your MX needs, including...

Bristolred (3/11/2011)

---

Hi

I need some help on the best setup with the following:

We have a Microsoft Windows Server 2003 Enterprise Edition Service Pack 2 (18GB Ram) running 1 instance of Microsoft...

sjimmo (3/11/2011)

---

I understand that when the number of locks obtained is equal to 40% of the total SQL Server memory that it will start throwing 1204 errors.

What I am...

1) reread all the requirements for using DTA to do what you want it to do. you may have missed something

2) a full day's profiler run on a busy...

sqldba_icon (3/10/2011)

---

TheSQLGuru (3/10/2011)

---

First-execution times being slow is almost certainly due to simply reading data from disk. After that you are hitting data directly in RAM, which is way faster....

I know of a company that ceased to exist because they lost information due to mis-coded triggers like you have. It is a scarily common problem with trigger code!!...

1) if restored-to server is upgraded version, MUST update ALL stats with FULLSCAN

2) Is restored-to server exactly as capable as original server, and without additional load on it?

3) have you...

1) check network bandwidth with proper tool or even a simple file transfer as someone else mentioned

2) run a query that outputs same data directly to a local file to...

First-execution times being slow is almost certainly due to simply reading data from disk. After that you are hitting data directly in RAM, which is way faster.

Issues...

I use 'generated' TSQL like that all the time but never thought to make the leap and intermix straight/generated TSQL in a CTE like that. Oh the possibilities!! ...

I should mention that if you are going to upgrade your SQL 2005 installation you should probably go straight to the latest service pack and cumulative update. Don't want...