Tag Archives: Interview questions

A discussion between a CxO and a senior Data Architect Part 1

. Links to other parts A discussion between a CxO and a senior Data Architect Part 2 A discussion between a CxO and a senior Data Architect Part 3 A discussion between a CxO and a senior Data Architect Part … Continue reading

Posted in Interview Q&A | Tagged , , , , , , , , | 2 Comments

Covering Index Performance Impact in SQL Server

Covering Index Performance Impact in SQL Server This post can help you to understand the “Covering Index Performance Impact in SQL Server”. First we’ll understand the covering index basics and we’ll see the performance impact using T-SQL code. Q. What … Continue reading

Posted in Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , | 2 Comments

Parameter Sniffing Performance Impact in SQL Server

Parameter Sniffing Performance Impact in SQL Server This post can help you in understanding the “Parameter Sniffing Performance Impact in SQL Server”. Parameter sniffing is one of the major factors that impact the performance in SQL Server. Every SQL DBA … Continue reading

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