Welcome to MSDN Blogs Sign in | Join | Help

July 2009 - Posts

Friday, July 10, 2009 9:43 PM

Using Persisted Computed Columns in SQL Server Indexes

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. 
Posted by Bob Leithiser | 0 Comments
Friday, July 10, 2009 7:22 PM

Auto-Generating Pivot Views

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
Posted by Bob Leithiser | 0 Comments
Wednesday, July 08, 2009 8:42 PM

Software writing software

My academic research relates to software automation – for me that means code writing code.  Most code generators today are pretty stupid, though.  My hypothesis is basically that software should be able to learn from experience so that it can
Posted by Bob Leithiser | 0 Comments
Monday, July 06, 2009 3:25 AM

Generating a List of Calendar Dates

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
Posted by Bob Leithiser | 0 Comments
 
Page view tracker