TSQL Tuesday #83 – The Stats update solution
TSQL Tuesday is a monthly blog part hosted by a different blogger every month – it was started by Adam Machanic....
2016-10-11
421 reads
9 Amazing features of SQL SERVER 2016
Although, I know I am bit late to share this thing on our blog but it says in Indian proverb...
2016-10-11
712 reads
T-SQL Tuesday #83: Why Leave Well Enough Alone?
It’s 2016. So why are we still dealing with T-SQL code and design patterns that were designed 7 versions ago?
In the 15 years I have been using databases professionally, we’re still...
2016-10-11
12 reads
Implementing Fuzzy Sets in SQL Server, Part 4: From Fuzzy Unions to Fuzzy Logic
By Steve Bolton
…………Fuzzy set relations carry an added layer of complexity not seen in ordinary “crisp” sets, due to the...
2016-10-10
813 reads
SSC Editorial: Does Log Data Belong in a Table or a File?
I think the topic of whether log data belongs in a table or a file would be a great one for...
2016-10-10
397 reads
Migrating Database Collation - The Red Gate Way
I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...
2016-10-10
114 reads
SSC Editorial: A Visit to Microsoft
A Visit to Microsoft was posted back in August and I just re-read it. Here’s a quote that might interest you:
As...
2016-10-10
395 reads
Statistics Are Vital For Query Performance
This is post #10 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
When you send a query to your...
2016-10-19 (first published: 2016-10-10)
2,091 reads
Columnstore Indexes – part 87 (“Indexed Views”)
Continuation from the previous 86 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
A very long time desired feature from...
2016-10-10
508 reads
Special Discount for PASS Summit Precon
I’m very honored to be speaking at the PASS Global Summitagain this year in Seattle during the week of October...
2016-10-14 (first published: 2016-10-10)
759 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers