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

Archives: September 2009

Great Post on Clearing all data from your Data Warehouse

Hey there Gang !

 

 Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting since Jamie is always a great source for SSIS and BI info. I wanted to share a post of his that provides a script method for clearing your… Read more

2 comments, 138 reads

Posted in Adam Jorgensen on 9 September 2009

Books You Should Own

Have you ever wondered where to go to get good information that will help you in your day to day SSAS development life?

 

There are many options from community websites like ssas-info.com, sqlservercentral.com, sql-server-performance.com, and of course Microsoft's TechNet and MSDN sites get better with every release. They… Read more

0 comments, 185 reads

Posted in Adam Jorgensen on 9 September 2009

Importing SQL Server 2008 Analysis Server Database

    Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to create a new project from an existing database either in development or production.

    First - Select to Create a New Project in BIDS (Business Intelligence Development Studio) and Choose the…

Read more

0 comments, 196 reads

Posted in Adam Jorgensen on 8 September 2009

Star Join Optimization in SQL Server 2008

    When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow a "star pattern". This pattern consist of Fact data being retrieved along with it's related dimension data from a start schema. What makes the Star Schema look like a star…

Read more

0 comments, 3,025 reads

Posted in Adam Jorgensen on 8 September 2009

Date Expression Compilation in SSIS

There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted across the web and I use many of them on a regular basis in my coding. It can be difficult however to get a single source for many of these… Read more

3 comments, 1,002 reads

Posted in Adam Jorgensen on 8 September 2009

Smarter Intellisense

    Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I hear from database developers (especially those who have migrated from .NET) is that the intellisense seems to miss some recently created objects. They cry out "My object doesn't appear in…

Read more

0 comments, 534 reads

Posted in Adam Jorgensen on 8 September 2009

Identity Insert Guideline

    Have you ever received the following error when developing your ETL or working with data cleanup?

    Msg 544, Level 16, State 1, Line 1

    Cannot insert explicit value for identity column in table 'tblDemo' when IDENTITY_INSERT is set to OFF.

    This is because the table has a column marked for…

Read more

0 comments, 220 reads

Posted in Adam Jorgensen on 8 September 2009