T-SQL Tuesday #25 – T-SQL Tricks
It’s time for T-SQL Tuesday again, and this time Allen White (@SQLRunr | blog) is asking for your tricks. If you...
2011-12-16 (first published: 2011-12-13)
2,753 reads
Blog Posts
View execution plan for a sproc in the wild
Got stored procedure problems? I feel sorry for you son.
Here's a quick query to pull the cached execution plan out...
2011-12-16
1,713 reads
Why Am I Amazed By a 2000 Page Word Doc?
It’s not uncommon to have information shared in a Word doc, but I was surprised recently to open one up...
2011-12-16
736 reads
Why did I start blogging?
This post is in response to #meme15 started by Jason Strate (b|t). Two questions were asked in the first assignment....
2011-12-16
693 reads
#meme15 – Why Do You Blog?
Jason Strate (blog|@StrateSQL) is starting a new blog meme: #meme15. The overall topic of #meme15 will be social networking, obviously...
2011-12-15
622 reads
Execute Permissions
Written by Ian Treasure
Gethyn posted on the use of execute permissions a while ago (db_executor at http://www.gethynellis.com/2010/04/dbexecutor-role.html). Briefly, this approach...
2011-12-15
1,396 reads
How to change the SQL Server service account
It’s easy. First you click here:
Then you find the SQL Server 2008 or 2008 R2 program group
Open those and then...
2011-12-15
21,854 reads
PASS Board of Directors – Who I’m Voting For
I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) to write about the PASS BoD...
2011-12-15
673 reads
PASS Summit 2011 Session Evaluations
Session evaluations from the 2011 PASS Summit have been entered, calculated, and officially released to speakers. While I didn't make...
2011-12-15
1,085 reads
PowerPivot Data Connection Error
PowerPivot report returns the following error from Excel Services:
The data connection uses Windows Authentication and user credentials could not be...
2011-12-15
1,322 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