2001-07-23
3,200 reads
2001-07-23
3,200 reads
Ever had to calculate the number of business days between two dates? This article presents a way to solve this problem in T-SQL.
2001-07-18
13,027 reads
Steve Jones's review of a great guide for tuning the Windows 2000 OS.
2001-07-18
3,553 reads
This book discusses some of the issues that exist today in software. A good read for anyone developing software.
2001-07-11
2,961 reads
2001-07-09
3,607 reads
Looking to advance your career? Trying to get started as a DBA? Some advice from a DBA with ten years working with SQL Server
2001-07-06
9,129 reads
Steve Jones's review of this classic and reference. A must-have for every SQL Server DBA.
2001-07-04
5,422 reads
2001-07-02
4,070 reads
Ever needed to find the first occurrance of some data. This article looks at T-SQL querying for data in natural order.
2001-06-29
12,708 reads
2001-06-25
7,075 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers