Showing posts with label SQL Server Data Warehousing. Show all posts
Showing posts with label SQL Server Data Warehousing. Show all posts
Friday, June 14, 2013

[SQL Server Data Warehousing] Query Statistics History Report Duration and Execution Time taken

›
Query Statistics History Report Duration and Execution Time taken Hi everyone I have about 4 jobs calling the same stored procedure but eac...

[SQL Server Data Warehousing] Best way to change the datatype of Column of Table

›
Best way to change the datatype of Column of Table Are you allowed any sort of outage on this table?  If so, then consider creating a new ta...
Thursday, June 13, 2013

[SQL Server Data Warehousing] In SSIS package How can we call a Mcro

›
In SSIS package How can we call a Mcro Hi All I have a scenario to call a macro from SSIS  Can any one help me with the steps How to Add the...

[SQL Server Data Warehousing] SSAS Cube not taking the data

›
SSAS Cube not taking the data Please let us know if 1. You are getting any errors 2. How frequently is data updated in your view and for how...

[SQL Server Data Warehousing] Collecting data from multiple sites

›
Collecting data from multiple sites Your question has two different parts; 1- archiving existing databases 2- Integrating ,cleansing, de-dup...

[SQL Server Data Warehousing] Change Data Capture - Pros/Cons/Gotchas

›
Change Data Capture - Pros/Cons/Gotchas My company is thinking of implementing Change Data Capture. I find many online articles, which cover...

[SQL Server Data Warehousing] SCOM & SCCM how it integrates with its SQL database??

›
SCOM & SCCM how it integrates with its SQL database?? Microsoft is conducting an online survey to understand your opinion of the Technet...

[SQL Server Data Warehousing] How do delete a part data from partition

›
How do delete a part data from partition We want to delete data (switch partitions) older than 2006 from a partitioned table. There is 2003,...
Monday, June 10, 2013

[SQL Server Data Warehousing] T-SQL SCD2

›
T-SQL SCD2 Here is the query i am using in case if it helps. To give you little more scenario  on my request  : Our Data warehouse is very t...

[SQL Server Data Warehousing] SSAS Cube not taking the data

›
SSAS Cube not taking the data Please let us know if 1. You are getting any errors 2. How frequently is data updated in your view and for how...

[SQL Server Data Warehousing] Collecting data from multiple sites

›
Collecting data from multiple sites Your question has two different parts; 1- archiving existing databases 2- Integrating ,cleansing, de-dup...

[SQL Server Data Warehousing] Change Data Capture - Pros/Cons/Gotchas

›
Change Data Capture - Pros/Cons/Gotchas My company is thinking of implementing Change Data Capture. I find many online articles, which cover...
Sunday, June 9, 2013

[SQL Server Data Warehousing] DW Newbie Question - Updating fact table when have type 2 dimension

›
DW Newbie Question - Updating fact table when have type 2 dimension I'd suggest instead of updating the fact table and throwing away the...
Saturday, June 8, 2013

[SQL Server Data Warehousing] In SSIS package How can we call a Mcro

›
In SSIS package How can we call a Mcro Hi All I have a scenario to call a macro from SSIS  Can any one help me with the steps How to Add the...
Friday, June 7, 2013

[SQL Server Data Warehousing] T-SQL SCD2

›
T-SQL SCD2 Here is the query i am using in case if it helps. To give you little more scenario  on my request  : Our Data warehouse is very t...

[SQL Server Data Warehousing] SSAS Cube not taking the data

›
SSAS Cube not taking the data Please let us know if 1. You are getting any errors 2. How frequently is data updated in your view and for how...

[SQL Server Data Warehousing] Change Data Capture - Pros/Cons/Gotchas

›
Change Data Capture - Pros/Cons/Gotchas My company is thinking of implementing Change Data Capture. I find many online articles, which cover...

[SQL Server Data Warehousing] Collecting data from multiple sites

›
Collecting data from multiple sites Your question has two different parts; 1- archiving existing databases 2- Integrating ,cleansing, de-dup...
Thursday, June 6, 2013

[SQL Server Data Warehousing] DW Newbie Question - Updating fact table when have type 2 dimension

›
DW Newbie Question - Updating fact table when have type 2 dimension I'd suggest instead of updating the fact table and throwing away the...

[SQL Server Data Warehousing] Hai all,

›
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey...