Browse by Tags

Tagged Content List
  • Blog Post: Implementing LOB Storage in Memory Optimized Tables

    Memory optimized tables do not have off-row or large object (LOB) storage, and the row size is limited to 8060 bytes. Thus, storing large binary or character string values can be done in one of two ways: •                    ...
  • 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 (6 items)