Thank you PASS Community
This has been a great week for me. I had a lot of new faces come out for the Columbus...
2011-07-29
1,521 reads
Blog Posts
Activity Monitor and Profiler
Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head...
2011-07-28
1,999 reads
Activity Monitor and Profiler
Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head blocker in a blocking chain. That script can...
2011-07-28
12 reads
Bad Admins: Non-Production Servers
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-28
2,187 reads
Do You Work for #1?
Someone recently asked me if I would work for a company if I didn’t believe in their products or services...
2011-07-28
651 reads
How to move Cluster MSDTC Drive
I recently had the need to move the MSDTC for a cluster to a new SAN drive. It’s a quite simple...
2011-07-28
2,869 reads
T-SQL refactoring
Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are...
2011-07-28
2,745 reads
When Did That Restore Finish?
I saw this question come across Twitter under the #sqlhelp tag one day and was wondering myself. Someone suggested the...
2011-07-28
7,601 reads
Exceptional DBA of the Year 2011 - Please vote for Jeff Moden
Every year Redgate has a competition to find the most
exceptional DBA of the year. This year too they are conducting....
2011-07-27
1,619 reads
Lookup functions in SSRS 2008 R2 - II
Introduction
In my last post on Lookup functions related to SSRS 2008 R2, I had explained Lookup(). It is used to...
2011-07-27
8,559 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