In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to craft tests to measure bandwidth and latency for specific...
2015-09-29
30 reads
In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to...
2015-10-07 (first published: 2015-09-29)
7,730 reads
Are your scripts littered with commented blocks of T-SQL code?
select fname,lname
from usertable
where id=1
--and lname like 'smith%'
/*
-- Who knows why...
2015-10-07 (first published: 2015-09-29)
6,374 reads
What’s my share? Calculating percent share of the total is a common need. Let’s see how to calculate this in Power BI...
2015-10-06 (first published: 2015-09-29)
24,964 reads
There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to know where and how to find it. In this...
2015-09-29
10 reads
There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to...
2015-10-08 (first published: 2015-09-29)
1,691 reads
Patching is an activity that is frequently performed by DBA’s. It is the responsibility of a DBA to keep the...
2015-09-29
22,869 reads
Hi all, Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number...
2015-09-28
673 reads
I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow...
2015-09-28
487 reads
I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow...
2015-09-28
879 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item 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