Query tuning 101: Problems with IN ()
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,721 reads
CHECKDB’s Hidden Snapshot
I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the...
2016-11-10
467 reads
SQL Server 2016 - “Number of Rows Read” on Execution plan
One of the coolest things to release with SQL Server 2016 was “Number of Rows Read” information in execution plan....
2016-11-10
844 reads
Do you know anything about firebird?
Has anyone in my network or readers my blog have any experience of a database called Firebird?
If you have and...
2016-11-09
389 reads
This Week In Data – Episode 12 (How to Interview a Customer)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-11-09
421 reads
SQL Server: Discuss Execute(SQL) At LinkedServer
Abstract
This article details the use of “Execute AT LinkedServer” clause. It’s best in some ways when you are trying to run...
2016-11-09
1,868 reads
Azure Data Platform Learning Resources
I know that more and more of you are moving more and more resources into the Azure Data Platform. In...
2016-11-09
622 reads
The ROI of SQLSaturday
Following up on my notes about the 2016 SQLSaturday Roundtable I wanted to write more about the ROI of SQLSaturday....
2016-11-09
480 reads
Drag & Drop Table & Column Names in SSMS
I was working with a developer the other day and he was typing out each table name and all the...
2016-11-09
1,089 reads
Big Data, Network Security, SQL Programming, PRINCE2, Baby save a little 2 for me
This weeks Learning Tree deals are in. If you want to learn about big data, Network security and with the...
2016-11-09
412 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