The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
DAC - What to Execute when Connected?
SQL Server Issues? Connect with Dedicated Administrator Connection (DAC), then what? Execute this stored procedure to get some understanding on what is going on in the SQL server.
The Best Computer
Hollywood does a great job of showing off technology that might be possible someday. This Friday Steve Jones wonders what amazing computer you'd like to have.
Simple Column Chart for Analysis Services Data
This article focuses upon Column charts, and extends the examination of Reporting Services charts for Analysis Services data sources that we began in Introducing Reporting Services Charts for Analysis Services.
System Data Collection Reports
This article describes how to install the components that make up the Management Data Warehouse (MDW)
Guest Editorial: That ain't a Database, it's a Spreadsheet
Phil recently had to draw up a list of 'top ten' pieces of advice for programmers who were starting out as database developers. It is a difficult thing to do when one is immersed in the study of the intricacies and detail of the plumbing of SQL Server.
Using the CheckSum Function - SQL School Video
There are times that you want to determine quickly if any data has changed. Brian Knight shows how checksums can be used in T-SQL.
Using the Service Audit Object in SQL Server 2008
Brian Kelley looks at auditing in this article about SQL Server 2008 and the enhancements made in this version. The new Audit Object allows you to more easily determine what is happening on your SQL Server instance.
Create Backups without Breaking the Database Backup Sequence
This article shows how the COPY_ONLY clause can be used to ensure that an ad-hoc database backup do not break the backup sequence
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
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