Viewing 15 posts - 7,306 through 7,320 (of 18,926 total)
There's nothing normal in SQL server.
It would be abnormal if the avg is 1M reads and then all of a sudden, it jumps 1000 folds to 1 Billion reads.
You certainly...
January 18, 2011 at 9:53 am
I see. So we're back to a simple if in ± 20 triggers. Sounds like the easiest doable way at the moment.
January 18, 2011 at 9:43 am
It only sounds like you got some tuning to do on that query!!!
With only 1 write per run, I wouldn't worry about it.
January 18, 2011 at 9:37 am
Why did they reject that option?
The only big overhead I see is the remember to change schema in 2 places rather than one.
Option z might be to create a db...
January 18, 2011 at 9:13 am
Glad to. I'd most likely turn it into a short article or script as well.
Thanks again.
January 18, 2011 at 8:57 am
Awesome.
One last question.. Got any links on how to configure the external tools so that I can link this script and make my own single click deploy function?
January 18, 2011 at 8:46 am
Linda Claes (1/18/2011)
I indeed saw this behaviour before. Especially changing the obligatory parameters is causing me headaches. For that reason we have a custom reporting services script (.rss file)...
January 18, 2011 at 8:27 am
Another quick question for ya. Have you noticed in ssrs 2k5 that when you deploy to overwrite a report, the overwrite doesn't work or only works partially??
Any workaround...
January 18, 2011 at 8:10 am
Here's another idea that might require much less coding and QA.
How about copying the DDL of the tables involved and calling tblname_hist.
Then copy the forms in question (or even use...
January 18, 2011 at 7:26 am
And please post back the link here once you're done so we can vote on it (I've had this issue before and chose the recoding way. I would've loved an...
January 18, 2011 at 7:18 am
GSquared (1/18/2011)
Have you added it to MS Connect? http://connect.microsoft.com/You can suggest new features, report bugs, et al, through there.
Good point. Also they can often suggest alternatives you had...
January 18, 2011 at 7:17 am
Are you able to do a simple select in the same excel file?
January 18, 2011 at 6:57 am
Windows 32 or 64 bit?
Sql 32 or 64 bit?
Are you able to do a simple select in the same excel file?
January 18, 2011 at 6:18 am
How about adding a computed column and index it? Index view?
January 18, 2011 at 2:23 am
That was doing a good job in 2003. I have not tried it since so maybe it can help you out.
There's a free trial so you should have enough...
January 17, 2011 at 11:50 am
Viewing 15 posts - 7,306 through 7,320 (of 18,926 total)