I hate dynamic querys as they are not optimized and a query plan cannot be cached…. Example: Sql = some dyanamic sql string built via if logic… Exec(sql) – will not cache an query execution plan. In MS Sql sp_executesql caches query plans – very cool… Really though, try to avoid them if possible…. […]
Node.js Driver for SQL Server Use Node.js to query an Azure SQL database Painless Microsoft SQL Server with Node.js and seriate – June 8, 2015 by David Neal
Query to determine needed indexes.