×

SQL SATURDAY #961 Albany

July 25, 2020

View Event: Think like the Cardinality Estimator SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code […]

SQL SATURDAY #961 Albany

July 25, 2020

View Event: Need to Monitor Any Azure Resource? Must Learn Kusto Query Language Kusto is a service for storing and running interactive analytics over Big Data, easy to query using Kusto Query Language (KQL). As we make progress in our migration to the cloud, we are learning new ways to monitor and alert on resources and […]

Rochester PASS

July 29, 2020

View Event: The Magnificent Seven – Intelligent Query Processing in SQL Server Is there a way to fix query performance issues without any code changes? Making application changes can be an expensive undertaking. Hence, developers and DBAs want the query processor to adapt to their workload needs vs. having to use options and trace flags […]

Lightup Virtual Conference

July 14, 2020

View Event: Think Like The Cardinality Estimator SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates based on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code […]

Global 2020 Summer Azure DataFest

July 2, 2020

View Event: Azure SQL Database – Where is my SQL Agent? You migrate your on premise SQL Database to cloud, taking advantage of 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 […]


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

Q: If I hold an *exclusive lock* on a row, can another transaction running at (the default) *locking read committed* ... isolation level read it?

A: Yes!

SQL Server can skip shared locks if there is no risk of reading uncommitted data without them:

https://www.sql.kiwi/2010/11/read-committed-shared-locks-and-rollbacks.html

facebook copied my entire app, then renamed it IG Threads. pro tip: don’t present your hard work at their developer ... conferences https://twitter.com/dhof/status/1288233909931642880

dom hofmann@dhof

facebook has copied a lot of my work

Next Virtual Boston Azure (@bostonazure + @NorthBTownAzure) meetup will be on Tuesday 8/11. Learn very useful @Azure ... tips and tricks from the one and only @mbcrump. As always, don’t forget to RSVP here: https://www.meetup.com/bostonazure/events/272237070/ #AzureTipsAndTricks #Azure

Not an acceptable distance for a weekend run.
Blame kids activity.
Have to go out for another run or cycling.
... #selfcare
#sqlrun

Learn about "The Good, The Bad, and The Ugly" with TempDB next week (📅 Aug 12) with @SQLGoddess: ... https://bit.ly/2D08fJJ #AzureSQL

Load More...