Yet one more quick and easy performance tuning setting
I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS...
2015-06-01
634 reads
I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS...
2015-06-01
634 reads
I’m a fixer. A tinkerer. As a kid, I would take my toys apart just to see how they worked,...
2015-06-01
1,552 reads
Found a couple good walkthroughs on enabling instant file initialization. However, I'm becoming more familar with the nuances of various...
2015-06-01
796 reads
User-defined functions encapsulate T-SQL statement and return a table or a scalar value to the caller. UDFs can not be...
2015-06-01
375 reads
2015-05-31
1,253 reads
Hi friends, in this blog we will learn how to get information about database mail account using stored procedure sysmail_hep_account_sp....
2015-05-30
872 reads
Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an...
2015-05-29
16,352 reads
This past Wednesday, I delivered my session, “Query Progress Tracking in SQL Server” to the DBA Virtual Chapter.
The session covers...
2015-05-29
1,419 reads
Reading Time: 4 minutesAre You Running An Antiques Roadshow? In WOxPod!, episode # 005 –...
The post 005 – Antiques Roadshow appeared first...
2015-05-29
1,100 reads
Hi all Yeah its true microsoft announced SQL server 2016 and CP2 has been released to public also we can...
2015-05-29
1,215 reads
Ten years ago, I published a post about filming a Pluralsight Play by Play...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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
Comments posted to this topic are about the item 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