Computed Column Performance in SQL Server
Computed columns may be the cause of hard to track down performance issues. In this article, Robert Sheldon reviews the issues and some ways to get around them.
Create AT&T Network Hierarchy Diagrams using SQL Server Data
Diagrammatic support for large, complex hierarchical data structures in SQL Server.
What's the Lunch Factor?
DevOps is about being effective and getting work out to customers. Today Steve notes that the lunch factor might help you reexamine your software development process.
Auto Scaling Azure SQL DB using Automation runbooks
Learn how to auto scale an Azure SQL Database with Azure runbooks and using an existing runbook from the runbooks gallery.
Welcome to Redgate Deploy and Cross-platform Database DevOps
Until now, organizations wanting to introduce database DevOps have had to rely on – and purchase – different tools and solutions for different databases. A new cross-platform database DevOps solution, Redgate Deploy, changes the rules. Find out why in this latest blog post.
PowerShell Day by Day: Filtering Objects
In my last article, The Basics of PowerShell Day By Day, I covered some basics of getting started. These articles aren't intended to replace some of the getting started information in things like the Stairway to PowerShell. Instead, I am covering some of the tips, tricks, techniques, and bits of knowledge that I wish I'd […]
Pulling Together
A number of companies worked together to ensure that they could meet the challenge of the NHS. Sharing data was critical to this effort.
How We Ended up with Git
Git is used by many teams for version control. In this article, Dino Esposito takes a look back at the history of source control and how git became the popular tool it is today.
AI Data
Data is important for AI projects, but the ethics and privacy implications are complex. A new project from Microsoft aims to help users control their data and make it available for use.
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
ALAMAT KONTAK BCA KCU PONTIANAK Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
ALAMAT KONTAK BCA KCU BALIKPAPAN Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers