got it, thanks!

Hi Grant, I have a question,

I see that sys.dm_exec_cached_plans has a column objtype, and one of the values for this column is "Adhoc". Could this object/column be used to...

Congratulations! 🙂

I'm placing an order today too.

Just as a reference, the query returned the following error:

Msg 536, Level 16, State 5, Line 1

Invalid length parameter passed to the SUBSTRING function.

I "fixed" it by adding the last...

Most excellent, thank you very much!

BTW, when is your SS 2012 Performance Tuning book coming out?

Well, I feel like a dummy. The reason why there is a space is because the column that is there is null. Any way to make sure that...

OMG, great idea, I'll give it a try! Thank you!

Thank you Stephanie, I played around with it, but it didn't help unfortunately.

I changed the bottom textbox to include the value from the top box. So whereas the top...

Thank you soooo much Daniel, I just tried it and it works!!!! Here's what I did, just in case someone else needs this info:

1. Dropped a list tablix...

Thank you Daniel, I'll try that in a couple of hours and let you know if I have any questions, many thanks!

I have been trying for a few hours, but can't make this to work. The farthest I have gotten is to have a table object, created a group column,...

Hi seth, thanks so much for the help!

Yes, I did google, but all I got was repeating table headers on each page. Now that I think about it,...

Thanks Mike, I am reading Microsoft SQL Server 2008 Reporting Services by Brian Larson. It has a picture of the chart and it has the drop fields on there...

Thank you very much all

Jason, your post is most appreciated, thank you!

Thanks for your reply. Yes, the job is set to run under the proxy account, which is a sql server login. So, when it tries to create this...