MSSQL

MS SQL Server DBA Interview Questions and Answers For Experienced

MS SQL Server DBA Interview Questions and Answers For Experienced

I thought of doing one session for SQL Server DBA interview Questions and Answers and share with you. These questions are of different levels and check your overall understanding of SQL Server database administration and approach towards solving issues. Interview typically lasts for 20-40 minutes, nobody can find everything about candidate however these questions and …

MS SQL Server DBA Interview Questions and Answers For Experienced Read More »

Thought of Those Queries Where No Index Recommendation from SQL Server? Still Helps in Big Way!

Thought of Those Queries Where No Index Recommendation from SQL Server? Still Helps in Big Way!

As you know Index recommendation is very handy when you execute a query and check the execution plan and SQL Servers suggest to create an index and this much gain will be there in query performance, Its not always correct however very helpful. All the suggestions shouldn’t be implemented neither it should be ignored completely. …

Thought of Those Queries Where No Index Recommendation from SQL Server? Still Helps in Big Way! Read More »

Impact of SSD Disk over HDD on MSSQL Performance

Impact of SSD Disk over HDD on MSSQL Performance

Recently our server where MSSQL Server database resides was upgraded and SSD disk was installed. Let us understand the performance improvement on different processes of SQL Server where it had positive impact and where it didn’t have much. Sudden Improvement was observed at below Proesses: Backup of database Maintenance Job Report Generation Database Consistency CHECKDB …

Impact of SSD Disk over HDD on MSSQL Performance Read More »

What If Mismatched Instance Name & Port - Which One Takes Precedence

What If Mismatched Instance Name & Port – Which One Takes Precedence

This scenario could be faced by someone who is having multiple instances running on the same server. Mostly we try to have dedicated server for Production environment however for Test environments(SIT, UAT, Dev) – Based on criticality of application, we tend to install multiple instances of SQL Server on the same server. As you are …

What If Mismatched Instance Name & Port – Which One Takes Precedence Read More »

MAXDOP and CTP Value - Should You Change Them In Working Hour At Production Server

MAXDOP and CTP Value – Should You Change Them In Working Hour At Production Server

You would have seen number of articles describing the importance of MAXDOP(MAXimum Degree Of Parallelism) and why should it be changed and shouldn’t be left to its default value, which is set at 0 after installation of SQL Server – I have covered them in one of my earlier post – Why MAXDOP shouldn’t be …

MAXDOP and CTP Value – Should You Change Them In Working Hour At Production Server Read More »