Viewing 15 posts - 15,196 through 15,210 (of 22,227 total)
Check the login that the scheduling service is running under. Check the owner of the job that is being run and check the security settings on the script itself. It's...
"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 3, 2010 at 6:38 pm
Steve Jones - Editor (5/3/2010)
Your ed is coming soon. Haven't had time to go over the podcast, but I'll get it sorted and out next week.
I'm actually not worried about...
"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 3, 2010 at 12:50 pm
The basics are easy:
Run the Upgrade Advisor
Fix any issues
Migrate the logins
Backup the databases on the old server
Restore the databases on the new server
Run DBCC checks (a little paranoia goes 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
May 3, 2010 at 11:57 am
Steve Jones - Editor (5/3/2010)
It does seem to be tough pulling information out of people today. The "ideal SQL Server" thread has me slightly frustrated.
Based on that thread, please run...
"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 3, 2010 at 11:55 am
Gianluca Sartori (5/3/2010)
At least, I'm not aware of any way this could happen, but I could be flat wrong.
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
May 3, 2010 at 9:01 am
GilaMonster (5/3/2010)
Grant Fritchey (5/3/2010)
GilaMonster (5/3/2010)
Grant Fritchey (5/3/2010)
Also, having four completely different queries inside the IF statement pretty much guarantees you're likely to see recompiles.
Why? SQL won't recompile when a different...
"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 3, 2010 at 8:50 am
GilaMonster (5/3/2010)
Grant Fritchey (5/3/2010)
Also, having four completely different queries inside the IF statement pretty much guarantees you're likely to see recompiles.
Why? SQL won't recompile when a different branch is taken....
"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 3, 2010 at 8:36 am
Also, having four completely different queries inside the IF statement pretty much guarantees you're likely to see recompiles. If you need to set up this kind of IF clause, then...
"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 3, 2010 at 8:24 am
Gianluca Sartori (5/3/2010)
The only thing I'm sure of is database size, that changed from...
"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 3, 2010 at 7:38 am
ankur003 (5/3/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 3, 2010 at 7:34 am
Greg Edwards-268690 (5/3/2010)
TRACEY-320982 (5/2/2010)
Thanks I will recommend upgrade to 2010 as soon as it out rather than in 5 years 🙂
I'd recommend taking a closer look at 2010 before recommending...
"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 3, 2010 at 7:30 am
Sounds like a permissions issue. That would be the main difference. But without details on exactly what error you're getting, it's hard to say beyond 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 3, 2010 at 7:26 am
Total agreement. You'll get enough of what you need in order to build out your initial system with Express. If you hit limits, mostly likely in connections, you take 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
May 3, 2010 at 7:15 am
Since this is asking for opinion...
I think NOLOCK is probably the single most dangerous hint available. It's seductive and attractive and doesn't appear to cause a single problem. But 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
May 3, 2010 at 7:14 am
Here's an article just on how to handle errors within TSQL code:
http://www.simple-talk.com/sql/t-sql-programming/sql-server-error-handling-workbench/%5B/url%5D
"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 3, 2010 at 7:07 am
Viewing 15 posts - 15,196 through 15,210 (of 22,227 total)