Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table.
SQL SERVER – Fix : Error 8101 An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON
Error 8101 appears when you insert an explicit value into an identity column. Use a column list and SET IDENTITY_INSERT ON before the insert, then turn it OFF.
SQL SERVER – Stored Procedure – Clean Cache and Clean Buffer
DBCC FREEPROCCACHE will invalidate all stored procedure plans that the optimizer has cached in memory. Let us learn how to clean cache.
SQL SERVER – 2005 Security Best Practices – Operational and Administrative Tasks
A Microsoft white paper on SQL Server 2005 Security best practices for the operational and administrative tasks that lead to a more secure system.
SQL SERVER – Restore Database Backup using SQL Script (T-SQL)
Restore Database backups with a T-SQL script: read the logical file names with RESTORE FILELISTONLY, set single user mode, then run RESTORE WITH MOVE.
SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure
A quick Query Analyzer shortcut: map sp_helptext to a key, select any SP name and display the text of Stored Procedure right in the result window.
SQL SERVER – Simple Cursor to Select Tables in Database with Static Prefix and Date Created
A simple cursor to select tables in a database by a static prefix like b_ or delete_ and by date created, so you can drop, print or index old tables.