Viewing 15 posts - 10,591 through 10,605 (of 22,219 total)
SQLSACT (7/31/2012)
Grant Fritchey (7/31/2012)
"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
July 31, 2012 at 11:25 am
SQLSACT (7/31/2012)
Grant Fritchey (7/31/2012)
"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
July 31, 2012 at 11:21 am
You should test both approaches.
But, in general, I would expect you'd get better performance by putting all the data into a single table. That assumes that the index on Account#...
"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
July 31, 2012 at 10:33 am
The DMV stores data for queries that are currently in cache. As soon as a plan ages out of cache all the information in that DMV is lost. So it...
"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
July 31, 2012 at 9:06 am
iashurova (7/31/2012)
"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
July 31, 2012 at 9:03 am
SQLKnowItAll (7/31/2012)
Grant Fritchey (7/31/2012)
"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
July 31, 2012 at 8:42 am
I worked on a project for about three years (it was supposed to take 18 months) that still wasn't done when I left the company. They too had jumped on...
"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
July 31, 2012 at 8:13 am
One is estimating 230000 rows and the other is estimating millions. That is either a difference in data or in stats on the data. Must be. No other options.
"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
July 31, 2012 at 7:56 am
I had extremely limited opportunity to try SSMS 2012 against 2000, but against 2005, 2008, & 2008R2, it works great. No issues at all.
"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
July 31, 2012 at 7:04 am
erics44 (7/31/2012)
The comparrison tools are the kind of thing i was looking for
i was considering scripting the procs and stuff from the sys tables and comparing that way, building 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
July 31, 2012 at 6:57 am
GilaMonster (7/31/2012)
Grant Fritchey (7/31/2012)
GilaMonster (7/31/2012)
Brandie Tarvin (7/31/2012)
Gail, got any completed science fiction / fantasy novels in your dresser drawer?No, nothing at the moment.
But you have a vaca coming up, so...
"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
July 31, 2012 at 6:41 am
erics44 (7/31/2012)
Grant Fritchey (7/31/2012)
I'd say...
"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
July 31, 2012 at 6:33 am
Looking at the plans, the first thing that jumps out is that the estimates are different between the two plans. This suggests that you either have completely different data sets...
"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
July 31, 2012 at 6:27 am
No way to know for sure why you're suddenly seeing slow performance. Can you gather more metrics? Take a look at sys.dm_exec_requests. Can you see the backup process? Is it...
"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
July 31, 2012 at 6:18 am
Just a question, changes are getting made to the production server directly and then you need those brought down to dev and we're not talking data?
I'd say the process is...
"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
July 31, 2012 at 6:15 am
Viewing 15 posts - 10,591 through 10,605 (of 22,219 total)