Viewing 15 posts - 10,591 through 10,605 (of 22,224 total)
Kiara (8/1/2012)
Does this look like a giant advertisement to anyone else?http://www.sqlservercentral.com/Forums/Topic1039196-391-1.aspx
Nah, I'm sure 5 different people are going to swoop in and post once time on the same forum 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
August 1, 2012 at 7:38 am
SQLRNNR (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
August 1, 2012 at 7:36 am
Looks ok. No, it doesn't ignore procedures. Procedures show up in both query stats and proc stats. You can just use proc stats to narrow down what you're querying against...
"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
August 1, 2012 at 7:35 am
To get fine control over that type of maintenance, I'd suggest getting a copy of Michelle Ufford's scripts or Ola Hollengren's scripts. They'll do a much better job than Maintenance...
"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
August 1, 2012 at 7:33 am
GilaMonster (7/31/2012)
Creating a good, solid, scalable design is not premature optimisation. It's doing a good #@$@# job.
+Infinity
Especially for the curse words.
"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
August 1, 2012 at 7:16 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: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
Viewing 15 posts - 10,591 through 10,605 (of 22,224 total)