Index Black Ops Part 6 – Fill Factor vs. Page Splits
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-10-02
1,612 reads
Strange but True - Report Parameter Label Blank
Here is another one of those strange but true things that I come across every so often which I thought...
2010-10-01
1,520 reads
SQLSat 54
Wow, I have really been kinda slow in the blog department for a couple of weeks now. I have a...
2010-10-01
595 reads
Create Empty Raw File
I need an empty Raw file for my SQL Server Integration Services (SSIS) package. Over the last summer I’ve discovered...
2010-10-01
740 reads
October Question: Tell us about your favorite experience as a participant in the SQL Server community.
There is a thriving world-wide DBA community that offers many opportunties meet other DBAs, to learn from others, and to...
2010-10-01
1,365 reads
Free SQL Server Training for the Week of October 4, 2010
Monday
Quest Software - Advanced SQL Server Troubleshooting - Kevin Kline
Tuesday
PASS Performance Virtual Chapter - Using Storage to Increase Database Performance - Denny Cherry
Wednesday
SQL Lunch...
2010-10-01
1,064 reads
Why Read?
I love to read. Like my friend, Paul Randal (blog, @PaulRandal), I read a lot of books every year, usually...
2010-10-01
358 reads
Index Black Ops Part 5 – Page Splits
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-10-01
885 reads
Presenting at SQLSaturday #48 in Columbia, SC This Weekend
I’m leaving Orlando early Friday morning to drive up to Columbia for SQLSaturday #48 . By the time I changed planes...
2010-10-01
311 reads
The Land of BBQ
I’m off to Kansas City today for SQL Saturday #53 and looking forward to a great speaker’s dinner tonight at...
2010-10-01
346 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers