×

Did My UDF Inlined?

December 30, 2019

With the release of SQL Server 2019, CTP 2.1 new features were added to Intelligent Query Processing (QP) feature family. One of those features was Scalar UDF Inlining. You can read about the announcement by Karthik Ramachandra from Microsoft in this blog post. Karthik explained why UDFs are a problem when inlining is not done. Another […]

UDFs CPU and Elapsed Time

December 23, 2019

Microsoft SQL Server Management Studio (SSMS) version 17.5 added new showplan attributes UdfCpuTime and UdfElapsedTime to QueryTimeStats. These two attributes will measure the time and CPU spent on user-defined functions within a query execution hence helping to discover the impact of UDF execution within full query execution. This feature was first added in SQL Server […]

Gifts Received for This Year-2019

December 10, 2019

I thank Malathi Mahadevan (b|t) for hosting T-SQL Tuesday #121. The topic for this month is Gifts received for this year. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in a few. Thank you, Steve Jones (b|t), for coordinating this program. If you […]

Panelist at HA/DR Open Q&A Extravaganza

December 6, 2019

HA/DR Open Q&A Extravaganza is on December 10th, 2019, at 1 PM EST. This event is one of the most extensive lineups of SQL Server HA/DR experts in history, and any question goes! ! Organized by High Availability and Disaster Recovery PASS virtual group. I am honored, humbled, and super excited to be part of this panel. […]

Speaking at Fall 2019 Boston Azure Data and AI Fest

December 6, 2019

Boston Azure Data and AI Fest 2019 is a 2-day event on Tuesday, December 10th, and Wednesday the 11th of 2019, 9:00 AM to 5:00 PM at the Microsoft Technology Center at 5 Wayside Rd, Burlington, MA 01803. I am honored, humbled, and super excited to deliver a session on Kusto Query Language. I am […]



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook