I may need to re-think the use of table variables
Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.
2018-12-11
129 reads
Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.
2018-12-11
129 reads
2018-11-15
508 reads
As DBA's we are often looking for issues and hole is things, but it is also important to see positives and seek a better solution.
2018-10-18
56 reads
I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it.
2018-10-16
1,172 reads
In larger shops with multiple database servers, it is very important to have consistency.
2018-10-12
149 reads
It is important to train new people, so what is the best way to go about doing it?
2018-09-06
306 reads
When we risk failure, we also have the opportunity for success, so try something new today.
2018-08-30
67 reads
In many ways job titles matter, just not when telling a stranger what you do for work.
2018-07-30
147 reads
Normalization is important for relational databases, but sometimes too much of a good thing can be bad.
2018-07-23
2,139 reads
2018-05-17
100 reads
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers