Viewing 15 posts - 16,306 through 16,320 (of 22,229 total)
Slick84 (10/16/2009)
Slick84 (10/15/2009)
Thanks for the input. You definately are making sense and yes the requirement you described is how I want it. I'm basically inserting records from tblRegularItems into tblProductSizeWidthColor...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 16, 2009 at 7:24 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 16, 2009 at 6:19 am
Layne-812700 (10/15/2009)
Also, had a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 15, 2009 at 1:33 pm
Me neither.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 15, 2009 at 6:49 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 15, 2009 at 5:26 am
P Jones (10/15/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 14, 2009 at 3:13 pm
Viewing 15 posts - 16,306 through 16,320 (of 22,229 total)