Why is the XLOCK table hint broken?
Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources...
2020-02-20 (first published: 2020-02-12)
426 reads
Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources...
2020-02-20 (first published: 2020-02-12)
426 reads
I’ve created a sample ads extension that checks TSQL syntax in real-time for potential bad practice. Right now the extension is using regex, which isn’t the best for parsing...
2020-02-13
67 reads
Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines? In SQL Server Management...
2020-02-12
1,854 reads
If you’re a data professional or application developer chances are you’ve run into Microsoft SQL Server once or twice. I would think that the majority of SQL Server professionals...
2019-05-30
76 reads
About a year ago I wrote about a new feature in SSMS that allows you to add a data classification...
2019-03-08 (first published: 2019-02-20)
2,527 reads
It’s taken longer than I thought it may and I’ve run into several problems along the way but had a...
2019-02-13
208 reads
Before you read too far, this is going to be a deeply personal post.Where do I begin? As many of...
2019-02-13
140 reads
In case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that...
2018-09-24
261 reads
I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog...
2018-09-18 (first published: 2018-09-10)
3,882 reads
For those of you in the Denver area, SQL Saturday is this weekend! I’m speaking and hope to see you...
2018-09-11
213 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers