Find duplicate indexes in SSDT
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Duplicate indexes, one of the most pointless things you can do to a table...
2015-11-27
214 reads
SQL Server – DROP IF EXISTS in SQL Server 2016
Hi friends, in SQL Server 2016 to check the existence of the object a new optional clause IF EXISTS gets...
2015-11-27
1,142 reads
Value can not be null Parameter Name:store TFS WorkItem Store Error
Error HRESULT E_FAIL has been returned from a call to a COM component.
Description:
System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned...
2015-11-26
1,417 reads
UK Contractors – As you were, for now at least
I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn financial statement to parliament. For the past few weeks...
2015-11-26
19 reads
UK Contractors - As you were, for now at least
I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn...
2015-11-26
450 reads
UK Contractors - As you were, for now at least
I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn...
2015-11-26
913 reads
Covering Indexes
Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a...
2015-12-03 (first published: 2015-11-26)
3,308 reads
Steps to create SQL database at Azure
Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into...
2015-11-26
878 reads
Complete DAX Function Reference
The DAX function documentation in MSDN can be found on separate pages, organized by function categories and then details for...
2015-11-26
1,036 reads
Convert select statements in scripts into Inline-TVF's automatically
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
In-line TVF's are awesome, they are a great way to reuse T-SQL code without the...
2015-11-25
900 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
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