iRobot (9/11/2012)

---

Ahmed,

I am not a DBA and haven't actually used any of those tools. But I came across some great queries which will provide SQL Agent Jobs and schedules related...

sounds like a good plan. Service Pack is the way to go first - get to a consistent state.

good luck.

p.s. this is for SQL 2005 but similar concept for 2008

http://msdn.microsoft.com/en-us/library/dd353297(v=sql.90).aspx

run > WBEMTEST , connect to "root\microsoft\sqlserver\reportserver" and then from the query... button, run "select * from __namespace" (I think its double underscore). this will tell you what instances of...

Quick query: When BIDS does return its preview is it exactly as you expect(apart from the time it takes) in terms of data ?

My last resort would be to look into the MOF file:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/184ecae8-2233-41a2-92a2-b3c0db8ac62d

Maybe you will see something that doesnt look right to you.

are you using any special characters?

any info @ MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles?

does everything look fine within reporting services config manager?

Im guessing you should check out calculated series - I have used these before to get a "moving average" over a set of data.

Ah excel, you got to love...

I tend to use the same format as you, rarley I output to Excel, last time I did that was when I sent the output to a group (AD) that...

best deadlocking article I have ever read is from the MVP deep dives book - written by Gail shaw, helped me loads. Worth buying the book just for that article.

ok thanks.

Indeed, did something similar to what you are doing - i used ssis

not sure of another way apart from re-running the installer....

AlexSQLForums (7/14/2011)

---

I usually use DTA when i have no documentation about a database that's having performance issues.

it does recommend creating indexes on every column in the where clause and depending...

thank you - that will be my bed time reading. 😀