Viewing 15 posts - 4,696 through 4,710 (of 22,227 total)
Ed Wagner (6/2/2016)
jasona.work (6/2/2016)
Happy National Leave the Office Early Day!!![/url]So, who's going to celebrate this day today?
😀
I must admit that it looks like as good a reason as any, 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 2, 2016 at 8:39 am
There are a lot of commands in SSMS that use server level calls to work. So, they don't work well with Azure. The basics are there, but not the more...
"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 1, 2016 at 8:25 pm
There is no easy way to do this. Each report can be an ad hoc T-SQL statement, a stored procedure or a view. You can at least document the dependencies...
"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 1, 2016 at 4:28 pm
That command isn't one I would have used all that much in the past which might explain why I had to look it up. If you look at the documentation...
"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 1, 2016 at 3:36 pm
yb751 (6/1/2016)
Grant Fritchey (6/1/2016)
yb751 (6/1/2016)
Steve Jones - SSC Editor (6/1/2016)
yb751 (6/1/2016)
The purchase of some Red Gate tools finally got approved by my boss. 😀
Feels like I've been...
"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 1, 2016 at 3:17 pm
Eric M Russell (6/1/2016)
Grant Fritchey (6/1/2016)
Eric M Russell (6/1/2016)
"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 1, 2016 at 3:01 pm
Eric M Russell (6/1/2016)
"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 1, 2016 at 1:15 pm
And if you're going to apply them as is (and please read Kevin's warnings, they're very accurate and if anything not dire enough), the keys consist of the equality and...
"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 1, 2016 at 12:41 pm
Jacob Wilkins (6/1/2016)
Starting 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
June 1, 2016 at 12:30 pm
jasona.work (6/1/2016)
When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took to open 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
June 1, 2016 at 10:42 am
Jacob Wilkins (6/1/2016)
Starting 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
June 1, 2016 at 10:30 am
With one being estimated and one being actual, I'm inclined to say these plans are identical, but I'd want to be sure before I went there. Frankly, 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 1, 2016 at 9:07 am
yb751 (6/1/2016)
Steve Jones - SSC Editor (6/1/2016)
yb751 (6/1/2016)
The purchase of some Red Gate tools finally got approved by my boss. 😀
Feels like I've been begging forever. ...
"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 1, 2016 at 8:25 am
No. That's why it's telling you to install Visual Studio.
"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 1, 2016 at 6:00 am
You could probably treat it like versioned data and only retrieve the latest row of each type. I have example queries in this article [/url]on how to do this.
"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 1, 2016 at 5:33 am
Viewing 15 posts - 4,696 through 4,710 (of 22,227 total)