Viewing 15 posts - 16,291 through 16,305 (of 22,211 total)
It's also possible that you're getting statistics updated, but the standard statistics update is sampled. You might need to update the statistics through a full scan, which does happen as...
October 16, 2009 at 6:25 am
The best straight T-SQL book out there, in my opinion, is Itzik Ben-Gan's Inside T-SQL Querying. Fantastic. It should do most of what you need.
October 16, 2009 at 6:19 am
Layne-812700 (10/15/2009)
Also, had a...
October 16, 2009 at 5:45 am
Jack Corbett (10/15/2009)
Okay threadiatics, if you have choice between putting data for multiple applications in 1 database because there is some common data or application specific databases?
Unless there's just...
October 15, 2009 at 1:37 pm
GilaMonster (10/15/2009)
Slick84 (10/15/2009)
Okay Gail, here is my execution plan after making the above changes. Unique non-clustered index on fstrShortsku and EDPno included in index for tblRegularItems.
Excellent. This looks about as...
October 15, 2009 at 1:33 pm
There isn't a single value that I can tell you to give to that. It really depends on your system. You might have some huge report that pulls together thousands...
October 15, 2009 at 6:48 am
No. We're hitting issues with the tool that generates our geographic shapes not properly closing all the polygons it generates (and occasionally generating polygons with lines that cross...). We can't...
October 15, 2009 at 6:36 am
I'm sorry, I'm still stuck on what it is that you're trying to do.
Also, because I'm just not going to try to type your code into my system, if...
October 15, 2009 at 5:26 am
P Jones (10/15/2009)
October 15, 2009 at 5:20 am
More excellent answers.
And yes, Darwin had a heck of a beard. Maybe it's time to grow mine again.
October 15, 2009 at 5:15 am
Bob Hovious 24601 (10/14/2009)
"You'll have to get the rest of your question answered by someone else... they're about to close the casket, and nobody bothered to put extra batteries...
October 14, 2009 at 3:13 pm
jcrawf02 (10/14/2009)
Grant Fritchey (10/14/2009)
GilaMonster (10/14/2009)
http://www.sqlservercentral.com/Forums/Topic803081-338-1.aspx
Some else can have the pleasure of this one. I'm going to spend an hour trying to conquer the galaxy,...
October 14, 2009 at 3:12 pm
forum member (10/14/2009)
October 14, 2009 at 2:59 pm
This PDF has an article called The Questions. If I understand what you're trying to do, I show three different ways to solve that problem.
October 14, 2009 at 2:53 pm
Viewing 15 posts - 16,291 through 16,305 (of 22,211 total)