2010-08-10
3,256 reads
T-SQL
2010-08-09
3,582 reads
2010-08-04
3,766 reads
Creating Holidays and Special Dates
A way to save holiday records that can be created as needed into a search-able calendar table.
2010-08-04
14,444 reads
2010-08-03
3,357 reads
2010-07-28
3,206 reads
UPDATE Basics in SQL Server
SQL Server's UPDATE statement is apparently simple, but complications such as the FROM clause can cause puzzlement. Bob Sheldon starts simply, and introduces the more complex forms painlessly.
2010-07-28
6,014 reads
Dynamic Data Driven Variable Hierarchical Structures in SQL
This article describes data driven variable structure generation in SQL. The controlling data can be located higher up on the hierarchical pathway or can be located further down on the pathway producing a look-ahead operation. Multiple pathways can independently produce dynamic data driven structures and these dynamic structures can be nested allowing a very flexible and powerful dynamic automatic data structure generation capability. These different controls of structure generation can be combined.
2010-07-27
2,757 reads
Show database size info across an instance
This script shows size information of every database on the instance.
2013-08-21 (first published: 2010-07-26)
5,955 reads
2010-07-26
3,872 reads
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
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...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
BIT_COUNT I
Comments posted to this topic are about the item BIT_COUNT I
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers