Viewing 15 posts - 4,051 through 4,065 (of 18,926 total)
Jack Corbett (8/2/2011)
August 2, 2011 at 6:49 am
I use that partcular script in prod and it works just great.
I used to do stats too but there was a bug so it has been taken out for the...
August 2, 2011 at 6:34 am
I'd bet that this is a massive query that processes a tonne of data and that is using parallelism.
Killing the connection is not going to solve anything. You need...
August 2, 2011 at 6:26 am
This would be a hack but "MAYBE" it could work. Put a synonym on that table. Reference the table once and then the synonym.
Never tested it, but it...
August 2, 2011 at 6:24 am
You guys actually test your code? More power to you :hehe:.
August 2, 2011 at 6:19 am
Ignoring the <uselessly> complexe query by peso... so what did you come up with?
August 2, 2011 at 6:15 am
I'm not 100% sure this matches the article (read it months / years ago).
I'll simply deffer to Jeff's amazing work and point out that you should do exactly...
August 2, 2011 at 6:12 am
SQLkiwi (8/1/2011)
brian118 (8/1/2011)
To avoid long term maintenance of unused statistics, SQL Server 2000 ages the automatically created statistics (only those that...
August 2, 2011 at 6:07 am
Ray Mond (8/1/2011)
Ninja's_RGR'us (8/1/2011)
I was not reffering to goes bad after being good.
I was talking about being bad right after taking it... like...
August 2, 2011 at 6:03 am
WHY??????????????
Load why script or any other you wish to use and see what it builds. All you need is to do Select Whatever FROM dbo.Calendar WHERE dt BETWEEN @Start...
August 2, 2011 at 6:00 am
SQLkiwi (8/1/2011)
Indianrock (8/1/2011)
Some have suggested setting forced parameterization on in MSDB to help with this. Any downsides to that?
It's worked fine for me in the past. I also...
August 2, 2011 at 5:56 am
rod-935188 (8/1/2011)
Thanks, though I will probably use a tempory table for this.The calenar code may come in handy for another project and I appreciate the support.
The calendar table IS the...
August 1, 2011 at 6:04 pm
Nothing tricky. So simple it actually looks like homework.
What have you tried and why do you think it's not working?
August 1, 2011 at 5:57 pm
Please start a new thread and specify your exact version and cmdshell restrictions and post the link in here..
August 1, 2011 at 5:55 pm
Here's mine if it helps faster (canadian holidays, but that's easy to fix).
August 1, 2011 at 5:40 pm
Viewing 15 posts - 4,051 through 4,065 (of 18,926 total)