TSQL Challenge 61 - Generate an HTML calendar in TSQL
This challenge is to generate an HTML calendar based on the data stored in a table.
Migrating SQL Server Databases – The DBA’s Checklist (Part 2)
Continuing from Part 1 , our Migration Checklist continues: Step 5: Update statistics It is always a good idea to update the statistics of the database that you have just installed or migrated
SQL Saturday #81 - Birmingham, AL
Come get a free day of SQL Server training in Birmingham on Jul 30, 2011.
"SQL Solstice I: The Dog Days of SQL" Opens For Registration!
Get three days of training in Raleigh, NC on Aug 18-20. There are free and paid options that you can read more about.
SQL Overview VI - Monitoring Process Locks
In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.
Be Reasonable
Be reasonable. That's how Steve Jones thinks managers ought to behave towards their employees.
How to use temporary table in function
See a short and dirty example how to use temporary table in user defined function (UDF).
URI Parser: A set of 20 CLR functions for URI parsing
A set of 20 functions for URI and URL parsing, using .NET's native System.Uri parser
Managing SQL Server Service Broker Environments
SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and later versions) that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message-based applications within the database itself. Arshad Ali looks at how we can manage, monitor and troubleshoot Service Broker environments.
PASS Data Architecture Present Microsoft – Readying on ‘Hadoop’
On Thursday July 20th, MCM Gaurav Aggarwal will provide an overview of the different options on MS platform for Hadoop
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