Stupid Coding Tricks
Can anyone here write a SQL statement that generates a Mandelbrot Set? I’m sure a few of you can, and...
2008-12-11
874 reads
Blog Posts
Just Do It
I was recently reading Joel Spolsky’s column in Inc. on management and I thought it was an interesting story. In...
2008-12-10
861 reads
SQL Quiz Part 2: Career Challenges
I’ve read a number of responses from Chris Shaw’s first DBA networking quiz. I missed out on the first one,...
2008-12-10
1,280 reads
You're Not Dumb...And Neither am I
One of the things I'm not fond of is self-deprecation. Smacking yourself on the forehead when you screw up a...
2008-12-10
533 reads
Are You Security Minded?
It's fun to just sit and talk with people, never know what you'll learn or be forced to rethink based...
2008-12-09
738 reads
DBAs Still in High Demand
With the world economy on the downside, there is at least one bright light, and that is DBAs are still...
2008-12-09
1,106 reads
Leaving Live
Last week Steve Ballmer had issued a challenge to MVPs to have them try Live Search instead of their regular...
2008-12-09
665 reads
A Custom Trace
I have to admit that when I had a performance problem with some code, I would often fire up Profiler...
2008-12-08
702 reads
Managing By The Numbers Part 2
Managing by the numbers often gets a bad name among employees because it can lead to a lot of gaming...
2008-12-08
661 reads
Tampa Code Camp Notes
I attended the Tampa Code Camp this past weekend. It was located at the Kforce Building in Tampa, a very...
2008-12-08
1,108 reads
Blogs
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...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
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