You sound screwed to me. Do you still have the database on the USB drive? What happens if you use that and attach it on another SQL Server?

Hey, I have what seems like a relatively easy upgrade. Need to add Twitter account to the Contact information.

Darn it Lynn that's twice today!

Those stats aren't too bad. I would say that you should definitely have other indexes besides the clustered index, but no one can tell what you should have for...

Well if you know how many processors are in your server then running

xp_msver 'ProcessorCount'

And dividing the number retuend by the # of processors you'll get the cores as that code...

Luiz (7/10/2009)

---

They are not regular users. They are new developers and made some mistakes. The same mistake that a DBA can make. So I'm just exploring alternatives.

All suggestions here are...

If you are really running SQL Server 2005 then as Lowell mentions there are better ways to get this information using the DMV's and DMF's available. Here's a [url=http://www.sqlservercentral.com/articles/DMV/64425/...

CirquedeSQLeil (7/10/2009)

---

My preference would be to defrag the indexes - exclusive of rebooting the servers weekly. And if you defrag indexes weekly, you should update statistics after the defrag...

Start by reading this.

Where can we look for the default trace information? How...

First I have to ask why are you rebooting weekly? I've even had SQL 7.0 boxes go months without needing a reboot.

As far as I know indexes are not...

Guess I was too slow, as usual.

Lynn has an interesting solution, but I'm not sure I'd want to count on the alert to fire a backup.

Another thought is that I...

I understand that this would reduce the # of files you need to restore in order to restore the database, but is it really worth it?

If you run a trace...

A couple of questions:

Do you have other reports on that reportserver that are working fine?

What else is running on the server at that time?

I'd run a server-side trace overnight to...

Terry,

I have to agree with kramaswamy on this one. By OR'ing in the WHERE clause there is the likelihood that you will not be able to do an index...

In order to eliminate the IF...ELSE we need to know what you would expect returned and in order to know that it would be helpful if you posted some sample...