SQL Server Error 3257 – Causes and Solution
Overview
While working with SQL server, users may encounters numerous errors in different stages. These errors creates huddles in SQL transactions...
2016-07-12
929 reads
Default database file sizes
It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing...
2016-07-12
759 reads
T-SQL Tuesday #80–Chris Yates’ Birthday
It’s the 80th version of T-SQL Tuesday. You can see all the parties from the past on my page, but...
2016-07-12
504 reads
Target Recovery Interval and Indirect Checkpoint
Introduction The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log...
2016-07-12
11 reads
Target Recovery Interval and Indirect Checkpoint
Introduction The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log...
2016-07-12
55 reads
Target Recovery Interval and Indirect Checkpoint
Introduction
The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process....
2016-07-12
299 reads
Target Recovery Interval and Indirect Checkpoint
IntroductionThe process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process....
2016-07-12
586 reads
Are you a new SQL Server DBA? Live Blog @LearningTree
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration course in LEC in London. Following on from...
2016-07-12
561 reads
Training To-Do List for New DBA
Are you an entry-level DBA, or looking to make the career switch? Feel like you are looking up from the...
2016-07-18 (first published: 2016-07-12)
4,955 reads
Improvements with SSMS 2016
The staple of every SQL Server developer's world, SSMS has been impossible to usurp for the majority of us. However,...
2016-07-19 (first published: 2016-07-11)
3,625 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