Viewing 15 posts - 14,296 through 14,310 (of 22,219 total)
WayneS (9/27/2010)
CirquedeSQLeil (9/27/2010)
Sometimes we learn quite a bit through our articles and our blogs that we would not have learned otherwise.
So true. In fact, the last article that I...
"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
September 27, 2010 at 9:17 am
Steve Jones - Editor (9/27/2010)
Alvin Ramard (9/27/2010)
Jeff Moden (9/26/2010)
... there are a whole lot of people that should'na be allowed near a computer never mind a database.
Seen too many that...
"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
September 27, 2010 at 8:42 am
While we're waiting for more information, a pretty simple rule, if you're moving everything, every time, it's pretty difficult to "tune" the process. You should validate that the amount of...
"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
September 27, 2010 at 6:59 am
Big system or small, the question for me when upgrading the system is, how can I do it safely? What's the best method for protecting the business' data?
The answer to...
"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
September 27, 2010 at 6:56 am
Yes and no. Is it a good idea to understand how common concepts apply across platforms? Sure is. But you can only get so deep on multiple systems. If 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
September 27, 2010 at 6:43 am
Replacing the GUID with an integer, especially on the cluster, is a good idea, but I would not go through that interim step of moving it to varchar first. You're...
"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
September 27, 2010 at 5:43 am
I just got bad news. I've seen the schedule for the PASS Summit. I'll be speaking to an empty room because I'm presenting the same time as Jeff.
Hey Jeff,...
"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
September 27, 2010 at 5:39 am
Steve Jones - Editor (9/24/2010)
Paul White NZ (9/24/2010)
The Dixie Flatline (9/23/2010)
"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
September 24, 2010 at 11:25 am
Well, we're already not comparing apples to apples then. That just makes it harder. No differences in the connection settings, both using the same driver (albeit, different versions)?
I haven't seen...
"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
September 24, 2010 at 11:23 am
Good catch Lowell. I didn't see that 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
September 24, 2010 at 9:53 am
Instead of SSMS or Trace, try using the DMV's.
sys.dm_exec_requests will show open, active requests, not just open connections. If you have an uncommitted transaction, it'll be there.
"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
September 24, 2010 at 9:24 am
Are you getting an error or is there missing/incorrect data?
"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
September 24, 2010 at 9:22 am
So you're saying that the 2008 instance moves more data locally and then processes faster than the 2005 instance...
Are there other differences? More memory, better/more cpu's? Are the connection settings...
"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
September 24, 2010 at 9:21 am
You mean that the exact same amount of data is moved regardless of which side you run the query from? Are you sure that one side or the other isn'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
September 24, 2010 at 9:04 am
GilaMonster (9/24/2010)
Grant Fritchey (9/24/2010)
Based on the info in the spread sheet, it looks like you have out of date statistics. You've got missing stats warnings.Or maybe auto_create_stats turned off?
Yep, absolute...
"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
September 24, 2010 at 9:00 am
Viewing 15 posts - 14,296 through 14,310 (of 22,219 total)