Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server Performance   (RSS)
Monday, August 24, 2009 4:32 PM

Nested Identity Keys in SQL?

This weekend I played with partitioning.  I have a table with about 10 million rows spanning the last 6 years of stock history for AMEX, NYSE, Indexes, and NASDAQ.   I partitioned each year into a separate filegroup so that should make
Posted by Bob Leithiser | 0 Comments
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
Saturday, June 06, 2009 6:20 AM

Part 2 – Bits for Event Patterns

I promised last time ( http://blogs.msdn.com/microsoftbob/archive/2009/06/03/the-power-of-bits-for-historical-event-analysis.aspx ) that I would follow up with some code to provide a proof of concept for using bit masks for date patterns. I have good
Posted by Bob Leithiser | 0 Comments
Attachment(s): TestBitArray.zip
 
Page view tracker