Oh, the 'query wait (s)' property is an Advanced Option. So you can turn on advanced options by running:

sp_configure 'show advanced options', 1

RECONFIGURE

... then you can see all...

Then the server settings you are configuring are the right ones. Setting the timeout in SQL Server to -1 will prevent timeouts.

Run: sp_configure ...and look at the time out...

Right. A recycle of SQL Services will rebuild TempDB and it's log. But like Shawn said, you need to ensure the underlying file or file path for the...

I was just confused because the paragraph in the help that is just above his copy/pasted code (except that he replaced the SELECT in the Catch with RETURN) explains this...

My bet is that the timeout is from a .NET or client application. The default .NET connection timeout is 30 seconds. You can test this by running the...

You posted this to a SQL 2005 forum, but the code uses 2008R2. You may find better success if you post to the proper forum; it also keeps things...

Of course, this is way too much to actually teach here in a forum; so I'll just give a few pointers so you have a starting place to wrap your...

Only one of my current clients adheres to SOX and HIPAA. Yes, it has impacted work. I agree with you, that it is really for the better in that...

As a consultant, I do use the term "the business", "the client" and "the customer" nearly interchangeably.

When talking about them internally to my DBA staff, I usually say "the...

Maybe this is too obvious, but you did ensure that the SQL server is configured to allow remote connections, right? This is in sql server properties on 2008.

Also, you'd...

Yep. In other cases, it is good to throw read-only tables (which don't get updated very frequently if at all) in a read-only file group.

In still other cases, testing...

Query tuning is largely the same as in more recent versions as regards query execution plans, etc.

If you are unfamiliar with the SQL 2000 tuning wizard, I wrote a walk...

There are lots of strategies to use and testing will yield the best results in your environment.

One method to use may be to create 2 FG's and relocate some Clustered...

If it's in a table, you can more easily select from the logs and log details to perform additional administration. Notifications or whatever. This solution can give you more flexibility...

I second what Craig says. There are numerous reasons why the business may desire/require a total separation.

This is not a performance issue. In the past when faced with...