Viewing 15 posts - 3,916 through 3,930 (of 22,227 total)
"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
April 12, 2017 at 8:00 am
I get that there isn't a table, but the data is in a format that can be moved to a table and then you can do what Thomas is suggesting. 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
April 12, 2017 at 7:36 am
No.You shouldn't have to install SQL Server. You just need the PowerShell module. If this ran successfully, it should download that module for you. Here's Microsoft documentation on...
"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
April 12, 2017 at 7:23 am
Damn Hugo.
Feel better man.
You can be off book duty. I approve 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
April 11, 2017 at 4:19 pm
Use the get-module command. Same thing when you start using Azure, you'll need the AzureRM module.
"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
April 11, 2017 at 4:18 pm
You will need the SQL Server PowerShell module.
"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
April 11, 2017 at 12:35 pm
Best way would be to set up extended events and capture the recompile event. You can easily filter it down to particular databases or even particular procedures. You can also...
"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
April 11, 2017 at 12:06 pm
"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
April 11, 2017 at 7:04 am
"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
April 11, 2017 at 6:05 am
For any given ID value, how many rows are returning? Even for a 500,000 row table, presumably a given ID value has what, 3-5 rows? 20? If you have a nonclustered index...
"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
April 11, 2017 at 5:56 am
On 2012 & better systems, it's a good idea to start looking to extended events for this type of info. There's a system_health extended event that runs, similar to 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
April 11, 2017 at 5:44 am
Gianluca already answered the question better than I would.
It's down to having a rock solid guarantee of partition elimination. So often we hear that, oh sure, they'll always filter...
"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
April 11, 2017 at 5:19 am
"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
April 10, 2017 at 9:00 am
If they are having trouble managing the logs, log files and log backups, regardless of the fact that Redgate Software is being used to do the backups & restores (DISCLOSURE:...
"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
April 10, 2017 at 8:04 am
Partitioning of data is meant to be a management tool, not a query performance tuning tool. It is quite rare to get performance enhancements out of partitioned data. You have...
"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
April 10, 2017 at 8:00 am
Viewing 15 posts - 3,916 through 3,930 (of 22,227 total)