Viewing 15 posts - 91 through 105 (of 130 total)
Sorry, I don't have an answer. I've always wrestled (both in RS 2005 & 2008) in how report column headers get grouped, formatted and exported to MS Excel.
July 15, 2011 at 6:55 am
Does the header show up when you export to .pdf? If so, I would expect the header to export to the first rows of your Excel worksheet.
July 15, 2011 at 6:37 am
Poor question; how do you know what my expectations were?
July 15, 2011 at 6:23 am
It looks like a mistake again in the QOTD. Point please, as I checked Enterprise and DataCenter (which is correct)
Thanks,
Rob
July 15, 2011 at 6:10 am
fastformation01 (7/14/2011)
If I wrote an application to use ADO or DAO recordsets, can this database be read using SQLServer?
Generally, it is the other way around. The data resides in...
July 14, 2011 at 7:10 am
Ninja's_RGR'us (7/13/2011)
Time check for fragmentation, run update_stats on all tables with fullscan if you have a big...
July 13, 2011 at 1:55 pm
This has been extremely educational and helpful.
is_auto_create_stats_on is_auto_update_stats_on is_auto_update_stats_async_on name ...
July 13, 2011 at 1:32 pm
At a previous job, we moved a SQL Server from a physical box to a virtual server. I was pleasantly surprised that performance didn't suffer. I had always...
July 13, 2011 at 1:23 pm
I've just started using Erwin; it seems moderately straight-forward to use; but it does have some quirky interface & nit-picky things that you have to get used to.
My $.02,
Rob
July 13, 2011 at 12:08 pm
Ninja's_RGR'us (7/13/2011)
There's still loads wrong with this.
For today's fire, I think it's good enough. When the DBA for this server for this comes back, I'll want to discuss this...
July 13, 2011 at 12:02 pm
The only other difference is that I added one index (as recommended by Execution plan) for school year and grade on MEAP_SCORE.
CREATE NONCLUSTERED INDEX [IX_SCHOOL_YEAR_GRADE] ON [dbo].[MEAP_SCORE]
(
[school_year_id],
...
July 13, 2011 at 10:11 am
Major thanks to everyone (especially Ninja's_RGR'us); the whole select is down to a couple of seconds. When the owner of this DB comes back, I'll talk with him about...
July 13, 2011 at 9:42 am
Ninja's_RGR'us (7/13/2011)
Any reasons you don't have a clustered index on Schools and SCHOOL_YEARS?
Good questions; both SCHOOL and SCHOOL_YEAR tables (and quite a number of other tables) have PK that are...
July 13, 2011 at 8:59 am
Ninja's_RGR'us (7/13/2011)
Are you able to add those 3 columns in the included part of...
July 13, 2011 at 8:23 am
RTaylor2208 (7/13/2011)
July 13, 2011 at 7:13 am
Viewing 15 posts - 91 through 105 (of 130 total)