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...

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...

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...

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...

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...

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...

Covering Indexes

Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a...

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...

Complete DAX Function Reference

The DAX function documentation in MSDN can be found on separate pages,  organized by function categories and then details for...

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...