Category: Articles
-
Query Plans & Plan guides
Introduction: Most developer DBAs have tough time tuning TSQL part of the database and application. And most people leave in middle of it either frustrated or cant go beyond that. Here is a simple look on how to use the query hints and plan guides to tune the TSQL part of your database and application.
-
Mirrored Backups
Mirrored backup is a feature available in SQL Server 2005 Enterprise Edition and Development Edition. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations.
-
How to Recover SA password when you forget it – SQL 2005
What to do if you forgot SA password in SQL Server 2005? In general if you forgot SA password or if the SA account is disabled these are the options to login into SQL Server 2005 and reset or enable SA.
-
Database Management Views & Functions – SQL 2005
DMV’s are system views and its a new feature started SQL server 2005 with nearly 80 DMVs. DMV’s are system view that surface the internal counters of the database engine help present an easily comprehendible dashboard of the database engine performance that can be used to monitor the health of a server instance, diagnose problems,…
-
List of DMVs & DMFs available in SQL Server 2005
I’ve listed down all the DMV’s that are related to SQL server 2005