1-Week to PASS Summit 2010 – After Hours
Final post for the countdown – a little later in the week than I wanted. Right now there is less than...
2010-11-05
621 reads
The Tapestry
When I run on the treadmill, I have a TV and DVD player down there and have been watching Star...
2010-11-05
484 reads
Free SQL Server Training for the Week of November 8, 2010
Tuesday
PASS - Day One Opening Keynote (Ted Kummert) Live Stream
Wednesday
PASS - Day Two Keynote (Quentin Clark) Live Stream
PASS - Women in Technology Luncheon...
2010-11-05
733 reads
How Stale Are My Statistics?
Unlike fine wine, you typically wouldn’t want your statistics to be aged. At least for tables that are being updated...
2010-11-05
11,864 reads
A Brute Force Way to Compress a Database
There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database...
2010-11-05
2,036 reads
Dr. DMV Queries From Fall 2010 SQLConnections Conference
This is the SQL Server 2008/2008 R2 version of the DMV Diagnostic Information Queries that I did for my Dr....
2010-11-04
880 reads
An Invitation To Come To My PASS Summit Session On Blogging And Speaking
On Wednesday morning at 10:15 AM during the 2010 PASS Summit next week I'm presenting "Getting Started In Blogging And...
2010-11-04
715 reads
SQL ServerPedia – Blog Awards
I have been catching up on some blog posts and I read a few posts by well known bloggers like...
2010-11-04
598 reads
Ascending Mount BI Stack: Basecamp
Not quite Mount Doom but...
As some of you may know, I’ve recently transitioned over from the fabulous life of being...
2010-11-04
610 reads
Return of the Index Analysis Report
Let’s Anaylze An Index! Finally up to the last post of this series resurgence. Time to update the Index Analysis...
2010-11-04
1,161 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
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