This is post #9 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
You get one clustered index per table.
That...
2016-09-19 (first published: 2016-09-12)
2,515 reads
Bottlenecks in your testing tools, infrastructure, or methodology might just hurt your load test results, and the results can skew...
2016-09-16 (first published: 2016-09-12)
1,326 reads
As regular readers of the blog will be aware, over the summer of 2016 here at gethynellis.com we have teamed...
2016-09-12
358 reads
When you look in msdb for the SQL Agent Job duration you will find that it is an int.
This is...
2016-09-15 (first published: 2016-09-12)
1,498 reads
This is post going to be more like a list of question for self assessment. So I will not be...
2016-09-12
60 reads
This is post going to be more like a list of question for self assessment. So I will not be...
2016-09-12
254 reads
It is really easy getting insight into Query performance within your Azure SQL DB. I think Microsoft have done a...
2016-09-12
770 reads
Like every years before PASS summit, this years also SQLpass has 24 hrs sessions… it has great sessions every time,...
2016-09-12
379 reads
Its not a big secret that Microsoft Data Platform community in Portugal has not stopped its expansion – we are trying...
2016-09-11
437 reads
Edit (11-Sep-2016) See comment that pricing tiers have been adjusted since this blog post I’ve been aware of Pluralsight for a couple of years and as I’m always looking...
2016-09-11
65 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