SQL Server – Cleaning Procedure Cache for a particular database
HI friends, most of the time we used DBCC FREEPROCCACHE to clear the procedure cache, clears the specific plan from...
2016-05-11
579 reads
Azure DocumentDB – Preparing, Loading and Querying Data
[read this post on Mr. Fox SQL blog] Recently I have been using Azure DocumentDB (aka CosmosDB) to validate several business use cases for a variety of application purposes. For those SQL DBA’s...
2016-05-10
21 reads
Azure DocumentDB – Preparing, Loading and Querying Data
[read this post on Mr. Fox SQL blog]
Recently I have been using Azure DocumentDB (aka CosmosDB) to validate several business use cases for a...
2016-05-17 (first published: 2016-05-10)
3,134 reads
Minimum Memory Grant Query Hint
This month Wendy Pastrick is the host for T-SQL Tuesday #78. This month we have to “learn something new and blog...
2016-05-19 (first published: 2016-05-10)
3,503 reads
Virtual SQL Servers, Actual Performance – PASS Virtualization VC Presentation
Tomorrow I’ll be presenting a new session for the PASSVirtualization Virtual Chapter called “Virtual SQL Servers, Actual Performance” tomorrow at...
2016-05-10
569 reads
Power BI Takeover–Webinar Recording and Q&A
Last week I did a little experimental webinar that was outside our (Pragmatic Works) norm. Instead of our traditional 1...
2016-05-19 (first published: 2016-05-10)
2,353 reads
Data Compression in SQL Server – Pros and Cons
SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU...
2016-05-10
45 reads
Getting your Cloud on
One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that...
2016-05-10
503 reads
Wait Types and Latch Classes Library
Great news from SQLSkills.”Announcing the comprehensive SQL Server Wait Types and Latch Classes Library” – Paul S. Randal http://www.sqlskills.com/blogs/paul/announcing-the-comprehensive-sql-server-wait-types-and-latch-classes-library/ It has...
2016-05-10
290 reads
A Day In The Life of a SQLBits Volunteer
So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over...
2016-05-10
665 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