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 Server 2000

  • SQL Server: Delete Duplicate Records Except the First Duplicate Record

    Problem: I encountered an interesting problem today. I had a SQL Server table with many records in it that I needed to clean up. Specifically, I needed to find all duplicate records in the table, but keep the first of each of the duplicate records. The table also contained several rows of detail information that…

  • 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…

  • SQL Server: Global Temporary Tables

    Global Temporary tables are defined on creation by adding the double pound sign (##) as a prefix. Unlike temporary tables they are available to all SQL Server sessions until the table is destroyed/the creating session goes out of scope. Global Temporary tables are similar to regular temporary tables in that they exist in tempdb and…