Frage im Vorstellungsgespräch bei HostBooks
How can we increase the performance of a SQL query in the SQL server?
Antwort im Vorstellungsgespräch
Anonym
9. Feb. 2019
Avoid using GROUP BY, ORDER BY, and DISTINCT. Use SET NOCOUNT ON, Do not use the * operator in your SELECT statements. Instead, use column names. Always prefix object names (i.e. table name, stored procedure name, etc.) with its owner/schema name.