What Tables Are Wasted?
Wasted space still seems to be on everyone's mind to some extent. I've wondered what tables do we use? We...
2014-01-13
549 reads
DBA On The Go
New Baby Girl!
On the 7th of January, 2014 my baby girl Kaitlyn was born. She came in about a month early.
This is...
2014-01-09
504 reads
Posts I've Found Interesting:
This is a question I had until I came across a great script by The Scripting Guys. The script below...
2014-01-06
382 reads
Final Giveaway And Some Stats
Today I'm honored to give the final prize in a month of free giveaways here, the book; Professional SQL Server 2012...
2014-01-01
331 reads
Final December Giveaway!
Today I'm giving away the book Professional SQL Server 2012 Internals and Troubleshooting. If you live outside the continental US,...
2013-12-30
509 reads
SQL Saturdays Coming Up!
Don't forget! Monday is the final give away! I will be giving away a free copy of the Professional SQL...
2013-12-27
448 reads
Powershell Backups and Post Frequency Change
It's been a good run doing a post every day. I'm scaling it back a bit. I liked getting these...
2013-12-26
753 reads
Christmas Day Winner and RDC Clients: Day 13
Finally we'll see who won the final training prize! The winner is Komal! Merry Christmas and Happy Holidays to everyone! The free...
2013-12-25
517 reads
Pre-Holiday Checks: Day 12
Expecting that great Christmas Day dinner, fire roaring, kids screaming, Excedrin stock prices skyrocketing and maybe a little something for...
2013-12-24
385 reads
Can Your Database Survive A Bus? Final Training Giveaway!: Day 11
This is the final training give away for a free month of Pluralsight! A comment on this post gets your...
2013-12-23
471 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