Viewing 15 posts - 14,746 through 14,760 (of 22,219 total)
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
I'm not so sure about testing. The interview process where I work includes considerable time at the white board. We talk about queries & table structures & TSQL. I'll put...
"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:12 am
mohammed moinudheen (7/1/2010)
By any chance, is there a policy template for detecting disabled jobs in a server.If so, please share with me.
There are none of checking for disabled jobs out...
"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:00 am
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 people? It shouldn't. Ah...
"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 5:24 am
I would flat out not recommend using SQL Server to store files. It does a lousy job of it, as you're finding. I'd store the files on the file system...
"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 1, 2010 at 9:24 am
If you really want to be able to do anything with the data, I'd suggest performing that work on the client side, in code or the reporting tool or what...
"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 1, 2010 at 9:18 am
balasach82 (7/1/2010)
am insering the trace records into a table. The problem is there is nothing in the TextData field other than those run from...
"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 1, 2010 at 6:00 am
Lamprey13 (6/30/2010)
HowardW (6/30/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
June 30, 2010 at 11:38 am
Kit G (6/30/2010)
HowardW (6/30/2010)
It would be interesting to see if this could be converted to an Inline...
"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
June 30, 2010 at 8:02 am
Viewing 15 posts - 14,746 through 14,760 (of 22,219 total)