Effects of Persisted Columns on Performance
I live for questions. And my favorite questions are the ones where I’m not completely sure of the answer. Those...
2015-05-13 (first published: 2015-05-05)
5,935 reads
I live for questions. And my favorite questions are the ones where I’m not completely sure of the answer. Those...
2015-05-13 (first published: 2015-05-05)
5,935 reads
When delivering a SQL Server Reporting Services (SSRS) solution with lots of subscriptions, it's helpful to also include some utility...
2015-05-05
1,320 reads
HELP! My database is stuck in single user mode!
I answered this twitter post a while back and figured it would...
2015-05-13 (first published: 2015-05-05)
6,183 reads
Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise...
2015-05-05
219 reads
Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise...
2015-05-05
841 reads
Quick, short and sharp blog post for those interested in the latest and greatest that the SQL Server mothership has to offer… It was announced by the Microsoft CEO...
2015-05-05
7 reads
Quick, short and sharp blog post for those interested in the latest and greatest that the SQL Server mothership has...
2015-05-05
552 reads
Couldn't find documentation showing that upgrade from SQL 2014 evaluation version was possible to developer edition. I just successfully converted...
2015-05-04
2,612 reads
In TIP #70 we saw how to find all the running SQL SERVER instance in a network or a machine....
2015-05-04
688 reads
In case you were wondering what happened to the TechEd conferences, Microsoft is now bringing together the best of previously...
2015-05-04
565 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
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