SqlServer-QA.net

In continuation to SQL Server - Precision Performance techniques using RML Utilities and SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose? posts here it will be a wonderful news for DBAs to hear that Microsoft Development team developed an update for the RML Utilities which now ...

As a DBA you might be aware that since SQL Server 2005 database maintenace plans have given flexibility in deploying the workflow of tasks required to make sure that your database is optimized, is regularly backed up, and is free of inconsistencies in addition to the avoiding the fragmentation on indexes with optimization tasks. This may be ...

Interesting question: how can we know the difference between a native backup and backup taken by third party tool? Say you have started newly in a enterprise wide platform and your task is to find out what methods of BACKUP and RESTORE are followed to take care of data which is a prime task for every DBA. Usage of third party tools has been ...

How can you calculate size of  an index in a database whenever a capacity planning exercise if performed? By default the size allocated for each user objects depends on the user application and on the amount of space that is created by the application for user-defined tables, global and local temporary tables, indexes, and table variables. ...

A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application is initiated and data is stored with relevant scheduled jobs and processes the ...