Blog - Title

November, 2011

  • Carl's Blog

    SQL Server Query Performance Analysis using DMVs

    • 4 Comments
    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...
  • Carl's Blog

    Adventures in TSQL: Adding date and time values

    • 2 Comments
    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...
  • Carl's Blog

    Adventures in TSQL: Comma separated string from column values

    • 2 Comments
    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...
  • Carl's Blog

    F# Parallel Execution and Future Tasks

    • 0 Comments
    In a previous post I talked about some options around performing parallel executions by providing some wrappers that allowed a collection of functions to be executed in parallel: http://blogs.msdn.com/b/carlnol/archive/2011/07/17/f-and-running-parallel...
  • Carl's Blog

    F# Dynamic Lookup Operator and Regex

    • 0 Comments
    In a recent post I talked about using String.forall for string matching over the use of Regex: http://blogs.msdn.com/b/carlnol/archive/2011/10/20/f-string-extension-methods-rather-than-using-regex.aspx I do however use Regex a lot for other types of processing...
  • Carl's Blog

    Adventures in TSQL: Using CTEs when performing DELETE/UPDATE operations

    • 0 Comments
    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...
  • Carl's Blog

    Creating a Partitioned View in the BAM Archiving Database

    • 0 Comments
    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...
Page 1 of 1 (7 items)