|
No indexes, excess recompilations of stored procedures.....
|
|
We shouldn't allow input from users during a transaction, we shouldn't open transactions while browsing through data...
|
|
SQL Server caches the plan of execution of query or stored procedure which it uses in subsequent call.....
|
|
Database B-trees....
|
|
Database Table Scan and Index Scan.....
|
|
Describe FillFactor concept in indexes....
|
|
Database index statistics.....
|
|
Database fragmentation....
|
|
Nested Join, Hash Join, and Merge Join in SQL Query Plan.....
|
