Table Space revised Again
Since I am in the Collation Sensitive mood, I am finally getting around to updating this script. This is the...
2011-11-17
1,024 reads
Blog Posts
DBA in Space: Behind the Scenes Part 3
This is a continuation of my DBA in Space journal.
Friday, September 16, 2011
OMG. (This is the first time in my...
2011-11-16
619 reads
Degenerate Dimensions
Degenerate dimensions, also called fact dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of...
2011-11-16
5,002 reads
Identify Risk Early
One of the mistakes I see a lot is teams failing to identify risks early and failing to leave time...
2011-11-16
487 reads
SQL Saturday 86 BI Edition Tampa 2011: Afterthoughts
Wow! Just Wow! That’s all I can say to describe how great SQL Saturday 86 was on November 5th in Tampa,...
2011-11-16
1,291 reads
SQL Server A to Z – Views
Happy Wednesday folks! Hope everyone’s having a great week. This episode of SQL Server A to Z is brought to...
2011-11-16
1,086 reads
SQL Triggers - An Introduction
Introduction
Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute...
2011-11-16
12,915 reads
SSWUG SSIS Expo Event This Friday
Home Sweet Cubicle
If you are looking for a little training on SQL Server Integration Services (SSIS) without having to leave...
2011-11-16
614 reads
Stop SOPA…it already happened in Denmark #StopSOPA
I put out the call to stop SOPA, and one Twitter friend wrote back:
Good luck! We have it in Denmark....
2011-11-16
553 reads
Table Hierarchy goes CS
At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity. The first few rounds, I neglected Case Sensitivity and never...
2011-11-16
22 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