I consider myself fortunate that I get to work with so many different clients while engaged in Comprehensive Database Performance Health Check. Recently we found out that one of...
2019-05-06
(last updated: 2019-05-05 @ 11:55 EST / 2019-05-05 @ 15:55 UTC ) I had gone through the process of uninstalling the now obsolete SQL Server 2019 CTP, and then...
The...
2019-05-05
This question has come up many times how to capture the SQL Server Database Recovery Progress or Total time take to recover a database. It will help to plan...
The...
2019-05-04
On occasion you have to find means to get around an issue. John Morehouse shows why Robocopy can be a useful tool in testing circumstances.
2019-05-03
Once in a while you might need to make common changes to a lot of SQL Server Agent Jobs.
2019-05-03
You know what it’s like, you need to fail your AG over but is it safe to fail over? Even if your AG says it is, there are other thing to consider...
2019-05-03
498 reads
Achieving minimal logging with INSERT...SELECT can be a complicated business.
2019-05-02
Gail Shaw keeps seeing this in all sorts of places. People getting an unexpected result when working with a subquery, typically an IN subquery, and assuming that they’ve found...
2019-05-02
For me, this particular code to generate a script to recreate indexes has more practical use in a replication environment.
For example, the default replication setting is to exclude the...
The...
2019-04-26
Linked Servers offer a great way to connect two SQL Servers together, allowing remote querying and DML operations. Frequently, this is used to copy data from production to reporting....
2019-04-25
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers