Timeline for How to script statistics in Sql Server? (using T-SQL)
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 3, 2016 at 11:48 | comment | added | Marcello Miorelli | I have changed he script now. I also like this script because it does not use the DBCC SHOW_STATISTICS | |
| Oct 3, 2016 at 11:47 | history | edited | Marcello Miorelli | CC BY-SA 3.0 |
I have changed my own script to reflect the suggestions on the comments below.
|
| Sep 30, 2016 at 15:44 | comment | added | Solomon Rutzky |
Interesting. Some notes: 1) You can replace OBJECT_NAME(s.[object_id]) with obj.[name] since you are already joining to the sys.objects catalog view. 2) For the sake of completeness (for others), you should include the filter_definition column so that this script properly handles filtered statistics :-).
|
|
| Sep 30, 2016 at 14:29 | history | answered | Marcello Miorelli | CC BY-SA 3.0 |