Viewing 15 posts - 7,381 through 7,395 (of 22,219 total)
That's one piece of functionality that didn't make the transition into the GUI for extended events. You just can't do it.
"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
October 15, 2014 at 4:45 am
Changes to a procedure will mark it for recompile if a plan for that proc exists in cache. You can't get the old code.
"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
October 14, 2014 at 11:27 am
There are a number of tools that allow you to mount an HTML connection as a drive, so you don't even have to use the Microsoft tool if 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
October 14, 2014 at 11:25 am
I also work for Red Gate. You can throw my opinion away as appropriate.
I'd also suggest looking at SQL Source Control to get your database into source control as 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
October 14, 2014 at 11:24 am
I've never seen a book just on Management Studio. Most of the books are around doing things within SQL Server Management Studio and then, by extension, teach it. For an...
"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
October 14, 2014 at 10:30 am
UDBA (10/13/2014)
"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
October 14, 2014 at 5:01 am
Jack Corbett (10/13/2014)
Grant Fritchey (10/10/2014)
"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
October 14, 2014 at 4:59 am
Not a problem. Happy to help out.
"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
October 10, 2014 at 4:17 pm
Estimated 20, Actual 861K.... Uhm, I'm thinking a seek is absolutely a bad thing for this query to be running. Are we looking at a bad parameter sniffing? Really bad...
"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
October 10, 2014 at 4:14 pm
You might want to look into external management of this type of long running distributed transaction. The BizTalk server[/url] is build around managing this sort of thing..
"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
October 10, 2014 at 4:09 pm
Sure thing. I've got a video up here of deadlock information in SQL Monitor.
"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
October 10, 2014 at 4:06 pm
Thanks for walking through that. I kept meaning to get to it, but didn't have the time.
"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
October 10, 2014 at 3:50 pm
You might try SQL Search from Red Gate[/url].
And before anyone freaks, it's completely free.
"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
October 10, 2014 at 10:22 am
RUN AS is a secondary set of permissions you'd need as well. Security is fun.
"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
October 10, 2014 at 7:52 am
With the huge variety of things going on within SQL Server, I've no doubt there are places or instances where you'll see faster performance. But they're going to be 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
October 10, 2014 at 6:25 am
Viewing 15 posts - 7,381 through 7,395 (of 22,219 total)