Consolidation Matters
Consolidating SQL Server instances is something Steve Jones has done in the past and he thinks we'll all do more of in the future.
Monitoring SQL Server: An Interview with David Bick
Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore.
SQL Saturday #305: Dallas, BA Edition
Please join us on Saturday, May 3rd, 2014, as both business analysts and IT professionals come to learn and network with experts for the first SQLSaturday Business Analytics edition. Please register while space is available
Unexpected View Performance
Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.
SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide
This beginner's guide to Wait Stats by Jonathan Kehayias and Erin Stellato is a free PDF download brought to you by SQL Skills and Simple-Talk.
One Database to Rule Them All
Twitter is working on a new database that can handle unstructured as well as structured data well. Is this a competitor for SQL Server?
XML Schema validation in SQL Server
An introduction to the XML Schema Collection and XML validation.
Call for participants in deployment process research
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers for participants.
Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS
The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, especially when the generated rules become more complex. In this tip we go through an example to provide a better understanding.
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...
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