Through Below query you are able to find out index fragmentation in SQL Server databases:- select avg_fragmentation_in_percent,OBJECT_Name(object_id), * from
Continue readingCategory: SQL Server -DBA
SQL Server -DBA, SQL Server Services, who dropped or altered tables,procedures or databases in SQL Server, What in SQL Server
How can you track DDL Changes in SQL Server Databases?
Recently i have faced one scenario where one of our developers had changed one SP because of that application has
Continue readingHow to attach database without LDF file in SQL Server?
There can be a situation where you don’t have full database backup and you have corrupted your ldf file due to power
Continue readingHow to recover query files in SQL Server Management Studio after crashes?
If SQL Server Management Studio (SSMS) crashes for any reason at any time, then there is a chance that you
Continue readingHow To Identify Version of SQL Server from Backup File
Today, one of my colleague asked me that how can we find the sql version from backup file? then i
Continue readingPerformance Tunning:- Find Index fragmentation in SQL Server Databases
The following script provide the details of the name of each index, the name and schema of the table for
Continue readingWhat action plan should be taken if SQL Server is not responding?
you might be face this situation in past, you tried to connect the SQL Server but SQL Server is not
Continue readingHow can you start SQL Server database Instance in different modes?
We can start SQL Server in different modes which are follows:- Single User Mode (-m) DAC (-A) Emergency Mode
Continue readingPerformance Tunning :- Find I/O Usage Per Databases in SQL Server
Through Below Script you are able to identify the I/O utilization By per databases in your SQL Server.The information returned
Continue reading