Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLRunner

This blog is syndicated from SSIS - SQL Server Tidbits(http://www.josefrichberg.com/)

Archives: March 2010

Indexed Views

Views are used quite often within SQL Server for a number of reasons.  They can be used to restrict access to tables (restrict the columns viewable or the records returned) , combine multiple tables into a single 'virtual table', or apply specific sets of formulas(like avg cost or an item).… Read more

0 comments, 173 reads

Posted in SQLRunner on 26 March 2010

Simple Series : SSIS Conditional Split

Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream altogether.  I use this component quite often in my SSIS packages.  In the industry I work in, publishing, there are many times we'll get a file in from…

Read more

0 comments, 423 reads

Posted in SQLRunner on 26 March 2010

Simple Series : SSIS Conditional Split

Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream altogether.  I use this component quite often in my SSIS packages.  In the industry I work in, publishing, there are many times we'll get a file in from…

Read more

1 comments, 497 reads

Posted in SQLRunner on 25 March 2010

Virtual Presentation : Index Statistics

I just gave a virtual presentation, courtesy of Pass and the appdev group.  The recorded presentation is available here:

Recorded Presentation

 

A copy of the slide deck is available in the download section:

Index Statistics

 

  Read more

0 comments, 226 reads

Posted in SQLRunner on 23 March 2010

Business needs vs dirty reads

I have worked in many industries, but most of my time has been in the publishing industry.  For those not familiar with this industry it is rather interesting.  The main objective is to "sell" as many books as possible to as many retailers and distributors as possible.  I put sell… Read more

0 comments, 116 reads

Posted in SQLRunner on 12 March 2010