Dynamically Create Warehouse Dimensions
Here's a data warehouse design pattern to speed up multi-value dimension creation.
2017-11-13
1,166 reads
dimension
Blogs
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Removing ad hoc plans from Query Store
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
Forums
Txn log file is full. Error 9002
Hi All, Here is the scenario on of the test servers. The transaction log...
How to define data types
What are the things you consider when you create a new table and define...
What is the default data-type for columns made from an expression
In Microsoft SQL Server Management Studio 2014, when you execute the following statement: SELECT...
Ask SSC