It sometimes saturates in minutes, sometimes several days. Once is saturates i requires a restart of SQL agent.

Re your other questions, I think you misunderstand. It is SQL...

We've installed SP3 on several servers with no real issues, but hit a serious snag on one.

There is a bug somewhere in dealing with the statement cache that causes an...

I've been trying to figure out why some shrinkfile commands seem to take inordinately long, and I think it's related to indexes, but perhaps someone can enlighten me.

I'm guessing (entirely...

I've had the unusual luck to need to call them twice in one week so I'll offer two datapoints plus some past perspective.

We had a raid-5 set fail, two drives...

Yes, lots of them (as you can see in the last sentence). Also note that this detach and replace is being done in a SQL Agent job so we...

Sorry for the delay, the first time I looked at it I thought that was all wrong, but I came back to it and it does seem to work, but...

quote:

---

Lock timeout is irrelevant in a deadlock because by definition it is a deadlock even if both processes waited 100 years they...

We may be a better example due to ignorance.

We started SQL Server because it was handy and cheap and we had a few hundred meg of data.

We grew that "data...

We are building strictly for Intranet, not Internet, and use Windows Authentication exclusively. We don't allow anonymous access, this gives us some record of who is accessing what. By...

quote:

---

You need to use the trigger_nestlevel() function to either test if your trigger is already running, or if the replication trigger is...

Sorry, I must be phrasing my question badly. Let me try again.

Server A is the publisher. Server B is the subscriber. Table X has an update trigger...

I ran across an undocumented answer to my question, here's an example:

declare @Tabid int

declare @STR nvarchar(255)

set @Tabid = Object_id('Customer')

exec sp_gettypestring @tabId, 6, @STR output

select

OK, I answered one of my own questions, and it's kind of obvious. The two SHRINKFILE's are blocking because it appears the SHRINKFILE needs to update something for a...

quote:

---

Perhaps you are speaking of channels?

---

Channels are indeed something worthy of note, in relation to...

I think the debate over 0+1 vs. 5 misses an even larger point.

While your mileage may vary, I think you will find that having LOTS of cache in the raid...