SQL Server 2005 SP4 Released
Steve Jones mentioned recently that SP4 for SQL Server 2005 is on its way because Microsoft closed his connect item....
2010-12-18
523 reads
Gethyn Ellis
INSERT INTO Reading2011 VALUES…
Last Friday I posted a short note on what books I have read this year past, so this Friday keeping...
2010-12-17
511 reads
Should I have AutoGrowth enabled on my SQL Server Database
I was reading a few forum posts yesterday where a few people were complaining that the transaction log had grown...
2010-12-15
2,399 reads
T-SQL Tuesday #13 - What the Business Says Is Not What the Business Wants
So this month’s blog party is being held by non-other than Steve Jones (blog|@Way0utwest) of SQL Server Central fame. This...
2010-12-14
595 reads
SELECT TOP 3 SQLBOOKS FROM 2010
This is just a short post for a Friday. This is my list of the Top 3 SQL Server books...
2010-12-10
963 reads
British Heart Foundation – Christmas Event
CHRISTMAS AT THE MUSICALS
Originally posted on Senghenydd Cricket Club website.
Join The Romilly Singers as they entertain you through a...
2010-12-08
557 reads
Blog – Domain Changes Update
As I mentioned in an earlier post I have recently moved my blog to a new domain name. This is...
2010-12-07
765 reads
My Weekend
We are now well into December and Christmas is fast approaching, I have most, but not all of my shopping...
2010-12-06
522 reads
Digg
I’m currently doing some experiments with ,y blog and trying out digg.com. In order to do that I need to...
2010-12-05
529 reads
MCM – Useful Resources
This is just a short post for a Friday. There has been a lot written over the past few weeks...
2010-12-03
558 reads
Blogs
Ten Years of PowerShell
Ten years ago, I published a post about filming a Pluralsight Play by Play...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers