Viewing 15 posts - 3,901 through 3,915 (of 22,219 total)
It's likely to be WILDLY inaccurate, but you can also query the sys.dm_exec_query_stats to see if there's mention of the database in any of the queries that are currently in...
"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 17, 2017 at 6:39 am
Sorry, I've been away from the keyboard. Looks like Jeff has nailed it. Great advice, especially on the view calling a view thing. That seriously over complicates things and leads...
"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 15, 2017 at 4:27 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 14, 2017 at 5:32 am
Thanks for posting the solution that worked for you. Glad it all worked out too.
"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 13, 2017 at 6:43 am
John Mitchell-245523 - Thursday, April 13, 2017 3:44 AM...You can write a PowerShell script...
This.
And do it using the backup & restore mechanisms...
"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 13, 2017 at 5:51 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 13, 2017 at 5:48 am
Folks,
I have inherited a table with 80K-100K records. Mostly, patient demographic data so, the columns...
"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 13, 2017 at 5:45 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 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
Viewing 15 posts - 3,901 through 3,915 (of 22,219 total)