Data Page math : 96 + 8060 + 36 = 8192. is this correct?
I have come accross interesting puzzle yesterday on numbers 96 and 36.
Everyone knows that header size is 96 and maximum...
2012-02-09
1,697 reads
I have come accross interesting puzzle yesterday on numbers 96 and 36.
Everyone knows that header size is 96 and maximum...
2012-02-09
1,697 reads
I have come accross below link while checking options to find top painful mirroring enabled databases.
Looks like there is no single...
2012-01-31
4,571 reads
As a learner I have got chance to know lots of free and precious SQL Server resources in last few...
2011-11-05
2,481 reads
Whoever starts their career in any domain/technology, initially they will have two faces.
First face of an employee is to take...
2011-10-31
1,731 reads
Those who are fan of Glenn Berry’s DMV queries would have come across below query at-least once.
-- Hardware information from...
2011-10-30
11,447 reads
One of Our production database is used by lots of Reporting users. Mirroring is enabled on this database. But no one is...
2011-09-19
6,819 reads
“I love SQL Server. SQL Server has given me good career, salaray and life”
“Be loyal and dedicated with SQL Server....
2011-09-19
2,853 reads
As part of my MCM preparation (Have to study aggressively at least for next 2 years) , I have downloaded almost all readiness...
2011-09-05
1,486 reads
My one week long search to identify active SQL Server community in Chennai ended last Sunday.
Chennai SQL Server User Group...
2011-08-07
2,013 reads
It's near to 6 months since I started blogging in SSC and started giving sessions for my Organization on Internal and tuning topics.
While...
2011-07-26
886 reads
It’s been forgotten about and neglected for few years but I’ve decided to dust...
I am honored to announce that I have been renewed as a Microsoft MVP...
By Rohit Garg
🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Navigating Multi Platform Realities in...
I have tried a number of times to export and then import my SSMS...
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