A fundamental component of SQL Server is locking and locks. The locking mechanism helps to control access to resources to help maintain data integrity.
Related Posts:
An Experiment with Deadlocks March...
2016-03-01
51 reads
Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...
2016-03-08 (first published: 2016-03-01)
3,275 reads
I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and...
2016-03-01
460 reads
Previously we discussed about the pre-installation consideration, which can be found here. In the second part of this series, we...
2016-03-01
1,560 reads
By Steve Bolton
…………Just as a good garage mechanic will fill his or her Craftsman with tools designed to fix specific...
2016-03-08 (first published: 2016-02-29)
2,869 reads
Problem Statement
The requirement is to backup individual database and after successful backup the script should retain the most recent file...
2016-03-09 (first published: 2016-02-29)
2,135 reads
You need to be aware that you’re going to see differences when you’re working with Azure SQL Database when it...
2016-03-07 (first published: 2016-02-29)
1,934 reads
This Friday I will be holding a precon training session at the next SQL Saturday in Chicago called ‘SQL Server Infrastructure...
2016-02-29
841 reads
What with the #sqlnewblogger effort we’ve been seeing a lot of new bloggers (and some old ones starting up again)...
2016-03-04 (first published: 2016-02-29)
1,255 reads
Normally when I write a blog, I start out will a Hello to my Dear Reader. Not today. This was almost a blog I didn't write because I...
2016-02-29
10 reads
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers