Viewing 15 posts - 16,291 through 16,305 (of 22,213 total)
SQL Server will manage it's own memory, so from the OS all you'll see is that SQL Server is using X, in this case 5gb. You can limit the amount...
October 16, 2009 at 6:38 am
First, I'd strongly suggest switching to ANSI 92 syntax
SELECT...
FROM a
JOIN B
ON a.id = b.id
Second, you don't have any kind of filtering, so the query is going scan all the...
October 16, 2009 at 6:34 am
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
Viewing 15 posts - 16,291 through 16,305 (of 22,213 total)