Preparing for #sqlsat81
SQL Saturday 81 is coming up this weekend in Birmingham AL. This will be my 5th SQL Saturday to speak...
2011-07-27
591 reads
Blog Posts
Searching for Wild Card Characters
I got asked an interesting question recently, I was demonstrating how you can use wild cards in a WHERE clauses...
2011-07-27
775 reads
Some Common Disk Drives Compared
Since I talked about how wonderful the newer Western Digital Black 6Gbps SATA III hard drives are a couple of...
2011-07-27
1,128 reads
SQL Server does not script indexes by default
Here is a got-ya that happened to me. In SQL Server I want to generate a script of all the...
2011-07-27
9,110 reads
SQLSaturday #85 Orlando: Pragmatic Works BI Pre-Con!
I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in...
2011-07-27
692 reads
Strengths Finder 2.0
I’ve made the commitment to read and review 12 books over 12 months as a part of continuous personal development....
2011-07-27
900 reads
What is the hardest part of planning a SQL Saturday?
For me so far it has been the speaker selection. Getting sponsors didn’t prove to be difficult, we have a...
2011-07-27
530 reads
Fastest row counting method
SELECT COUNT(*) is most common method (and exact) how to find out how many records is in table. There is...
2011-07-26
6,387 reads
Leaked Information About AMD Opteron 6200 Series Processors
CPU World has a post about some leaked info regarding the upcoming Opteron 6200 series “Bulldozer” processor line. Here are...
2011-07-26
1,041 reads
My upcoming speaking engagements
A few days ago I had an interesting conversation on Twitter about my upcoming speaking
engagements. I really realized at this...
2011-07-26
794 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