×

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 […]

Database Administration Virtual Group

December 20, 2019

View Event: New features in Management Studio — Performance Troubleshooting made easier!https://dba.pass.org/MeetingDetails.aspx?EventID=14678 Abstract SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools, which enabled rapid enhancement to the Execution Plan. Do you know that now you can see how many pages are spilled to disk […]

Rochester PASS Chapter Monthly Meeting

December 20, 2019

View Event: Azure SQL Database – Where is my SQL Agent? You migrate your on-premise SQL Database to cloud, taking advantage of the PaaS offering of Azure SQL Database. You heard the promise of spinning up databases on demand and being able to scale up resources during high peak and scale down when not in […]

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 […]


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

Lightning Talks! We had them the last time and they are back. We have 10 speakers lined up to cram as much content as ... possible into a 10-minute slot. Find out more at http://www.dataweekender.com and sign up.

SSMS 18.9 had a bug. Fix is out with 18.9.1
... https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

SQLServerGeeks is conducting a Virtual Symposium on SQL Server and Azure SQL.
Learn from skilled data professionals and... gather critical knowledge on all things SQL.

http://bit.ly/ssg_vs_may_2021

#SQLServer #SQL #AzureSQL @feaselkl @EdwardPollack
@rob_rich @i619619 @dbafromthecold

Calling all SQL database administrators, this session is for you! SQL is everywhere you need it from the IoT Edge to ... your datacenter to public clouds. Learn about these options, which to choose, and why with @BobWardMS on April 28. Register: https://bit.ly/3dffR9z #AzureSQL

Load More...