Finding the worst running query in a stored procedure
The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something...
2015-09-22 (first published: 2015-09-10)
4,872 reads
Slides for my pass virtualisation virtual chapter talk on how sql fits into a containered world
The slides are up:
https://github.com/GoEddie/SQL-Server-Containers
Any questions shout!
Tags: Sql Serverslides
2015-09-10
431 reads
Slides for my pass virtualisation virtual chapter talk on how sql fits into a containered world
The slides are up:
https://github.com/GoEddie/SQL-Server-Containers
Any questions shout!
2015-09-10
13 reads
Slides for my pass virtualisation virtual chapter talk on how sql fits into a containered world
The slides are up:
https://github.com/GoEddie/SQL-Server-Containers
Any questions shout!
2015-09-10
39 reads
Slides for my pass virtualisation virtual chapter talk on how sql fits into a containered world
The slides are up:
https://github.com/GoEddie/SQL-Server-Containers
Any questions shout!
2015-09-10
8 reads
BI on SQL Azure - Yes you can
Just 4 years before, it was not possible to have end to end Business Intelligence (BI) solution on SQL Azure....
2015-09-10
474 reads
Multi-Cursor Editing SQL feels like the movie Inception just became real
Yes… multicursor editing is epic No… SSMS doesn’t support multi-cursor editing the way it should. Yes… you can do some...
2015-09-10
2,373 reads
Automated Metadata Report for SSAS Tabular
There’s been an excellent free solution for documenting SSAS metadata in multi-dimensional models for quite some time: http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/.
I had the...
2015-09-09
1,294 reads
Multi-Cursor Editing SQL feels like the movie Inception just became real
- Yes… multicursor editing is epic
- No… SSMS doesn’t support multi-cursor editing the way it should.
- Yes… you can do some...
2015-09-09
167 reads
Yes, Foreign Keys Help Performance
I created this example several years ago that illustrates how foreign key constraints can help performance. It’s a contrived example....
2015-09-21 (first published: 2015-09-09)
2,698 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