Viewing 15 posts - 10,606 through 10,620 (of 22,224 total)
GilaMonster (7/31/2012)
Grant Fritchey (7/31/2012)
GilaMonster (7/31/2012)
Brandie Tarvin (7/31/2012)
Gail, got any completed science fiction / fantasy novels in your dresser drawer?No, nothing at the moment.
But you have a vaca coming up, so...
"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:41 am
erics44 (7/31/2012)
Grant Fritchey (7/31/2012)
I'd say...
"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:33 am
Looking at the plans, the first thing that jumps out is that the estimates are different between the two plans. This suggests that you either have completely different data sets...
"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:27 am
No way to know for sure why you're suddenly seeing slow performance. Can you gather more metrics? Take a look at sys.dm_exec_requests. Can you see the backup process? Is 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 6:18 am
Just a question, changes are getting made to the production server directly and then you need those brought down to dev and we're not talking data?
I'd say the process is...
"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:15 am
GilaMonster (7/31/2012)
Brandie Tarvin (7/31/2012)
Gail, got any completed science fiction / fantasy novels in your dresser drawer?No, nothing at the moment.
But you have a vaca coming up, so just turn one...
"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:10 am
GilaMonster (7/30/2012)
Steve Jones - SSC Editor (7/30/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 4:53 am
Kishan Singh (7/30/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 4:52 am
Ian Scarlett (7/30/2012)
Grant Fritchey (7/30/2012)
You can't output a cursor in SQL Server. You don't have that option.
I think you can (not that I'm advocating it)...
USE tempdb
GO
CREATE PROCEDURE obj_cursor @obj_cursor CURSOR...
"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 30, 2012 at 6:37 am
The hard part will be the break-in. You just need the right person to see your experience (Jeff, me, others who look for that above MCSEIO) and you should be...
"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 30, 2012 at 6:02 am
SQL* (7/30/2012)
That means only we have to use in Oralce not in SQL Server?if yes, why we have this option in sql server?
You can't output a cursor in SQL Server....
"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 30, 2012 at 5:56 am
I would probably set up a job within SQL Agent that does the backup, running as sys admin, and then give the users permission to execute the job (which can...
"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 30, 2012 at 5:46 am
Morning threadizens. I just deleted a couple of hundred emails from you lot. Did I miss anything really important in the last seven days?
"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 30, 2012 at 5:01 am
I don't know of a book just on the disk sub-system, but the disk sections of Kalen Delaney's book, SQL Server Internals, is absolutely a must-read. Also Chris Bolton's book,...
"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 20, 2012 at 7:48 am
SQLSACT (7/20/2012)
Grant Fritchey (7/20/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 20, 2012 at 5:25 am
Viewing 15 posts - 10,606 through 10,620 (of 22,224 total)