The message saying the connection was forcefully closed usually means that either the connection was explicitly killed by someone, or the query hit a high severity error and was disconnected.

Both...

SQL will cache frequently used data. If the database is often used, the data will be in memory.

Pintable is still usable on SQL 2005, but it does nothing.

Before you go truncating your transaction log on a regular basis, please note that truncating the log is not a good maintenance practice.

Please read through this - Managing Transaction Logs[/url]

Pity it won't be me.

It took me all of 20 sec or so to find that on google,...

Bob Hovious (1/14/2009)

---

I agree with Barry 100% here. I often wonder what the bad actors would do if the first person to reply sent them the link to...

I believe it is required in the latest SQL standard. (correct me if I'm wrong, I haven't actually read the standards docs)

One of the reasons that it will be required...

Don't let the disk run out of space. In addition, make...

Just don't call that directly from within a trigger. I detailed all the reasons earlier in this thread.

Not so interested in the reads/sec. What does the avg sec/read and avg sec/write look like?

foxjazz (1/14/2009)

---

My direct question I think is why does the clr (sql ) prevent us from using the windows.net tools like sockets or udp sendudpmessage? And since it does,...

Ok, I'm confused. You didn't mention anything about service broker before.

Wouldn't it be possible to...

Why not? Have the service broker queue's activation procedure be a CLR procedure. It...

Why the cursor?

DELETE FROM Logins

WHERE UserID IN (SELECT USER_ID

FROM...

In the future, if you post pieces from the error log, please find and open the error log in a text editor. The log reader within management studio puts the...

Ok, let's see....

4 processes involved in the deadlock,

Process 1 - Spid 174, running the select on line 136 of the procedure with ID 2099048 in database 20. It wants a...