OPTIMIZE FOR Hints When Parameter Sniffing is Turned Off
While presenting recently and talking about dealing with bad Parameter Sniffing, I got the question; what happens to OPTIMIZE FOR...
2016-12-12
645 reads
SQLBits 2017 In April
I’m getting excited, with the announcement that SQL Bits 2017 is scheduled. The conference goes back to Telford, which I...
2016-12-12
532 reads
A Shortcut for Parameterizing Settings in SSIS
I’ve written quite a bit about the benefit of externalizing changing values in SSIS packages. Moving static values such as...
2016-12-12
360 reads
SQL Server DBA Tips that Can Save Your Ass
On November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was...
2016-12-12
393 reads
The Eleven Days of Festivus
It’s that time of the year again – the Festivus season is upon us! In the next few weeks, families all...
2016-12-12
306 reads
Combining statement with conditional operators
Operators “AND”, “OR”Sometime we need to combine two or more TSQL statement based on some conditions, that we can achieve...
2016-12-12
272 reads
Monday Coffee 2016-12-12
Speaking and presenting
One of my biggest fears is public speaking and judging by this article, I’m not alone.
However it’s something...
2016-12-12
302 reads
Database synchronization in the Software Development Life Cycle
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development Life Cycle (SDLC)? Stick around, because I'll get to...
2016-12-12
29 reads
Database synchronization in the Software Development Life Cycle
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development...
2016-12-12
861 reads
How to use DTA (Database Tuning Advisor) with Plan Cache option?
SQL Server 2012 comes up with new workload option in DTA (Database Tuning Advisor). In addition, on existing options File...
2016-12-12
2,673 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