Viewing 15 posts - 5,011 through 5,025 (of 18,926 total)
OCTom (7/7/2011)
July 7, 2011 at 7:37 am
ziako (7/7/2011)
I am using SQL reporting services and asp.net
And ASP has the reportviewer control. Which you can use to show ssrs reports.
Did you read anything on the links I...
July 7, 2011 at 7:13 am
As I said, I've heard (and maybe focussed) on all the horror stories. I'm sure that now that the bugs are ironed out that this is a very viable...
July 7, 2011 at 6:07 am
That's the only chance you have to tune this.
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
Once that's done, post the new execution plans and I'll see if I can help further.
P.S. Of the 17 parameters, are the...
July 7, 2011 at 5:47 am
Why not just join to the errors table?? You know, for when it gets updated?
July 7, 2011 at 5:33 am
steveb. (7/6/2011)
halifaxdal (7/6/2011)
Ninja's_RGR'us (7/6/2011)
steveb. (7/6/2011)
the maintainence plan wizard will also setup these date stamped backups for you.
MP have always been buggy over the years... I've pretty much lost...
July 7, 2011 at 5:32 am
opc.three (7/6/2011)
Which jdbc driver are you using? And can you post the code for the temporary stored proc?
(@P0 bigint, @P1 datetime)EXEC Test_db1.dbo.sp_CreateDynamic @P0, @P1</curious>
You can attach as a file.
July 6, 2011 at 11:48 am
In the select you have a duplicate key.
Or you forgot to activate identity on your pk.
July 6, 2011 at 11:37 am
as2higpark (7/6/2011)
Thanks everyone for your contributions, when we have a fix, I will...
July 6, 2011 at 11:05 am
Stefan Krzywicki (7/6/2011)
Ninja's_RGR'us (7/6/2011)
Then exporting to excel there's 1 gazillion cells merges, colors changent, etc.
Takes 1 hour...
July 6, 2011 at 10:28 am
2 things
#1 I told you to dump the split results into temp table.
#2 I asked for the actual execution plan and indexes.
July 6, 2011 at 9:46 am
Then use reportviewer control. It's designed to do just that.
July 6, 2011 at 9:29 am
Report looks nice in the web version (not html export, just viewing the report).
Then exporting to excel there's 1 gazillion cells merges, colors changent, etc.
Takes 1 hour just to unmerge...
July 6, 2011 at 9:00 am
Post the proc code and the execution plans (actual).
We'll also need the indexes available for all tables.
July 6, 2011 at 8:58 am
Want to run another idea by you.
Is there any way to convert a ssrs report that get slutered by the excel eport to use sharepoint so that the formatting can...
July 6, 2011 at 8:48 am
Viewing 15 posts - 5,011 through 5,025 (of 18,926 total)