Calculate table size with existing data
Calculate the physical size of a SQL Server database table (data and indexes) , if rows exist . These steps present a...
2011-08-16
1,012 reads
Blog Posts
Compiles and recompiles
I want to spend some time over the next few months looking at query compilation and the plan cache, and...
2011-08-16
3,819 reads
Going Big with SSDs
Nimbus Data just sold 100TB of SSDs to eBay
I found a report recently that eBay had implemented 100TB of SSD storage from Nimbus...
2011-08-16
935 reads
Splitting ID’s with commas, updating them, and then Slamming them back together
Unfortunately my company still uses
MS Access DBs. That's Access 97 folks! I've battled many challenges over the
last couple months with...
2011-08-16
1,258 reads
SQL MCM Training – Day 8
Today Paul talked the whole day about HA DR Strategies and Backup/Restore operations.
I've already known a lot about Backup/Restores, but...
2011-08-16
752 reads
SQL Server 2008 R2 SP1 Cumulative Update 2
Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 2, which is Build 10.50.2772.0. I count 14 fixes in...
2011-08-16
1,517 reads
SSIS - Inferred Member Insert in Fact Table Load
Recently while working on a different solution for loading inferred member solution in our fact table load I ran into...
2011-08-16
2,953 reads
Steel City SQL User Group
Tonight I will be doing a presentation on TEMPDB to the Steel City SQL Users Group in Birmingham AL. I...
2011-08-16
551 reads
Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do...
2011-08-16
2,122 reads
Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do that might involve Oracle. I have never put...
2011-08-16
14 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
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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