Parsing Parameters in a Stored Procedure
This article shows a clean non-looping method to parse comma separated values from a parameter passed to a stored procedure.
SQL Server Function to return a range of dates
A quick solution is a table function that will create a date range based on the parameters given. Then, you can just join to the results.
Manipulating XML Data in SQL Server
When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from SQL, it is often done 'at arms length'. A shame, since effective use of techniques that go beyond the basics can save much code,
Software Teams
Building a team when you are developing software of any size is important and Steve Jones shares one of the most important things you need.
Stairway to SQL Dialects Level 1: Overview
In the first level of his Stairway to SQL Dialects, Joe Celko looks at the origins of the SQL language and how the language has spawned the various different dialects in use today.
SQL Server Reporting Services 2012 Permissions
As you begin developing reports for deployment to a Report Server, what security considerations need to be taken into account in order to grant users access to run a report.
Keeping Your Job
A few thoughts from Steve Jones on how you can help increase your own job security in IT.
Routine Dependency Visualizer
This article contains a T-SQL script that can show you the dependency of all objects in your SQL Server database.
SQL Server 2012 Integration Services - Unattended Execution of SSIS Packages
Quite often, tasks accomplished via SSIS are a part of procedures that run unattended, either scheduled to launch at a particular date and time or triggered by some arbitrarily chosen event. Marcin Policht shares a typical approach to implementing such a scenario.
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