Viewing 15 posts - 12,391 through 12,405 (of 22,219 total)
GilaMonster (6/9/2011)
Is this person irritating anyone else, or am I just in low-tolerance mode at the moment?
Some of the posts seem... less than original.
"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:27 am
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
Viewing 15 posts - 12,391 through 12,405 (of 22,219 total)