Targeted Plan Cache Removal
A lot of times you’ll hear how people are experiencing sudden, intermittent, poor performance on a query, bad parameter sniffing...
2015-09-02 (first published: 2015-08-24)
1,587 reads
The tail of the log
The tail of the log
A little while back I was feeling overwhelmed by the number of blog posts ideas that...
2015-08-24
654 reads
Above All, Good Judgment
What is permissible is not always honorable. – Marcus Tullius Cicero
Rules. Best practices. Guidelines. Design patterns. Policies. All are good and...
2015-08-24
585 reads
Actual Emails: Allow NUNS to Lead You to Good Clustered Index Design
Wrote this email exchange with a colleague who wanted to confirm that the client-proposed design for a table was... less...
2015-08-23
439 reads
WWH in SSIS ? Zero to Hero in SSIS series TIP#111
Dear Friends,
As shared in last post Post #110, We are starting SSIS tutorialseries ( A Step by Step SSIS learning tutorial)...
2015-08-22
829 reads
016 – Me, Myself and I - WaterOx Consulting
Me, Myself and I In WOxPod!, episode # 016 – “Me, Myself...
The post 016 – Me, Myself and I appeared first on WaterOx...
2015-08-21
804 reads
Versions (Master Data Services) - Where to use
Multiple versions of the master data within a model can be created in Master Data Services(MDS). When you create a model for the first time, Master Data Services (MDS)...
2015-08-21
267 reads
Versions (Master Data Services) - Where to use
Multiple versions of the master data within a model can be created in Master Data Services(MDS).When you create a model...
2015-08-21
702 reads
Designing a Data Warehouse from the Ground Up Webinar Recording with Q & A
Thank you to everyone that registered and attended my webinar Designing your Data Warehouse from the Ground Up webinar this...
2015-08-21
753 reads
Your Devs' Questions Answered With sys.dm_server_services
It starts with "I'm a developer...
"... with no RDP access, how can I tell if the SQL Server Agent service...
2015-08-20
831 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