MS SQL Scripts...

• Get table row count for all tables in a database
• Queriestaking longest elapsed time
• Queries consuming most I/O
• To find how much % Backup completed
• Sample code to trace locks
• Script for monitor blocking in prod server
• T-SQL Query to find currently running jobs
• To get Mapped Logins & User Info 
• The Query fetches the Running jobs and calculates the time of duration of execution.
• Script for Auto alert SQL Agent jobs when they are enabled or disabled
• Script to extract DB Mail Configuration details ( Profiles & Accounts) in a particular SQL Server Instance
• Find Primary Keys and Columns Used in SQL Server
• Get the domain name that your SQL Server machine.
• Check If Auto Update Statistics Is Enabled By Using DATABASEPROPERTY
• Which Service Pack Is Installed On My SQL Server
• To get all the columns in the database which allow NULLS
• List all the statistics with their last updated date in a database
• List All Tables Without An Index In Your SQL Server Database
• List all empty tables in your SQL Server database
• List all SQL Agent jobs and the owner of those jobs
• List all the databases with state.
• Create Stored Procedures That Run At SQL Server Startup
• Get restore dates for all databases
• Get last backup dates for all databases
• Display the 50 most used stored procedures in SQL Server
• Display stored procedures with the highest average CPU time in SQL Server
• Getting your Buffer cache hit ratio in SQL Server 2005 and up
• Getting your Page Life Expectancy in SQL Server 2005 and up
• When did DBCC CHECKDB last run to completion?
• Script to List Currently Executing Queries
• Missing Index Script
• Top 10 T-SQL SQL Server DBA Should Know
• Backup/Restore progress in percentage
•