SQL Server Always On Read Only Routing Lists
With the release of SQL Server Always on came the ability to query replica’s and offload read only requests. This...
2019-02-12 (first published: 2019-01-23)
2,636 reads
With the release of SQL Server Always on came the ability to query replica’s and offload read only requests. This...
2019-02-12 (first published: 2019-01-23)
2,636 reads
With our effort to talk about SQL Waits we come across another common wait called CXPacket. Last week we reviewed...
2019-01-30 (first published: 2019-01-16)
2,688 reads
I want to take some time and discuss my experiences with a certain SQL Server error, error 9002. Error 9002...
2019-01-10
14,792 reads
Over the next few weeks we will be reviewing some of the common SQL Server Waits. We will explain what...
2019-01-03
1,562 reads
Max Degree of Parallelism is a setting that is often changed to improve performance in SQL Server. What exactly does...
2019-01-07 (first published: 2018-12-21)
2,760 reads
One of the more common wait types for SQL Server is called WriteLog. In its most basic form it is...
2018-12-27 (first published: 2018-12-18)
3,651 reads
Indexes in relational databases are very helpful and increase the speed to access data. However maintaining indexes is just as...
2018-12-11
216 reads
Performance tuning in SQL Server is one of the main jobs a DBA has. Starting with SQL Sever 2016 a...
2018-12-05
1,233 reads
Deadlocks in SQL Server happen when 2 (maybe more) processes are fighting over a resource in the database and are...
2018-12-18 (first published: 2018-12-03)
3,223 reads
My holiday week did not started off very good. I come in and find a UAT environment database in suspect...
2018-11-27
27,390 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers