Are you sure you were encountering deadlocks? and not just significant blocking?

Deleting large swaths of job history can wreak havoc on your server if you have a lot of jobs...

A Trace (accessible via Profiler or server-side trace) can be thought of as a logging mechanism for SQL Server. Using SQL Trace

Since you're on SQL Server 2008 you could also...

In an adjacency list a child typically has one parent. I think in the OPs model a child can have multiple parents, in which case the permutations when traversing the...

You're welcome! Thanks for posting back, confirming that it worked!

32-bit or 64-bit?

How does selecting data from an Excel Workbook fit into your overall process, i.e. what are you trying to accomplish?

Microsoft® SQL Server® 2008 R2 Best Practices Analyzer is a good place to start.

Monitoring Best Practices by Using Policy-Based Management has a bunch of useful checks as well. PBM is...

SQL Kiwi (5/1/2012)

---

I would also strongly discourage the use of the OLE Automation procedures (especially with a cursor as in the demo code). Service Broker may also not be...

Dev (5/1/2012)

---

I agree with opc.three and would recommend to create a table for logins that you are going to restrict (or any other custom operation in future) for user. Small...

pamozer (4/30/2012)

---

In my ssis package how do I change the database that the procedure is running on in the for each container. I have an Execute SQL Task that...

How to: Uninstall an Existing Instance of SQL Server (Setup)

You could keep a list of logins hardcoded in the trigger as the example shows, or as I said you would need to keep them in a separate table. Having...

capn.hector is correct too (we were typing at the same time so didn't see his post)...I do not expect issue with an in-place upgrade, but a fresh slate is always...

Sapen (4/30/2012)

---

Thanks for your reply. Right now SQL Server max memory setting is set to 25600MB and I want to change it to 29000 as I have ensured that there...

NaCl (4/30/2012)

---

from Microsoft's 2008 R2 Security Best Practices Whitepaper:

•Have distinct owners for databases; not all databases should be owned by sa

i understand the advantage of ownership by an account that...

capn.hector (4/30/2012)

---

The OP was talking about Windows Server not SQL Server being the limiting factor the...