meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 11 months |
| seen | Apr 25 at 12:29 | |
| stats | profile views | 6 |
SQL Server Developer and sometimes DBA.
Formerly a Programmer Analyst and a Software Developer w/ experience in ASP.NET, DHTML, and VB6.
|
Mar 1 |
awarded | Nice Question |
|
Oct 9 |
comment |
SSRS - rsAccessDenied error This seems contradicting because the report runs ok on the report manager (which requires a data source) but you can't set up a data source for a subscription (you should be able to use the same data source that worked before). When you originally ran the report on the report manager, was that locally on the server? Are you able to run the report in the report manager remotely? |
|
Oct 9 |
awarded | Critic |
|
Oct 9 |
comment |
Tablix cells width issue in SSRS This belongs @ Stack Overflow with a Reporting Services tag. (I don't have the rep to do that myself.) |
|
Sep 14 |
comment |
Is there any benefit to defragmenting SQL indexes in a SAN environment? FWIW, I had overlooked something completely - the actual script in the job step (rather than the source) was configured to address every index that had a minimum fragmentation percentage of 1. I bumped that up to 15 and also bumped the rebuild threshold from 30 to 35. The job now runs in a little over 3 hours rather than 8. Your suggestion to be less aggressive was correct. My fault lied in the fact that I thought the job had already been implemented to be less aggressive. This approach is probably best for us, still touch and go but it already alleviated some pain. |
|
Sep 6 |
comment |
Is there any benefit to defragmenting SQL indexes in a SAN environment? Our immediate strategy is to do just that - we are going to tweak the settings for the minFragmentation and rebuildThreshold variables in this script: sqlfool.com/2011/06/index-defrag-script-v4-1 |
|
Sep 6 |
accepted | Is there any benefit to defragmenting SQL indexes in a SAN environment? |
|
Sep 6 |
comment |
Is there any benefit to defragmenting SQL indexes in a SAN environment? Wow, thorough answer. It will probably take some time for me to do all of the research, but I don't doubt that you are leading me on the right track. Our current strategy is in fact to run maintenance less aggressively from both a rebuild and a reorg standpoint, I think I misstated that in the question. From there I'll do more research into the rest of the factors you mentioned. |
|
Sep 5 |
asked | Is there any benefit to defragmenting SQL indexes in a SAN environment? |
|
Jun 27 |
comment |
How to query EndDate value from ReportServer..Subscriptions.MatchData Excellent, thank you so much! I had tried one or two namespaces that are used in my other SSRS metadata scripts, but to no avail. Thanks for the link too. |
|
Jun 27 |
awarded | Supporter |
|
Jun 27 |
awarded | Student |
|
Jun 27 |
awarded | Scholar |
|
Jun 27 |
accepted | How to query EndDate value from ReportServer..Subscriptions.MatchData |
|
Mar 13 |
asked | How to query EndDate value from ReportServer..Subscriptions.MatchData |
