Deleting Duplicates without a unique key
The following was sent to me by my friend and colleague Dave Miller:
Dave's Email:
Wanted to pass along something I hadn't...
2008-08-21
1,632 reads
Blog Posts
Kindle - On the clock
In a week and a half, I start on the first of my four trips this year for work, and...
2008-08-21
1,462 reads
Taking Care of Employees - Storms
As I write this a tropical storm is passing over Orlando and has turned out to be milder than expected...
2008-08-21
1,404 reads
[Off Topic] The Big Apple
I got my first opportunity to visit New York City last week. I was actually sitting in on a training...
2008-08-20
1,555 reads
SQLSaturday #8 in Orlando - Update (Aug 21)
Registration has been open for only a few weeks and we've got 110 registered so far, a nice start! We...
2008-08-20
1,462 reads
Troubleshooting High Connections & What's The Application Name?
I was visiting with a client recently when they asked me to come take a look at an incident in...
2008-08-20
1,371 reads
Notes on My Visit to the St Louis SQL Group
Actually it was subset of the group, but Kathi & Julie from the St Louis SQL Server User Group did a...
2008-08-19
1,423 reads
Speaker workshop
Andy Warren made a trip to St. Louis this past weekend to put on a speaker workshop for our user...
2008-08-19
1,324 reads
What every DBA that manages a large number of SQL Servers should know about SQL 2008!!
Error when importing RegServer list from SQL 2005 to SQL 2008
I discovered the already known bug in SQL 2008 that...
2008-08-19
3,095 reads
Building a Security Philosophy Posted on SQLServerCentral.com
This was actually posted about a week ago, fell behind a little during travelling. Building a Security Philosophy was written...
2008-08-18
1,501 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
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...
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