Watch this week's video on YouTube
Over the past several week's I've been exploring ways to rewrite queries to improve execution performance.
I learned a lot of these techniques over time from...
2019-05-28
39 reads
Watch this week's video on YouTube
Over the past several week's I've been exploring ways to rewrite queries to improve execution performance.
I learned a lot of these techniques over time from...
2019-05-28
9 reads
Problem Today, I have a request to create a new database on two-node SQL Server 2016 failover cluster instance, which is in an active/passive configuration. I connected to the...
2019-05-28 (first published: 2019-05-14)
3,635 reads
Late last year, I wrote a series of articles about Predictive Modeling using R and SQL Server Machine Learning Services. At the time, I thought MLS was an underutilized...
2019-05-28
40 reads
In a previous post I went through how to deploy SQL Server running in an Azure Container Instance using Terraform. In that post, I used hardcoded variables in the...
2019-05-28 (first published: 2019-05-15)
311 reads
One of my friends client has got an issue with his SQL Server. A weekly database integrity check has reported a corruption for one of his databases. The corruption...
2019-05-28
30 reads
G’day, I recently got the opportunity to speak at the “PASS Marathon, The New World of Data Privacy”. I had not spoken at a virtually event for quite some...
2019-05-28
15 reads
I’m writing this in advance, as I usually recommend for all bloggers, because this is a lost day for me. I’m not going to experience May 27th, 2019 on...
2019-05-27
41 reads
It’s TSQL Tuesday and Matthew McGiffen (b/t) is our host with a subject near and dear to my heart. Puzzles! ... Continue reading
2019-05-27 (first published: 2019-05-14)
488 reads
What is the maximum number of rows for the Table Value Constructor? And, do different uses of it behave differently?… Continue reading Maximum Number of Rows for the Table...
2019-05-27 (first published: 2019-05-09)
838 reads
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers