From SQL Server 2008 and onward we gained a new DMV called sys.dm_sql_referenced_entities – this allows us to track object dependencies rather neatly. This covers all dependencies including cross-database and cross-server – it does not however make it easier to find the type of object being referenced (What does OBJECT_OR_COLUMN even mean?). I’ve written the…
Should I add the Clustering key to a non-clustered index?
I was sent a CREATE INDEX script by a third party today – it was non-clustered. Whilst reviewing the index definition I noticed that the…