id |
ftwikibooks:enwikibooks:21528:118375
|
record_format |
openpolar
|
spelling |
ftwikibooks:enwikibooks:21528:118375 2024-03-31T07:52:28+00:00 Wikibooks: Microsoft SQL Server/Best Practices https://en.wikibooks.org/wiki/Microsoft_SQL_Server/Best_Practices eng eng Book ftwikibooks 2024-03-02T17:31:11Z wikipedia Query optimization Always qualify objects by owner.= Use query with (nolock) when you don t require high transactional consistency. Do not use GOTO. Avoid CURSOR use because it s significantly slower. If necessary always declare the correct type of cursor (FAST FORWARD). Avoid SELECT INTO for populating temp tables. Create the table then use INSERT SELECT. Always use ANSI join syntax. Always check for object existence. Use SCOPE IDENTITY() instead of @@IDENTITY. Always check @@TRANCOUNT and commit/rollback as necessary. Order w Data manipulation language DML to avoid deadlocks. Always check @@ERROR and @@ROWCOUNT by assigning to a variable. Always check sp return values. Do not create cross database dependencies. Avoid table value UDF – performance problems. Avoid dynamic SQL – if necessary use sp executesql over EXEC. Avoid using NULL values. When there are only two values ISNULL is more efficient than COALESCE. Always specify columns try to avoid SELECT . Exceptions include these two cases WHERE EXISTS (SELECT .) and aggregate functions. BookCat Book DML WikiBooks - Open-content textbooks
|
institution |
Open Polar
|
collection |
WikiBooks - Open-content textbooks
|
op_collection_id |
ftwikibooks
|
language |
English
|
description |
wikipedia Query optimization Always qualify objects by owner.= Use query with (nolock) when you don t require high transactional consistency. Do not use GOTO. Avoid CURSOR use because it s significantly slower. If necessary always declare the correct type of cursor (FAST FORWARD). Avoid SELECT INTO for populating temp tables. Create the table then use INSERT SELECT. Always use ANSI join syntax. Always check for object existence. Use SCOPE IDENTITY() instead of @@IDENTITY. Always check @@TRANCOUNT and commit/rollback as necessary. Order w Data manipulation language DML to avoid deadlocks. Always check @@ERROR and @@ROWCOUNT by assigning to a variable. Always check sp return values. Do not create cross database dependencies. Avoid table value UDF – performance problems. Avoid dynamic SQL – if necessary use sp executesql over EXEC. Avoid using NULL values. When there are only two values ISNULL is more efficient than COALESCE. Always specify columns try to avoid SELECT . Exceptions include these two cases WHERE EXISTS (SELECT .) and aggregate functions. BookCat
|
format |
Book
|
title |
Wikibooks: Microsoft SQL Server/Best Practices
|
spellingShingle |
Wikibooks: Microsoft SQL Server/Best Practices
|
title_short |
Wikibooks: Microsoft SQL Server/Best Practices
|
title_full |
Wikibooks: Microsoft SQL Server/Best Practices
|
title_fullStr |
Wikibooks: Microsoft SQL Server/Best Practices
|
title_full_unstemmed |
Wikibooks: Microsoft SQL Server/Best Practices
|
title_sort |
wikibooks: microsoft sql server/best practices
|
url |
https://en.wikibooks.org/wiki/Microsoft_SQL_Server/Best_Practices
|
genre |
DML
|
genre_facet |
DML
|
_version_ |
1795031621310611456
|