Viewing 15 posts - 12,406 through 12,420 (of 22,224 total)
Gianluca Sartori (6/8/2011)
Grant Fritchey (6/8/2011)
Jim Murphy (6/8/2011)
I'm not much of a runner. Uh, at all. But 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
June 8, 2011 at 9:25 am
Jim Murphy (6/8/2011)
I'm not much of a runner. Uh, at all. But with all of this peer...
"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
June 8, 2011 at 9:04 am
That's old style error handling. Try setting up a TRY/CATCH 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
June 8, 2011 at 9:02 am
Another vote for Red Gate SQL Doc. Excellent tool, should do what you need.
Disclosure: I work for Red Gate.
"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
June 8, 2011 at 8:57 am
Don't forget to get out and Run with Steve[/url] today everyone.
"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
June 8, 2011 at 7:36 am
Can you put error handling into the script so that it deals with the error and doesn't return it to SQL Agent?
"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
June 8, 2011 at 6:10 am
You need to define blocking in this case. If you're doing reads, shared locks are taken, which will block any other process from performing updates (which includes deletes). That's independent...
"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
June 8, 2011 at 6:08 am
Express does cover the fundamentals of the SQL Server relational engine very well. You can learn querying, basic maintenance, backups and restores, tuning, pretty much all you need. If you...
"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
June 8, 2011 at 6:01 am
Instead of trying to build this yourself, I'd suggest you pick up one of the third party tools out there that are designed for doing exactly this. It'll make your...
"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
June 8, 2011 at 5:58 am
The key to reducing I/O through an index, which Gail has detailed already, are designed explicitly to reduce I/O, is to build the right indexes. Simply putting indexes on 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
June 8, 2011 at 5:56 am
Have you checked the execution plans in the morning and in the afternoon? Use the dynamic manage objects (DMO) such as sys.dm_exec_query_stats and sys.dm_exec_query_plan, to pull the plan out of...
"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
June 8, 2011 at 5:49 am
Since it's so specific, you might want to look at the Configuration Manager and see if there's an alias created on the server that might be affecting how connections 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
June 8, 2011 at 5:46 am
sql@sql (6/8/2011)
Otherwise change in join order of tables in query may solve your...
"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
June 8, 2011 at 5:16 am
GilaMonster (6/7/2011)
The client-from-hell is no more.
Yay! Need help hiding the bodies?
"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
June 7, 2011 at 12:42 pm
Jim Murphy (6/7/2011)
Grant Fritchey (6/7/2011)
WayneS (6/6/2011)
If I've read things right, you're going to the Summit? Do you know that Thursdays up there is "Kilt Day"? Grant started it... he 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
June 7, 2011 at 12:42 pm
Viewing 15 posts - 12,406 through 12,420 (of 22,224 total)