Viewing 15 posts - 12,406 through 12,420 (of 22,233 total)
GilaMonster (6/9/2011)
Stefan Krzywicki (6/8/2011)
Kit G (6/8/2011)
"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 9, 2011 at 6:26 am
Stefan Krzywicki (6/8/2011)
Kit G (6/8/2011)
Grant Fritchey (6/8/2011)
I hate to tell you this, but I wear sandals, sneakers & boots with kilts, but...
"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 3:35 pm
andykr-773587 (6/8/2011)
Thanks for the input though, I will report back if I find anything.
(When will you be out our way again?...
"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 3:33 pm
Itzik's books are some of the first I recommend. After that, get a copy of Kalen Delaney's book SQL Server Internals. Since you're just getting going, you might want 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
June 8, 2011 at 1:59 pm
I don't think you can do this with Profiler. You can do it using Extended Events though.
"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 1:57 pm
In general, I'm always wary to shrink log files until I'm sure that I've got them under control so I know what size they really ought to be. You don'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
June 8, 2011 at 1:53 pm
Finished my 3 mile contribution gotta go log it.
I hate to tell you this, but I wear sandals, sneakers & boots with kilts, but I seldom wear long socks 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 12:52 pm
Yes, it could be the connection, but then I'd expect that to affect the query on both sides.... although, maybe not. Maybe only on the hop. I'm not sure.
"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 12:50 pm
That is not one I've run into before. I'd check to see if there are differences between the databases. I'd focus on the collation and the ANSI connection settings. Something...
"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:53 am
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
Viewing 15 posts - 12,406 through 12,420 (of 22,233 total)