Viewing 15 posts - 106 through 120 (of 133 total)
what are you attempting to restrict the maximum memory to? SQL Server does not strictly abide to that maximum memory setting and can actually consume more than that; that being...
October 1, 2010 at 11:55 am
so what you are after is seeing for a particular row, what percentage that row is of the total?
I think the functionality you are after is you want to pull...
October 1, 2010 at 11:16 am
I've been dying to try this myself... something to keep in mind though, analyze the io stats of your db files first (see sys.dm_io_virtual_file_stats) http://msdn.microsoft.com/en-us/library/ms190326.aspx .
It could be...
October 1, 2010 at 9:56 am
No you can't even build an excel macro into a csv file. yes, excel prettily renders csv to look like an excel spreadsheet, but if you drop that csv file...
October 1, 2010 at 9:52 am
If the table has < 2000 rows, then you probably wont notice much performance impact anyway while you drop/recreate indexes; that should take care of it.
October 1, 2010 at 9:50 am
Well, the database could still have per-table permission settings - You might wanna check that. Also, is there more than one schema at play here?
October 1, 2010 at 9:39 am
Probably not worth the performance impact, but have you considered an alternative idea of using schemas to accomplish something similar? As in, create a login, lock the login down to...
October 1, 2010 at 9:36 am
Also remember that when you have drilldown, exp. 4 levels of drilldown, SSRS has to churn over that entire dataset to determine what record should fall under what grouping, even...
October 1, 2010 at 8:43 am
I'd also keep an eye on your SSRS executionlog2 view. See if you can build a correlation between report executions and the paging messages in the log. You may find...
October 1, 2010 at 8:37 am
Use perfmon to figure out if SQL Server is the memory hog or SSRS... thats a starting point.
If you set max memory in sql server to 2gb, and ssrs...
September 30, 2010 at 6:39 pm
Why not have the report just display the aggregates, and create a subreport that has the details, and link to the subreport through an action. This way, if the end...
September 30, 2010 at 2:59 pm
If the login you are using does not have permissions to get statistics, then what is likely happening is the connection from db_1 tells db_2 to basically return all possible...
September 30, 2010 at 2:52 pm
Do you have database traces for that period of time? I think a trace may be revealing. It could show if you have a very memory intensive transaction or something...
September 30, 2010 at 2:43 pm
SSRS is a great tool, but it does not handle large datasets well. It often does not paginate correctly, if you export large reports to excel, ssrs eats up a...
September 30, 2010 at 2:39 pm
I assume you mean how do you do this in Report Builder?
And you are needing help with how to write an expression for column 4 to give the results as...
September 30, 2010 at 1:42 pm
Viewing 15 posts - 106 through 120 (of 133 total)