SQL Server Data Warehousing

• Adding image from external path in ssrs
• Adventure Works sample DW DB
• Autogrow of file 'Database' in database 'Database' was cancelled by user or timed out after 5800 milliseconds
• Blank value allowed for primary and foreign key?
• CDC column __$update_mask
• Change Data Capture - Pros/Cons/Gotchas
• Change Data Capture on table
• Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'.
• Difference between Data staging and Dimension Table ?
• Dimensional modeling question - order vs order details
• DW Newbie Question - Updating fact table when have type 2 dimension
• ETL - Continue Package Execution After Error in SSIS
• EXTERNAL TABLE access failed because the specified path name '/sascontainer' does not exist. Enter a valid path and try again.
• Fact Tables without Dimension Tables.
• Getting "Lock request time out exceeded" error while dropping table.
• Getting error while getting data from source using ssis data flow task
• How do you handle update and delete rules for fact tables?
• How to capture error messages for BCP when running through XP_CMDSHELL
• How to create dimension and fact tables usinmg SSIS pacakge?
• how to run query without index?
• How to Skip PIPE(comes as data) in PIPE Delimited Flat file?
• In Staging tables, is it a good practice to have primary/foreign keys and is it a good practice to set ALL table columns to Not Null?
• Insert Header and Detail Record in one SQL relational table
• Load Files From SharePoint to SQL Server Table
• Log Flush Waits(waits/s)
• Merging two SCD2 dimension tables into one single SCD2 dimension table
• Normalized (3NF) VS Denormalized(Star Schema) Data warehouse :
• NUMBER SOURCE OF DOCUMENTS POSTED: 0 OUT OF A TOTAL OF 1
• Order sales and shipments
• Performance tune SQL Table with more than 2 billion rows
• Releasing unallocated space from database in best way.
• SSRS - Date Parameter Format
• Time out occurred while waiting for buffer latch -- type 4
• Troubleshooting xp_cmdshell error
• Unspecified Error in SSIS
• What are the main ways to understand why SSRS report takes long time to render?
• What is Business Key?
• what is the difference between primarykey,naturalkey ,candidatekey and Surrogate key with some example
• What purpose does a staging database serve relative to the data warehouse?
• What's the difference between additive, semi-additive, and non-additive measures