Stuff could break during the process, so you should make a backup before you do this, validate that the backup is good (by restoring it somewhere) and then make the...

I too have found, on occasion, that the rollback just won't finish. A reboot can (not won't) clear it much faster. You're taking a chance, but I'd try bouncing the...

You do have some disparity between estimated and actual rows, so you might have some issues with the age of your statistics. That clustered index seek on 300000 rows against...

First, a view is not going to improve performance. A view is just a query. That's all.

To improve performance you need to understand how your database is being queried. If...

Do you have a limit on the SQL Server memory setting? I'd look there first.

Second, what kind of queries are being run?

I'd be curious how you're incorporating the 3rd party tool into your native backups, assuming that's what's going on. Also, why.

When tuning queries the execution plan is a must. I know you said you have indexes, but we can't tell whether or not they're being used without the execution plan....

ravisamigo (3/24/2011)

---

Thanks.

But I have tried to keep the database in suspect mode and set the alert severity to 23 but I couldn't get any alert.

In event eveviewer, I can see...

It runs one way in the datawarehouse and one way when you call it using EXEC. Are these two different applications making the call? If so, I'd check the connection...

Elliott Berkihiser (3/23/2011)

---

Gail, Grant

Thanks.

I understand how OPENQUERY directs the processing to the remote machine, and I'll look at that.

I was curious about the situation with Views. Since...

I'm with Gail. Most of the time OPENQUERY puts the processing on the remote machine. You can get some filtering done there and then only bring back the data you...

As long as you're running this function on the column, you're guaranteed table scans: CONVERT(char(10), dbo.Notes.FollowUp, 111)

OK. but if you're still looking for an answer, can you supply some more information. Fine, you're pulling 2000 rows,...

annasql (3/23/2011)

---

Thanks, the SQL Server Agent Schedule Decoder link works.

And also when I right click the job, I can see manage schedule. But how can I export the list and...

Brandie Tarvin (3/23/2011)

---

Off-topic Self Promotion!

A-Kon 22, the biggest Anime convention in the U.S., will be throwing a launch party for The Ladies of Trade Town anthology (edited by Lee Martindale)....