A quicker way than using count(*)
A quick little tip I found a couple of years ago. Ever use the count(*) syntax and it takes forever...
2011-05-09
570 reads
Blog Posts
Minnesota SQL Server Study Group
Study Time!
A few weeks back, I sent a message on the PASSMN LinkedIn group page about expanding the MCM study...
2011-05-09
694 reads
PASSMN May Meeting
If you are going to be visiting Minnesota on May 17th or are there on more permanent basis, you can...
2011-05-09
640 reads
Pragmatic Tools Week: BIxPress
Much like Tim “The Toolman” Taylor had his themed weeks, we’re going to do something similar. This week we salute:...
2011-05-09
667 reads
Speaking at Colorado Springs SQL Server User’s Group on June 15
I will be speaking at the Colorado Springs SQL Server User’s Group, live and in person, on Wednesday, June 15,...
2011-05-09
516 reads
SQL Azure Migration Wizard
There’s a project over on code plex to come up with a mechanism for validating databases and generating the necessary...
2011-05-09
1,313 reads
Sql Saturday #83
Frikkie Bosch opened the day with a short keynote giving an overview of Denali, talking mostly from a marketing point...
2011-05-09
805 reads
SQLRally Orlando Begins This Week!
It actually starts tomorrow for me (and many of you), I’ll be at the Marriott World Center around 1 pm...
2011-05-09
828 reads
SSC Editorial: Running as SysAdmin
My editorial about Running as Sysadmin ran in the SQLServerCentral newsletter yesterday and generated some good (and passionate!) responses. It’s...
2011-05-09
839 reads
Catalog view or compatibility view?
G’day,
The recommended way to access SQL SERVER metadata is through the catalog views.
The challenge is to be able to distinguish...
2011-05-08
3,017 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