Viewing 15 posts - 14,731 through 14,745 (of 22,227 total)
The basic commands will work. As you get into more complicated scenarios, some things will work and some won't.
"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 7, 2010 at 10:30 am
doobya (7/7/2010)
Grant Fritchey (7/7/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
July 7, 2010 at 9:19 am
You're dealing with a fundamental change in behavior. If you're raising errors inside the procedure, the errors are recognized by the TRY/CATCH construct, as designed. That's how it's supposed to...
"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 7, 2010 at 7:55 am
Sounds like the database might be in FULL recovery mode but you don't have log backups running, or possibly, the log backups are not running frequently enough.
"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 7, 2010 at 6:33 am
But if you have pre-existing procs with established and functioning logic, why are you changing them to use TRY/CATCH at all? I would only suggest rewriting them as needed and...
"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 7, 2010 at 6:31 am
There are limitations. One of the first you'll need to take into account is the fact that the transactions are running through DTC as distributed transactions. That alone limits 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 7, 2010 at 6:28 am
muzahm (7/7/2010)
Is it a good idea to blindly apply all the indexes suggested by dm_db_missing_index_details.
To put it in other way, does dm_db_missing_index_details suggest you all the indexes that you database...
"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 7, 2010 at 6:20 am
WayneS (7/6/2010)
Jeff Moden (7/6/2010)
CirquedeSQLeil (7/6/2010)
WayneS (7/5/2010)
I've...
"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 7, 2010 at 5:16 am
HardCoder (7/6/2010)
Gianluca Sartori (7/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
July 6, 2010 at 6:39 am
I've only used it in testing, like yourself. I've found that it doesn't grow any worse than other monitoring software that we use (Idera & Microsoft Operations Manager). It just...
"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 6, 2010 at 6:37 am
Gail's already pointed you to the best resource, Books Online, but the second best resource on the general topic of Trace, Trace Events and the Profiler is Brad Magehee'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 6, 2010 at 6:27 am
derkin (7/6/2010)
Perfect, worked like wonder.Thanks. 🙂
Which of the three answers helped? Just asking so someone else finding this thread on a search knows how to solve their problem too.
"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 6, 2010 at 5:54 am
WayneS (7/5/2010)
I've been contemplating making 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 6, 2010 at 5:51 am
GilaMonster (7/3/2010)
I've never done anything longer than a half-day training session. I'd be very nervous submitting for a full-day precon.
I've done multi-day training sessions... with secretary's & other non-technical people....
"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 3, 2010 at 8:25 am
Steve, I will be submitting an abstract for a pre-con at the Spring PASS event.
"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 4:44 pm
Viewing 15 posts - 14,731 through 14,745 (of 22,227 total)