Viewing 15 posts - 13,531 through 13,545 (of 22,219 total)
Stefan Krzywicki (1/24/2011)
Grant Fritchey (1/24/2011)
Threadizens not on Twitter might not have heard the word. I just took a job with Red Gate. It's up on the blog.
Congratulations! Still in 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
January 24, 2011 at 9:21 am
Threadizens not on Twitter might not have heard the word. I just took a job with Red Gate. It's up on the blog.
"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
January 24, 2011 at 9:01 am
Steve Jones - SSC Editor (1/22/2011)
Definitely not SQL related, but my kid got his black belt today. Very proud of him.
Congratulations to you both. That's quite the achievment.
"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
January 23, 2011 at 11:28 am
The DMVs are usually more for tactical style monitoring, checking information at the moment, not long term. To use the DMV for long term monitoring, you just need to capture...
"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
January 21, 2011 at 6:03 pm
GilaMonster (1/21/2011)
Brandie Tarvin (1/21/2011)
GilaMonster (1/21/2011)
5 min later meeting...
"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
January 21, 2011 at 5:07 am
I don't understand. You said that you had to put 2tb into 100gb. That's a problem.
But that has nothing to do with virtual or not virtual. Can you install &...
"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
January 21, 2011 at 4:27 am
You should be testing anything new before you do it on your production database. No development environment or anything. You're developing straight onto production? That's very dangerous. I sure hope...
"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
January 20, 2011 at 9:40 pm
Both files when I try to open them are giving me an error:
The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and...
"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
January 20, 2011 at 12:41 pm
Out of the box, no additional installs or purchases, you can use Performance Monitor to gather metrics on stuff like Memory usage. It can also be used to monitor I/O,...
"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
January 20, 2011 at 11:57 am
No, it was a stupid design.
"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
January 20, 2011 at 11:19 am
Getting the exact same plan with that much data between a table variable & a temp table indicates something else is going on. Is auto-create stats or auto-update of stats...
"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
January 20, 2011 at 11:14 am
Steve Jones - SSC Editor (1/20/2011)
"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
January 20, 2011 at 10:52 am
We had a similar situation. A procedure (with a 76 table join) that was called hundreds of times in an hour. It hit so many tables and the data was...
"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
January 20, 2011 at 10:41 am
Table variables like you're using show as having a single row because they don't have statistics. This can lead to seriously problematic execution plans, like you're seeing. If you have...
"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
January 20, 2011 at 10:34 am
Personally, I wouldn't run it as a script. I'd use SQL Agent and a SQL Agent job with steps. It'll be much more functional, better error trapping, etc. If not...
"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
January 20, 2011 at 8:28 am
Viewing 15 posts - 13,531 through 13,545 (of 22,219 total)