Insertion and Deletion by using Partition

for huge data insertion and deletion by avoiding locking you can use partition tables.

Log File Page Size

TSQL variable

DB File Extension

Counts Puzzle

How to get list of Stored Procedure

You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.