Browse by Tags

Tagged Content List
  • Blog Post: SQL Server Query Performance Analysis using DMVs

    Continuing the TSQL theme I thought it would be worthwhile sharing some TSQL scripts that I have been using over the years for tuning SQL Server queries… From the development perspective I often have to perform an analysis of a database application. More often than not this entails looking at a running...
  • Blog Post: Adventures in TSQL: Using CTEs when performing DELETE/UPDATE operations

    It seems in quite a few applications of late there has been the requirement to batch process, in a distinct order, a series of entries from a table; namely a processing queue. Without delving in broker services this is easily managed using standard TSQL. The requirement is to delete a predefined number...
  • Blog Post: Adventures in TSQL: Adding date and time values

    With the addition of the SQL Server date and time types, I have often found myself needing to create a datetime (or datetime2) value based on the addition of a date and a time value. However, there is no built-in function for such an operation. There are a few solutions to this problem that encompass...
  • Blog Post: Adventures in TSQL: Comma separated string from column values

    It seems that several times now I have had the requirement to create a comma separated string from column values. The latest reason for doing this was to build up a list of table column names such that a view could be generated for the table. This is surprisingly easy to do in TSQL. One merely has to...
  • Blog Post: Creating a Partitioned View in the BAM Archiving Database

    When you run the BAM data maintenance package (BAM_DM_ <activity name> ) BAM copies each partition in the BAM Primary Import database to a separate table in the BAM Archive database. You can create partitioned views in the BAM Archive database to facilitate locating the data. However one is left...
Page 1 of 1 (5 items)