Drsql's Database Musings
Feeds I Read
Calendar
Presentations
Publications
About
Search
Search
Category:
SQL Server
SUBSTRING Optional Length In SQL SERVER 2025
2026-04-08
Read/Write Ratio in a SQL Server database
2026-04-01
DATE_BUCKET performance versus conventional methods
2026-03-25
SSMS Updating and a new Grid Export Feature
2026-03-19
Datatype precedence and performance in SQL Server
2026-03-11
Datatype precedence and finding the datatype of an expression
2026-03-04
Creating data from literal values in SQL Server
2026-02-25
A SQL method for computing rolling totals without window functions
2026-02-18
OK, SELECT * doesn’t belong in EXISTS either
2026-02-13
The evil (and value) of DISTINCT
2026-02-11
Generating a set of sequential numbers, part 2
2026-02-04
Performance test of generating a set of sequential numbers
2026-01-28
Cool features in SQL Server I missed…DATE_BUCKET
2026-01-21
How indexes are used with COUNT in SQL Server
2026-01-14
Using TRANSLATE in SQL Server instead of REPLACE
2025-12-03
Awesome Use of RegEx in SQL Server – Multiple Filters
2025-11-19
AI, Crazy Quoted Identifiers, and comparing column names between tables
2025-11-18
Using FORMATMESSAGE in SQL Server to Enhance my Temporary Procedure
2025-11-12
SQL Strategies for Comparing Sets of Data
2025-11-05
Temporary Stored Procedures: Outputting Status in Scripts
2025-10-29
Temporary Stored Procedures in SQL Server
2025-10-22
Concatenating values as character data including in SQL Server 2025
2025-10-15
Fun with COUNT aggregate calls
2025-10-08
Fun solving a SQL problem (that I will never use in production)
2025-10-01
Time Zones and Time Zone Conversions in SQL Server
2025-09-24
And the rest – REGEXP_INSTR, and REGEXP_COUNT
2025-09-17
REGEXP_ Functions in SQL Server 2025 – REGEXP_SUBSTR
2025-09-10
REGEXP_ Functions in SQL Server 2025 – REGEXP_SPLIT_TO_TABLE
2025-09-03
REGEXP_ Functions in SQL Server 2025 – REGEXP_REPLACE
2025-08-27
Flags in SQL Server Regular Expressions – Multiline Processing
2025-08-20
Flags in SQL Server Regular Expressions – Case Sensitivity
2025-08-13
Viewing Multiple Matches in SQL Server Regular Expression Functions
2025-08-06
Negating Character Classes and Class Shortcuts in SQL Server RegEx
2025-07-31
My Current Favorite Thing in SSMS – Presenter Mode
2025-07-29
Matching one of a set of characters with SQL Server Regular Expressions
2025-07-24
Using IS [NOT] DISTINCT FROM to compare data with NULL values
2025-07-22
Repeating Pattern Matching with SQL Server Regular Expressions
2025-07-16
Simple Pattern Matching with SQL Server Regular Expressions
2025-07-11
Cardinality and REGEXP_LIKE
2025-07-02
SQL Server REGEXP_LIKE features augment, not replace, LIKE
2025-06-26
ChatGPT’s Attitude is interesting
2025-06-19
Loading Comments...
Write a Comment...
Email (Required)
Name (Required)
Website
Notifications