Justin Cooney

Web Development Tips and Examples

recent posts

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Category: SQL

  • SQL Server: Query All Clustered & NonClustered Indexes

    A great way to review all of the Clustered and NonClustered Indexes set up for a particular database is to query the SQL Server system tables. The sys.tables table contains the full list of tables for your database, and the sys.indexes table contains the full list of indexes. Simply join the two on their object_id…

  • SQL Server: How to List the Full Properties of all Linked Servers

    What is the best way to see the full properties of all of the Linked Servers in SQL Server in one go? A SQL query is naturally the best way using SQL Server’s system tables! UI-Based Solutions: The properties view in the SSMS UI does not show sufficient information about the set-up and history of…

  • SQL Server: How to Query Version and Server Information

    There are three commands that can be used in SQL Server to query version information or information about the server hosting SQL Server. These commands can be run in SSMS directly, or can be used in code, for example to tailor queries for a particular database version. The commands are xp_msver, @@Version, and sp_server_info. I…