Microsoft Bob

NOTE: The views expressed on this blog are my own and may not reflect the views of Microsoft
Posts
  • Microsoft Bob

    Using Persisted Computed Columns in SQL Server Indexes

    • 0 Comments
    As part of my research work, I generate thousands of simulations on an almost daily basis for various scenarios.  One of my scenarios involves determining strategies for selecting the most profitable short and long stock entry/exit positions. ...
  • Microsoft Bob

    Auto-Generating Pivot Views

    • 0 Comments
    Coming back from the Sci-Fi world of AI, etc to some real world scenarios...  Earlier I posted a generic stored procedure that automatically unpivots data so that columns become rows.  Today, I provide the inverse capability, although not truly...
  • Microsoft Bob

    Generating a List of Calendar Dates

    • 0 Comments
    For today, here’s a simple trick.  Ever need to get a list of all the calendar dates for a period?  This is very simple using a user defined function with a table.   Below is a simple version.  I have a more complex version I...
Page 1 of 1 (3 items)