Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005   (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
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
Saturday, June 21, 2008 2:59 AM

SQL Server Data Model Monitor Series

Place holder for Data Model Monitor
Posted by Bob Leithiser | 0 Comments
Saturday, June 21, 2008 2:48 AM

SQL Server 2005 High-Availability Options (Distilled)

Have you ever been asked by a high-level architect or CIO what Microsoft's approach is to a given scenario?  If you have, then you know the challenges faced because as you read through MSDN and TechNet and even at the Microsoft.com site level, you
Posted by Bob Leithiser | 0 Comments
Thursday, June 12, 2008 10:32 PM

Creating the Infrastructure for Capturing a Data Model

At this point, all I've given you is a set of tables that can store metadata about database tables and their relationships - they pretty much reflect a subset of what you can get from the system views.  Let's take a look at the process for capturing
Posted by Bob Leithiser | 0 Comments
Attachment(s): EntityTrackerCoreSql.zip
Tuesday, June 10, 2008 12:36 AM

Monitoring Data Model Changes

Have you ever wanted to view how a database model has evolved over time? It's not that hard to setup an infrastructure for supporting this. In this series of articles, I'll go over the process for this. For a jump start on the whole process, I've provided
Posted by Bob Leithiser | 0 Comments
Tuesday, June 10, 2008 12:16 AM

Welcome Back, again...

After a false start a couple months back, I'm determined to get more involved in the community and start blogging daily and not let all the distractions get me away from this. My background includes over 22 years in software development. I am currently
Posted by Bob Leithiser | 0 Comments
 
Page view tracker