Viewing 15 posts - 10,606 through 10,620 (of 22,226 total)
I had extremely limited opportunity to try SSMS 2012 against 2000, but against 2005, 2008, & 2008R2, it works great. No issues 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
July 31, 2012 at 7:04 am
erics44 (7/31/2012)
The comparrison tools are the kind of thing i was looking for
i was considering scripting the procs and stuff from the sys tables and comparing that way, building a...
"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:57 am
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
Viewing 15 posts - 10,606 through 10,620 (of 22,226 total)