Restoring a backup to a different server has no impact whatsoever on the original server the backup was created from. Are you using a maintenance plan per say or...

Has there been ANY data altering activity performed on the testing db since it was restored?

No, you need to place the query hint inside the stored-procedure itself, however you could set the TRANSACTION ISOLATION LEVEL to READ UNCOMMITTED and that will set it for the...

If you create a custom alert for SQL Error # 1101 or 1105 (not sure exactly which is which, you can Google that) it will send you an alert should...

There are many SQL Server Events, SQL Performance Condition Alerts, as well as WMI Events that can be set up rather easily under SQL Server Agent >> Alerts.

Settings...

Also, check your SQL Logs and Windows Event Logs for unusualerrors. Sometimes "sudden" performance issues can be related to issues with the disk subsystem (i.e. RAID arrays). ...

Is the full backup still available? Or has it already been removed from the backup location?

Side note: Did they recently add more space to the VM? Often times when...

I don't think so, but you can try. In my case, I had to restart the entire server

I was referring to sysindexes, it's eventually being replaced by sys.indexes. Or am I completely confused? :ermm:

Reasoning for wanted to limit frequent file growth is because of the contention created by having to grow the data/log files on the disk(s). It's often best to choose...

Mister Sachmo (10/31/2012)

---

Thanks, folks.

Kraig, I was doing a straight rowcount of a 4 million row table, so that would explain the perf difference. The code I saw used SUM(1) for...

Can you restart the server? In all honesty if you've not changed anything on the SQL Server (or no one else has either) and a full restart doesn't correct...

Agree with what every one is saying here...you need and want SQL backups.

The "benefits" have been well mentioned here already but wanted to point out that for DBs in simple...

Sorry to ask a redundant question but can you confirm that NO mail has been sent? Or has some gone out? Do you know if anything has changed...

Anything unusual showing up in the windows event viewer under application or system? I've had an issue in the last where a dependent library (dell) bombed and had to...