Viewing 15 posts - 14,746 through 14,760 (of 22,227 total)
Jeff Moden (7/2/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
July 2, 2010 at 4:32 pm
michael.wiles (7/2/2010)
You alluded to the fact that you look at work history with applicable knowledge in order to give someone a position. How does someone usually get work...
"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 2, 2010 at 4:27 pm
michael.wiles (7/2/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
July 2, 2010 at 11:40 am
Dan.Humphries (7/2/2010)
I love when these types of questions get asked!
Can someone tell me how this tells...
"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 2, 2010 at 11:37 am
Really? Huh. I haven't had the chance to test it, but I would have sworn it would work. Ah well, not first time I've been wrong. Sorry for offering 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
July 2, 2010 at 8:35 am
Jack Corbett (7/2/2010)
Grant Fritchey (7/2/2010)
jcrawf02 (7/2/2010)
"I still probably won't make the cut because I'm not an A-lister."Says who?
Look at who is doing those pre-cons. Adam, Paul, Kim, Kalen, Itzik... That's...
"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 2, 2010 at 8:34 am
saad_Ahmad1 (7/2/2010)
We don't have access to the Production Database that is cutting the T-logs. The production database is with a third party. They simply provide...
"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 2, 2010 at 7:40 am
jcrawf02 (7/2/2010)
"I still probably won't make the cut because I'm not an A-lister."Says who?
Look at who is doing those pre-cons. Adam, Paul, Kim, Kalen, Itzik... That's the A-List pretty much....
"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 2, 2010 at 7:37 am
Jack Corbett (7/2/2010)
Grant Fritchey (7/2/2010)
Steve Jones - Editor (7/1/2010)
What did I do?I'm not renewed now. And perhaps I won't be if PASS gets to weigh in.
Did that blog post upset...
"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 2, 2010 at 7:00 am
From the sounds of things, I'd be looking at the queries more than I'd be worrying about the amount of memory. Yes, you're hitting the cache & the buffer hard,...
"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 2, 2010 at 6:47 am
I've never had a problem getting a block this way. Open one query window:
BEGIN TRAN
UPDATE TableX
SET Col = 42
WHERE Id = 66
Open a second query window:
UPDATE TableX
SET Col = 92
WHERE...
"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 2, 2010 at 6:44 am
Although, thinking about it, if the database is in Standby mode, you should be able to run a backup and use the COPY_ONLY option to avoid breaking the log chain.
"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 2, 2010 at 6:38 am
Since the Standby server is just holding a copy of the production backups, I'm not sure why you'd want to also backup the Standby server. At that point you're creating...
"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 2, 2010 at 6:36 am
Same way you troubleshoot & tune anything else. Identify the most costly statement and tune that first. One way to identify this would be to set up a server-side trace,...
"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 2, 2010 at 6:26 am
sachinsoni84 (7/2/2010)
somebody suggested move database from one place to anotherwill it help n if yes then why???
You would only move to another location if that other location is bigger. More...
"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 2, 2010 at 6:24 am
Viewing 15 posts - 14,746 through 14,760 (of 22,227 total)