I don't think that will work. My guess is your best bet is to check which object is affected and then see if it matters. If it's a nonclustered index,...

I'm with bitbucket. Read about it, run the Upgrade Advisor, and then restore to a test environment and test to be sure all your code will still work.

We've tried to figure out how to do this well here for years, but never came up with a good way. Plus we were bound by advertising contracts, which could...

Do you mean why is it slow those times?

I can't quite be sure. I'm not the infrastructure guy, nor the developer, nor DBA. I gave up control to focus on...

Be sure you are tracking space, and making log backups. That is the first thing.

You can set an alert condition to mail you (http://msdn.microsoft.com/en-us/library/ms187827.aspx)

or build an app[/url]

You don't really need to back this up. It's a standard database built for a particular patch level of the server. So every server that is RTM has the same...

sqlsentry.

http://www.sqlsentry.net

We start sending the newsletter at 9pm MST most days. That's usually what the slowdown is. At times I run an hour late, but it seems the first hour or...

On the list. I view that every day, so it's annoying to me too!

Enter it for the registration code. There's a place for discount or other codes, put it there. It will take off $100 and you'll get on our list.

It seems that most people are like me. The CPU enhancements don't mean a lot to them.

Except for the gamers out there, they want to squeeze out every cycle they...

Is this post 8000?

You'll have to add your own "T"

We used to have those constraints implemented! V1 and V2 of this site (2001 and 2004 respectively) were built by DBAs. So the ASP and ASP.NET code, the HTML wasn't...

I like to chime in on good solutions and agree, but beyond one or two people doing it, it's not adding a lot. Seeing a couple people, especially those that...