Context This blog discusses a method that can be applied for doing the modification of default constraints on multiple fields within a database which currently points to one value Scenario Recently in one of my projects there was a need…
IIf function T-SQL vs SSRS Behavioral Difference
This blog explains on the behavioral difference of IIf function between Reporting Services and in Transact SQL.IIf function was a new addition in SQL Server 2012 which provides a simplified way to implement conditionally logic. Though we have a similar…
Know Your DMVs : sys.dm_exec_procedure_stats
Context The impetus behind this post is a technical conversation I had with a fellow team member couple of days back. He was doing the performance analysis of a few procedures in a datawarehouse and was using the DMV sys.dm_exec_procedure_stats…