×

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

My Stackexchange Profile

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

Announcing the 1st Data Platform Discovery Day - a 100-level, 1-day virtual conference intended for those looking to ... change their career path or data platform beginners looking to expand their skill sets. CfS live at https://dataplatformdiscoveryday.com/ til 4/13. US day 4/29, Europe day 4/30.

We are pleased to announce #SQLSaturday #1000, in Portland, Oregon on October 24, 2020!

... http://www.sqlsaturday.com/1000/EventHome.aspx

Since #SQLSat started in 2007, there have been some amazing milestones achieved along the way. Check out some of the highlights by clicking the image below! #sqlpass

I know many of us are biased between blue and red.
U want to know the fact. Call someone you trust and works in NY city ... hospital.
I did with 2 doc, 1 admin and 1 finance person.
You are bound to get angry and not trust a bit of these TV shows at 5pm.

#CoronaPandemic

No days off. Thanks to some serious teamwork, Massachusetts is set to receive over 1 million N95 masks for our ... front-line workers. Huge thanks to the Krafts and several dedicated partners for making this happen.

Load More...