Viewing 15 posts - 14,716 through 14,730 (of 22,219 total)
Jeff Moden (7/7/2010)
Tom.Thomson (7/7/2010)
bteraberry (7/7/2010)
The Dixie Flatline (7/7/2010)
You're not going to explain this in a such a way as to make him happy.I didn't believe you. Now I do.
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 8, 2010 at 5:56 am
I'm completely missing the point of the questioner over here. Can someone else give them a hand maybe?
"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 1:21 pm
For a low-end system, not lots of server or lots of requirements for monitoring & alerting, you really can't go wrong with Red Gate SQL Alert. I do still think...
"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 12:36 pm
a.borgeld (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 12:22 pm
Yep, that's the way I thought it worked 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 7, 2010 at 12:13 pm
oliver.morris (7/7/2010)
I have a scalar function that works ok, it's just that its slow. I have indexed the geom column but it can take upto 40 mins to run on...
"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 12:05 pm
Pretty much, you can all this with SQL Server. SQL Agent can generate emails when jobs fail and you can generate emails when you get errors. The only trick would...
"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 11:56 am
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
Viewing 15 posts - 14,716 through 14,730 (of 22,219 total)