5 Performance Killers When Working With Linked Servers
When working with linked servers, the most expensive factor to consider is the amount of data that will have to...
2012-09-08
579 reads
Blog Posts
My Session on Locking Internals Part 1 in CSSUG Meet
Bad weather won't stop hungry minds. Our today’s Chennai SQL Server User Group (CSSUG) meet happened with around 25 enthusiastic SQL Server...
2012-09-08
863 reads
SQL Server Best Practices for DMV's - Houston Tech Fest 2012
It is a pleasure meeting everyone today at Houston Tech Fest! The new facility is miles away - literally and figuratively...
2012-09-08
945 reads
Lost in Translation – Deprecated System Tables – sysdevices
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-09-07
1,175 reads
SQL Saturday 167
SQL Saturday #167 is just hours away. We have worked hard to get everything setup and in place and hope...
2012-09-07
581 reads
SQL Server vs. Oracle
Just so we’re clear, I use SQL Server. I like SQL Server. But, this doesn’t mean I have anything against...
2012-09-07
5,021 reads
The Charles River – SQL in the City Boston
I once rowed in the Head of the Charles Regatta. I had the 3d seat, starboard, in a 4 man...
2012-09-07 (first published: 2012-09-04)
2,242 reads
Azure Virtual Machine TempDb Placement
The recommended location for the tempDb on an Azure virtual machine, is the non-persisted D: drive. This drive is actually...
2012-09-06
2,081 reads
DBCC Cleaning CACHE – Memory
DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know...
2012-09-06
957 reads
Introduction to Windows Azure SQL Database Services (Part 2)
In my last article “Introduction to Windows Azure SQL Database Services (Part 1)“, I’ve provided an overview of Microsoft Windows...
2012-09-06
1,251 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers