Return of Index Analysis Part 2
Let’s Anaylze An Index!Time for part two of my continued Index Analysis query. The previous posts in this series are:
Analyze...
2010-10-06
1,048 reads
Speaking Ideas - Plan to End
Over the years I’ve seen probably hundreds of technical presentations. I’ve seen good ones, bad ones, on all sorts of...
2010-10-06
335 reads
Closing Fast – SQLSaturday #49 – Orlando
Well, the event is closing in fast, less than 2 weeks away! We have over 300 registered, a great schedule,...
2010-10-06
547 reads
An Organizer's Recap of SQL Saturday #48 - Columbia, SC
This past Saturday, October 2nd, we hosted Columbia, SC's first ever SQL Saturday. By the feedback we've received, both during...
2010-10-06
823 reads
A Surprising Result from Ident_Current
If you haven’t used it (and I rarely do myself), Ident_Current (‘tablename’) returns the last identity value generated across all...
2010-10-06
991 reads
5-Weeks to PASS Summit 2010 Countdown
With 5-weeks until the PASS Summit it’s time to start getting ready for the event. As I’ve discussed a couple...
2010-10-06
748 reads
Determine if Directory Exists using xp_cmdshell
Recently, I came across a forum post from a user trying to determine if a directory existed in the file...
2010-10-06
14,398 reads
PASSMN Board of Directors Nominations
It’s that time of the year again. Time to get in some nominations for the 2011 PASSMN Board of Directors. ...
2010-10-06
1,105 reads
Tip: OVER and PARTITION BY
Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful…
OVER
OVER allows you...
2010-10-05
2,649 reads
It’s Implied
This has been on my radar now for a little over a week. I ran across a request in the...
2010-10-05
758 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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