SQL Local Variables and Performance Issues
In this article, we examine the effect of local variables on T-SQL queries and how these could potentially cause performance issues.
In this article, we examine the effect of local variables on T-SQL queries and how these could potentially cause performance issues.
In this next installment, John performs the research you might do if your management asked you to examine Fabric.
This editorial was originally published on Jul 13, 2019. It is being re-run as Steve is out of town. I recently had the pleasure of catching Paul McCartney in concert, and he was amazing. I have been a fan forever and have heard him tell the same stories he over and over with great delight. […]
This section gets into detailed SQL Server configuration details. This is less relevant in a cloud environment, but there are still items to confirm.
Today Steve talks about how we end up with software systems that don't appear to be well engineered.
Lean how to implement linear regression in SQL Server by running Python code on your data in SQL Server using Machine Learning Services.
This article explores how enabling READ_COMMITTED_SNAPSHOT on your SQL Server database might ease excessive blocking.
After a recent data breach, Steve read about an analysis of the data. He has a few thoughts on the process that Troy Hunt went through to dig into the data.
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
In this second level of the Stairway to Synapse, we learn how to create external tables and query data that is stored in our data storage using the serverless pool.
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
By Rob Sewell
The partner directory connects your agency with new customers.
I had an excellent group of people in Gothenburg Sweden when I taught there...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Hello all, Is there an easy way to output my records to a flat...
Comments posted to this topic are about the item Refactoring Databases: Evolutionary Database Design
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers