Working with Queues in SQL Server
This article shows sow to create a queue from a SQL table to serve each operator exactly one item from the queue that has not been picked up by any other.
2010-04-05
27,294 reads
Articles
Celko's SQL Stumper: Eggs in one Basket
Joe Celko returns with another stumper to celebrate Easter. Unsurprisingly, this involves eggs. More surprising is the nature of the puzzle: This time, the puzzle is one of designing a database rather than a query. DDL as well as the DML.
2010-04-05
2,337 reads
SQL Server Indexed Views
Views can be an effective tool for speeding up your selects and simplifying complex queries. Learn what indexed views are, where you might want to use them, how to create them, and what constraints exist with their use.
2010-04-05
5,000 reads
TSQL Challenge 27 - Identify overlapping weekly schedules of Nurses
This challenge is related a scheduling problem in the home health care industry. The task is to look into the schedules of nurses and identify any overlapping schedules.
2010-04-05
2,580 reads
A High Level Comparison Between Oracle and SQL Server - Part IV
The concluding part of the Oracle / SQL Server comparison looks at error logging, security, installation and finally querying the databases.
2010-04-02
3,828 reads
Decoding the SQL Server Index Structure
A deep dive into the implementation of indexes in SQL Server 2008 R2. This is information that you must know in order to tune your queries for optimum performance. Partial scans of indexes are now possible!
2010-04-01
8,196 reads
Insider Insights
Insider rumours and gossip from the murky world of the Database Industry, and from the colourful characters that inhabit it.
2010-04-01
2,611 reads
2010-04-01
3,279 reads
Managing Your Backup Files
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
2010-03-31
1,271 reads
SQL Server 2008 - Accessing Audit Details
Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.
2010-03-31
2,478 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers