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)....

It really depends on the query, the structure of the table, the indexes on the table, the number of users on the system and the queries they're running, memory and...

Depending on the query, the optimizer is blazingly fast. But, it's still not zero, I get it. Usually when you hit a limit based on how a tool behaves you...

No, you can't really avoid the compile process. If you try plan forcing you're at least guaranteed which plan you get.

Not without execution plans to compare. It's just too hard to know what's going on since we're not sitting there.

Jack Corbett (3/23/2011)

---

Grant Fritchey (3/23/2011)

---

SQLkiwi (3/23/2011)

---

Grant Fritchey (3/23/2011)

---

Since we're paying the facility per person, we have to try to keep our attendance at 325 or we'll owe more money. It's...