Viewing 15 posts - 46 through 60 (of 136 total)
The meat of your script, sys.dm_exec_query_stats, gives you performance data for cached query plans. The results are fairly straightforward:
text: this is the text of the batch identified by...
December 11, 2017 at 11:13 am
Sure thing.
Here's Microsoft's extract page and example... I don't actually like this one, but it is what it is.
SQLStudies.com actually just posted this yesterday.
October 26, 2017 at 6:42 pm
Just schema?
You can extract a dacpac of your database without much powershell code or from the command line. Either of those methods can be set into a SQL...
October 26, 2017 at 4:05 pm
Something like this will generate all the create statements...
SELECT 'CREATE TABLE ['+name+'].[YourTable]
(
ID INT
)
GO'
FROM sys.schemas where principal_id = 1
Then you'd...
October 26, 2017 at 11:15 am
October 26, 2017 at 11:08 am
Tom_Hogan - Thursday, October 26, 2017 7:14 AMI would imagine you could over complicate things in either language.
Absolutely!
October 26, 2017 at 7:43 am
Totally agree. I like Powershell but not nearly as much as I used to...
October 25, 2017 at 10:35 am
For SQL Server, most things use SQLPS, some starting to use SQLServer. It gets...
October 25, 2017 at 8:10 am
d_martins - Wednesday, October 25, 2017 4:26 AMI'm looking toretrieve 1 row per ID.
Thanks
Right now you've been given two guesses as to...
October 25, 2017 at 7:16 am
October 25, 2017 at 4:01 am
Viewing 15 posts - 46 through 60 (of 136 total)