Thanks for the quick reply. Your query gives me almost exactly what I want however when I apply it to a larger xml doc which contains several test elements...

fixed it by setting

SecureConnectionLevel Value="3"

in rsreportserver.config

I can see Sql Server grabbing all the memory it can. What I was specifically looking for was a way to determine what it was doing with it. ...

Disk Reads/Sec and Disk Writes/Sec = IOPS

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx#Table3

see table 3

The maxdop query hint goes at the end of a statement not the entire sproc.

For example

Create Procedure sp_test (@parm1 varchar(50))

as

--statement 1

select colb from table2 where col3 = @parm1

--statement 2

select col1...

I had to edit the rdl on line 1161 and remove the © 2007 Tommy Bollhofer (tbollhofer2@gmail.com)

also it line 1036. I had to change .

Other than that this...

Nice article and the reports look great but you seem to be reinventing the wheel.  Check out sql health check.  Pretty easy to implement and it can collect a lot...

This is a great article. I think the author did a reasonable test and drew reasonable conclusions. It is not a "dangerous" article by any means. Any...

The sproc itself runs fine it is the report that does not work.  Does the Log Shipping Status Report work for you?

I use sql dev pro to move database objects (mostly sprocs) from our development server to our qa server and finally on to production.  You basically feed the tool a...

Thanks for posting this solution. It worked well for me with a problem I was having with a sql 2k database that had been a publisher and had been...

I agree. Our LiteSpeed backups are much faster than the native backups.

Anyone do any testing to see what the overhead is on the db server while it is encrypting or decrypting large amounts of data? We have always pushed the...

Each of the methods mentioned in the article has its place in a DBA's tool box. I have used the XML approach many times with good performance but it...

Integrated security = Windows NT Security. From books on line: The login is created in Microsoft Windows NT® 4.0 or Windows® 2000 rather than in SQL Server. This...