Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2008   (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
Thursday, August 20, 2009 11:23 PM

A Wrapper for Running SQL Server 2008 Reporting Services Reports Anonymously

With SQL Server 2008, Microsoft re-architected SQL Server Reporting Services (SSRS) to no longer have an IIS dependency. It now relies directly on HTTP.SYS and handles web protocols independently. This is a good thing, in a lot of respects (see http://msdn.microsoft.com/en-us/library/bb630410.aspx
Posted by Bob Leithiser | 3 Comments
Attachment(s): ReportsPortal.zip
Saturday, August 15, 2009 4:32 PM

Cautions with Indexed Views

If you’ve been following my blog, you may remember an article I did extolling the virtues of indexed views - http://blogs.msdn.com/microsoftbob/archive/2009/05/13/sql-data-warehousing-tip-2-indexed-views.aspx .  I stand behind that and have found
Posted by Bob Leithiser | 0 Comments
Friday, August 14, 2009 6:16 AM

Some Uses for Query Hints

Some of you are all set to flame me just because of my title. I know because a couple of years back, I would have probably been one of the first to say “NO!”, when anybody started talking about query hints. But, like everything else in this world, they
Posted by Bob Leithiser | 0 Comments
Tuesday, August 04, 2009 1:07 AM

A Generic Interval Range Table to Generate Permutations

In earlier post ( http://blogs.msdn.com/microsoftbob/archive/2009/07/06/generating-a-list-of-calendar-dates.aspx ), I provided an example of how to use a UDF that returns calendar days in order to generate data from a table valued function.  Today,
Posted by Bob Leithiser | 0 Comments
Tuesday, August 04, 2009 12:42 AM

Using NTILE with Cross Reference Values to Create Dimensions

I confess  lack of depth in SQL Analysis Services (SSAS).  I've read quite a bit about the capabilities including data mining, and played with a couple of the wizards, but just haven't had time to immerse deeply into end-to-end scenarios. 
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
Wednesday, June 17, 2009 1:06 AM

Dumping SQL data in pivoted format

Technorati Tags: SQL Server , Tips If you’re like me and spend a lot of time in SQL Query Analyzer, querying data directly, you may find the column display format tedious for tables with lots of columns or where you are only working with a couple of entries
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
Wednesday, June 03, 2009 2:15 PM

The power of bits for historical event analysis

I guess my title sounds more like a subject for an academic paper, which I may actually do in time, but in any case, the use of bitmasks for represent events occurring over a fixed period of time has powerful implications for detailed correlation with
Posted by Bob Leithiser | 0 Comments
Attachment(s): TestBitArray.zip
 
Page view tracker