Monthly Archives: March 2016

SQL Execution plan deep dive (05-Sort)

Note: This blog is continuation to earlier blog: SQL Execution plan deep dive (04-Spool) In this blog we will see how sort impacts the performance. Fundamentally sorting is used across most of execution plans and it works good with small … Continue reading

Posted in Execution Plan, SQL | Tagged , , , | Leave a comment

SQL Execution plan deep dive (04-Spool)

Note: This blog is continuation to earlier 3 blogs 1.       SQL Execution plan deep dive (01-Basics I) 2.       SQL Execution plan deep dive (02-Basics II) 3.       SQL Execution plan deep dive (03-Scan, Key Lookup) In simple terms spools are like storing the … Continue reading

Posted in Execution Plan, Performance, Productivity, SQL, Uncategorized | Tagged , , , | Leave a comment

Biometric (Fingerprint) login into HP Windows 10 Laptop started working again :)

I had been struggling to fix it for a long time but today I am able to fix it  Simple, all you need to do is download and install HP Client Security Manager @ http://h20564.www2.hp.com/hpsc/swd/public/detail?sp4ts.oid=6893667&swItemId=vc_158160_1&swEnvOid=4158. Once you install HP … Continue reading

Posted in Productivity, Uncategorized, Windows Server | Tagged , , , | Leave a comment

SQL Execution plan deep dive (03-Scan, Key Lookup)

Note: This blog is continuation to earlier 2 blogs 1.       SQL Execution plan deep dive (01-Basics I) 2.       SQL Execution plan deep dive (02-Basics II) In the next few blogs, I will cover following topics which can be analyzed during … Continue reading

Posted in Execution Plan, knowledge, Performance, Productivity, SQL, SQL Server, Uncategorized | Tagged , , , , , | 1 Comment