Do you really need to reload the data completely for the tables, or could you work out a differential loading that only brings changes in, which minimizes the logging as...

What is your code that you are creating the SqlDependency with, and what kind of object are you "watching"?

It depends on your workload. That CU might fix your problem, but then again it might not either. What type of server is it; x86, x64? How...

Also post back the layout of tempdb files? # data files, # log files.

Having two separate LUNS from the SAN isn't necessarily having 2 separate sets of spindles. ...

I support databases in all sizes from a few MB to just under 1/2 TB in size.

What is the output of SELECT @@VERSION?

I am assuming that you are on a 64bit SQL Server based on the amount of memory being used by the process. In...

What kind of service are you trying to call? There are generally 2 types, standard .NET webservices that have a ASMX that you can reference as a service, or...

These call into COM which is UNSAFE in SQLCLR. Usually you can get away from COM completely and into a managed provider for what you want to do which...

I would venture a guess that the code came from, or is extremely similar to the following blog:

http://blogs.msdn.com/mrorke/archive/2005/06/28/433471.aspx

The problem with this is that it doesn't scale well inside of SQL...

tosscrosby (5/19/2009)

---

It reminds me of a time about 10 years ago. We were implementing PeopleSoft payroll/HR. The VP of HR did not want us (the technical team) to be able...

The best recommendation that I can give you is this:

If you are unsure, ask a question on the forums before you try something out on one of your servers or...

Actually, if your servers are configured correctly, and there is a division of responsibility, you don't need access to the OS at all as a DBA. There are a...

Bill Baer blogged about things to look out for when doing log shipping with Sharepoint last year:

http://blogs.technet.com/wbaer/archive/2008/03/13/sql-server-2000-2005-log-shipping-notes-with-sharepoint-products-and-technologies.aspx

I am with Jack on this, it is better to allow by rule rather than allow for all when dealing with your firewall and anti-virus, worm prevention software.

I meant to include that 64bit Servers don't have the same VAS limitations as 32bit servers because they have 8TB of VAS, so for those servers, setting a max server...