Sunday, February 12, 2012

Command Line Functionality

Is it possible to parse and/or find out the estimated execution plan of an SQL Query at command line without making use of the IDE ?

See BOL. Search the index for SET SHOWPLAN. You will find various options.

See SQLCMD for command line execution.

Combine the two and you're golden.

No comments:

Post a Comment