Dynamically Create Warehouse Dimensions
Here's a data warehouse design pattern to speed up multi-value dimension creation.
2017-11-13
1,287 reads
dimension
Date Calendar
Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
2019-04-15 (first published: 2009-10-06)
15,119 reads
Key column of a dimension in SSAS
When defining the attribute, we always specify the surrogate key as the key column for any attribute. I was just thinking if we could make use of the natural key instead of the surrogate key. i.e., in case of a product attribute, the surrogate key say...
2009-04-23
2,629 reads
RE: Transactional replication. distribution agent failing
As soon as the distribution agent starts delivering all transactions the log will be clearing but the size won't be reduced.
2005-04-01
RE: PLEASE HELP NEEDED? - with a select avg
Here's a shot in the dark:USE NORTHWIND SELECT CustomerID , COUNT(*) No_of_Orders , DATEDIFF(d,MIN(OrderDate), MAX(OrderDate)) TimeSpan , COUNT(*)*1.0 / DATEDIFF(d,MIN(OrderDate), MAX(OrderDate)) DailyOrder FROM Orders WHERE CustomerID = 'ERNSH' AND (OrderDate >='19960717' AND OrderDate <='19960723') GROUP BY CustomerIDBtw, since this is an exercise given to you, don't you think you should find the solution yourself?
2005-02-24
RE: oracle pl/sql
I would post Oracle related questions here http://www.LazyDBA.com . They maintain a mailing list oracledba@lazydba.com which is quite active. Frank http://www.insidesql.de http://www.familienzirkus.de
2003-11-21
1 reads
RE: ADMIN DBA'S HELP
What does your SR DBA think an 'ADMIN DBA' job is? From the title, it almost sounds like this is an 'administrative' job. Documentation type things. -SQLBill
2003-11-19
1 reads
RE: SA do I need to remember the password
I think Microsoft made Great Plains use the SA by design not by default. GP goes into SQLServer as SA and does all kinds of "System Administrator" kind if stuff when setting up users and customizing the application. Its a real pain as the DBA to work with this because the Director of Finance wantes […]
2003-11-14
2003-07-15
3 reads
RE: Software to Compress Large File
We've also been using WinRar, and we are very happy with it. I think the largest files we've done so far 92GB, and it works like a champ. Great interface, great command line features. Also, inexpensive. Shawn Organ
2003-06-27
1 reads
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers