Viewing 15 posts - 15,106 through 15,120 (of 22,232 total)
I'm with Steve. The only way I know to make transactions smaller is to... make the transactions smaller. Break apart the data in some fashion so that you're moving 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
May 6, 2010 at 11:57 am
Steve Jones - Editor (5/6/2010)
GilaMonster (5/6/2010)
Grant Fritchey (5/6/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
May 6, 2010 at 11:24 am
tymberwyld (5/6/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
May 6, 2010 at 9:51 am
GilaMonster (5/6/2010)
Steve Jones - Editor (5/6/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
May 6, 2010 at 9:47 am
Steve Jones - Editor (5/6/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
May 6, 2010 at 9:02 am
Steve Jones - Editor (5/6/2010)
Lynn Pettis 1533
CirquedeSQLeil ...
"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
May 6, 2010 at 9:01 am
Tom Brown (5/6/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
May 6, 2010 at 8:58 am
Steve Jones - Editor (5/6/2010)
Congrats, Grant. I wonder how many of those are in this thread. Hmmmm, maybe I should do a touch of analysis 🙂
It's probably only about 500...
"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
May 6, 2010 at 8:41 am
TheSQLGuru (5/6/2010)
I will add that as a consultant in the past 3-4 years I have...
"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
May 6, 2010 at 8:13 am
Gianluca Sartori (5/6/2010)
Grant Fritchey (5/6/2010)
And by the way, just passed 8000 points. #10 to do so.Now I'll let Jason & Paul pass me.
Congrats! It's a long way to 8000...
"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
May 6, 2010 at 8:10 am
SwedishOrr (5/6/2010)
I double checked to make sure I wasn't looking at two different event classes, and both are SP:StmtCompleted.HTH
If you're seeing two SP:StmtCompleted entries, then you've got two statements that...
"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
May 6, 2010 at 8:09 am
vky3 (5/6/2010)
Hi Grant,We do have a tape backup that occurs every night and we move the tape to an off site location.
Thanks
Then, I'd say you're basically OK. You can get...
"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
May 6, 2010 at 8:08 am
And by the way, just passed 8000 points. #10 to do so.
Now I'll let Jason & Paul pass me.
"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
May 6, 2010 at 7:50 am
It's hard to tell from that, but I'd start in the usual places. Check the service in the Configuration manager and be sure that it's set to a good login....
"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
May 6, 2010 at 7:36 am
mckinnj1 (5/6/2010)
homebrew01 (5/5/2010)
The OP seems to be posting hastily without taking the time to properly explain the problem or the attempted solutions. If it's important, perhaps he/she will try harder.
Wow....
"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
May 6, 2010 at 7:34 am
Viewing 15 posts - 15,106 through 15,120 (of 22,232 total)