Skip to content

George Palacios – DBA

Month: July 2019

Categories SQL Server, Useful scripts

How to find SQL Object dependencies

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…

July 19, 2019August 22, 2019
Categories Engine, SQL Server

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…

July 16, 2019August 22, 2019

Recent Posts

  • Living with PTSD
  • EXCEPTION_ACCESS_VIOLATION when working with Availability Groups
  • How to find SQL Object dependencies
  • Should I add the Clustering key to a non-clustered index?

Recent Comments

    Archives

    • March 2021
    • August 2019
    • July 2019

    Categories

    • Engine
    • SQL Server
    • Trouble Shooting
    • Uncategorized
    • Useful scripts

    Meta

    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org

    George Palacios – DBA

    Proudly powered by WordPress | Theme: Yosemite by GretaThemes