Viewing 15 posts - 3,901 through 3,915 (of 22,211 total)
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...
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...
April 12, 2017 at 7:23 am
Damn Hugo.
Feel better man.
You can be off book duty. I approve it.
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.
April 11, 2017 at 4:18 pm
You will need the SQL Server PowerShell module.
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...
April 11, 2017 at 12:06 pm
April 11, 2017 at 7:04 am
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...
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...
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...
April 11, 2017 at 5:19 am
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:...
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...
April 10, 2017 at 8:00 am
Viewing 15 posts - 3,901 through 3,915 (of 22,211 total)