As we know, automatically created statistics, as can be see with
SELECT * FROM sys.Stats WHERE object_id LIKE OBJECT_ID('MyTable')
(only change 'MyTable' for something else), has name starting with _WA_Sy_.
Were you ever curious what was that _WA_ for?
I heard yesterday that it is abbreviation for WASHINGTON, where MS SQL Development Team is residing.
Published under: SQL Server Tips · · · ·
Thanks, Adam. It's really interesting. I've just used Google and found this link http://www.sqlskills.com/BLOGS/PAUL/post/How-are-auto-created-column-statistics-names-generated.aspx
It says that WA really stands for WASHINGTON
Yes it is specified here http://www.sqlskills.com/BLOGS/PAUL/post/How-are-auto-created-column-statistics-names-generated.aspx
@Olga & @Madhivanan: I made some short research, but I didn't find any confirmations or negations for that fact.
Well. I did not see Olga Medvedeva's reply when I posted mine