Build keyset pagination with a matching index, unique tie breaker, next and previous queries, and a fair deep-page comparison with OFFSET.
ASCII Versus UNICODE: Inspect the First Character
ASCII versus UNICODE asks different representation questions. Compare a first UTF-8 byte with a code point while preserving the complete input.
Explaining a Query Plan to a Developer
Explaining a query plan starts with the costly work, checks estimates against actual rows, and turns findings into a clear code decision.
Finding Unused Indexes
Finding unused indexes requires a measured window, SQL Server usage counters, and a safe removal test before an index earns a drop decision.
SQLAuthority News – First Birthday of Blog – 365 Post in One Year
Today is the first birthday of this blog: 365 posts in one year, one a day. Thank you to my readers, my family and SQL Server Magazine.
SQL SERVER – Importance of Master Database for SQL Server Startup
I have received following questions. I will list all the questions here and answer them together.
What is the purpose of Master database?
SQL SERVER – Business Intelligence (BI) Basic Terms Explanation
Business Intelligence basic terms explained in plain words: BI, data warehouse, data mart, cube and more, so the BI vocabulary is easier to follow.