Derived Table Column Alias
By now, you have heard of subqueries. You have also heard of Common Table Expressions. I am sure you know what a derived table is and that you get...
2011-08-18
46 reads
Blog Posts
Feedback from SQL Saturday #64 in Baton Rouge
I did my session on The Top Ten SQL Server Skills You Need for the first time in Baton Rouge...
2011-08-18
994 reads
How to report a SQL Server performance problem
You’re experiencing a sudden slow down in SQL Server performance. Users are complaining .Many reasons could be causing this sudden...
2011-08-18
732 reads
SQL Server – "Denali" – Using Analytic Function CUME_DIST()
CUME_DIST() calculates relative position of a value relative to a group of values. The value returned by CUME_DIST() is > 0...
2011-08-18
679 reads
SQLMCM Training – Day 10
Today Paul was speaking about Database Mirroring and Jonathan was talking about Failover
Clustering – all in all a very intensive day...
2011-08-18
619 reads
Adding an Index to Save Space
Sounds weird right, but that is exactly what has happened with a VLDB I inherited. A third party database that...
2011-08-17
1,050 reads
Afterthoughts: SQL Saturday #79 South Florida 2011
This past Saturday August 13th I presented two sessions at SQL Saturday #79 hosted by the South Florida SQL Server...
2011-08-17
1,232 reads
Another New Contributor–Christian Dadswell
This is just a short post to introduce you all to my good friend Christian Dadswell who has kindly agreed...
2011-08-17
865 reads
Applied SQL: sys.objects
I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.
Prerequisites: basic...
2011-08-17
1,382 reads
Applied SQL: You Have Homework
I found myself saying this week – for the N-zillionth time – that while studying is vital, it isn’t everything. What do...
2011-08-17
585 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