Quick Way to Rebuild SQL Server Master Database
All the system-level configuration settings and login account information of SQL server are stored in the corresponding SQL Master Database...
2018-05-29
20,592 reads
SQL Server Overview
Quick Way to Rebuild SQL Server Master Database
All the system-level configuration settings and login account information of SQL server are stored in the corresponding SQL Master Database files. It contains information about other databases that are...
2018-05-29
64 reads
Tips for Securing SQL Server Database from All Sort of Risks
Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting...
2018-05-24
1,275 reads
Tips for Securing SQL Server Database from All Sort of Risks
Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting the Server and its databases. In this section, we...
2018-05-24
1 reads
Tactics to Find Outdated Statistics in SQL Server
Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query....
2018-05-21
2,065 reads
Tactics to Find Outdated Statistics in SQL Server
Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query. SQL Server is pretty good in estimating the statistics....
2018-05-21
9 reads
Know About SQL Server Error 6401
Introduction
The ACID acronym standing for Atomicity, Consistency, Isolation, and Durability are the properties of SQL transactions. Transactions are used when...
2018-05-07
2,570 reads
Know About SQL Server Error 6401
Introduction
The ACID acronym standing for Atomicity, Consistency, Isolation, and Durability are the properties of SQL transactions. Transactions are used when the database has to be modified by using one...
2018-05-07
11 reads
A Perfect Solution to Resolve SQL Server Error 211
SQL Server Schema is basically a collection of SQL Objects that includes the tables, related columns, its entries, or other...
2018-04-30
3,919 reads
A Perfect Solution to Resolve SQL Server Error 211
SQL Server Schema is basically a collection of SQL Objects that includes the tables, related columns, its entries, or other components. Due to this, it becomes easy for a...
2018-04-30
16 reads
Blogs
Microsoft MVP 2025: Continuing the Data Platform Journey
I am honored to announce that I have been renewed as a Microsoft MVP...
What is KTLO? Keep The Lights On vs Project Work in Agile
By Rohit Garg
Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT...
The PASS Summit on Tour in Dallas
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Formatting Dates and Times: The SQL Dialect Divide
Comments posted to this topic are about the item Formatting Dates and Times: The...
Query Plan Regressions --
Comments posted to this topic are about the item Query Plan Regressions --
Question of the Day
Query Plan Regressions --
For the Question of the day, I am going to go deep, but try to be more clear, as I feel like I didn't give enough info last time, leading folks to guess the wrong answer... :) For today's question: You’re troubleshooting a performance issue on a critical stored procedure. You notice that a previously efficient query now performs a full table scan instead of an index seek. Upon investigating, you find that an NVARCHAR parameter is being compared to a VARCHAR column in the WHERE clause. What is the most likely cause of the query plan regression?
See possible answers