Author Archives: uday arumilli

SQL Server Performance Tuning using Filtered Covering Index

SQL Server Performance Tuning using Filtered Covering Index takes you through a simple scenario where filtered indexes are helpful to improve the performance of frequently used queries. Before starting, I assume that you know “WHAT” a filtered index is or … Continue reading

Posted in Performance Tuning, SQL Development | Tagged | 1 Comment

Clustered Index On UniqueIdentifier Column

Hello all, It’s been a year since we posted a blog. It’s been the busiest year of my life. However, we strongly believe that learning is a journey and it should be a continuing process. Coming to the point, recently … Continue reading

Posted in Database Design, Performance Tuning, SQL Development | Tagged , , , , | 2 Comments

Latest SQL DBA Interview Questions and Answers

The post Latest SQL DBA Interview Questions and Answers takes you through the latest SQL DBA interview experiences shared by blog followers. You can also share your interview experience and we can provide you the answers: Q. Can we perform … Continue reading

Posted in Interview Q&A, SQL Server DBA | Tagged , , , , , , | 1 Comment