There are several cases (BUGS) which could make that problem happen and some of them are documented in the MS KB.

EX:

http://support.microsoft.com/kb/954054/en-us

http://support.microsoft.com/kb/951120/en-us

There is also the possibility that someone/something changed the...

All these numbers are really tied to the hardware capacity unless they are expressed in "%" .

You should check for "hard" numbers AFTER you have established a base line.

sql guy (9/15/2008)

---

they are on the same server and this is what i tried. i am getting a result but its gibberish!! i am just starting off sql so may...

PeterG (9/15/2008)

---

Hi Guys..

Does anyone see a problem with the following update query? The last time i ran it, i killed the query after 3 hours. It is currently running and...

Adrian Robertson (8/6/2008)

---

Thanks. There is no row filtering or column filtering, and although there are some conflicts none of these match the records that are missing.

I have done some digging...

Toby White (9/11/2008)

---

My environment uses databases on server X that have publications, the distributor database is on Server Y and the databases with subscriptions are on server Z. I need...

rbarryyoung (9/9/2008)

---

Hmm, I note that "seeing rows applied at the subcriber" is not necessarily...

marty.seed (9/12/2008)

---

Is there a way to pull the top 5 for each id?

ID Amount

1 ...

keymoo (9/9/2008)

---

Thanks but from BOL it says the following:

-MaxCmdsInTran number_of_commands

Specifies...

Just for an example I had to find some "bad" dates (.... "24:00:00") that crippled a some random rows in a large table (500+ million rows) and locking the table...

You can use EXECUTE AS to specify an account that has the required permissions and then grant execute permissions to your user.

Note: Trustworthy ON is necessary!!

Any "bcp" or "bulk insert" activity ? these do *not* fire triggers unless explicitly told to 😉

Totally agree with David. You will probably be better off upgrading to 64 bit.

Some suggestions:

* Install Performance Dashboard and try to see which are the queries that affect you...

NOLOCK does have its uses! The main problem is that many tend to abuse it or use it where is not really appropriate.

Renaming a server does *NOT* necessarily requires reinstall.

How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005