Viewing 15 posts - 10,606 through 10,620 (of 22,219 total)
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
It depends on two things, neither one database size, transactions in transit and your connection speed. So, no, you should see reasonably fast transitions depending on what's going on with...
"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:10 am
The signal wait is just time waiting on the processor. It's an indication that for any given type of wait, you may, depending on what percentage the signal wait takes...
"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:06 am
Probably should be moved to the "Anything that is not about SSC" forum, but that's Steve's call.
I was drafted/volunteered. I was working for a dot com startup as a developer....
"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:03 am
Also remember that recompile might play a factor. It's reduced or eliminated with table variables, but it's something you'll have to deal with when using temporary tables. Remember, there are...
"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 4:58 am
Not much to add. I'd start with Gail's articles. Once you're going, my books can help. Also, performance issues can be from causes other than queries (although that's near 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
July 20, 2012 at 4:56 am
Viewing 15 posts - 10,606 through 10,620 (of 22,219 total)