Pavan K Srirangam
- Auto Fix orphan users on all Databases
- Database Mirroring Failover- all databases in a instance
- How to Delete Millions of Rows From SQL Server Table ?
- SQL server updates or service pack hung or failed to install!!
- Finding top 10 large tables in each database in an instance of SQL server
- Always – ON Availability group Alerts
- All about SQL server Statistics in simple words:
- What is Parameter Sniffing in simple words?
- SQL Server 2012- Sample Databases
- How to bring a database online which is in restoring mode ?
Top Posts- Most Read
- Script to find the fragmentation level of specific table and its indexes in SQL Server
- HOW TO CHECK IF A USER ACCOUNT IS LOCKED? IF LOCKED HOW TO UNLOCK IT?
- Track DML Changes Using after Trigger for Update, Delete and Insert rows- Capture Changed data rows using T-sql
- Activity monitor, Script to find Head blocker- SQL Server 2005, 2008 and later
- How to run a SQL Query on list of servers and save output to excel using power shell?
- Compare Two Tables Using T-SQL or Command Line Utility (tablediff.exe)
- How to transfer logins and passwords between instances of SQL Server?
- How to delete multiple logins from SQL Server (Sp_DropLogins )
- Database Comparision- Schema Compare, Data Compare,synchronization and validation
- Script to find Unused Indexes- SQL Server
- 99,693 hits