Viewing 15 posts - 12,406 through 12,420 (of 22,219 total)
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
Basically, I'd set up two, identical databases with the two different collations and then run a set of queries against each database, one at a time, capturing a full set...
"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 9:39 am
Does location matter? Meaning, could people work remotely? I know several people (including me) who have lower rates for remote work.
"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 7:22 am
There are just scads and scads of articles and books out there on managing log files (I know because I've added to the heap several times). It's not that hard...
"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 7:17 am
Haven't had one yet this week, but the week is young for me. Stay tuned, I'm sure to have 3-5 before Friday.
"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 7:13 am
John Mitchell-245523 (6/7/2011)
Gus is right.I think sp_delete_backuphistory is date specific, not database specific, so you may end up throwing the baby out with the bathwater if you use it.
John
It is...
"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 7:04 am
Viewing 15 posts - 12,406 through 12,420 (of 22,219 total)