Using OVER() to Fix Bad Version Numbers
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,248 reads
attributes
Attribute Discretization: Using the “Equal Areas” Method
Get hands-on exposure to the use of the "Equal Areas" discretization method in Analysis Services. Join BI Architect Bill Pearson as he continues to explore Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.
2009-05-21
1,656 reads
Attribute Member Values in Analysis Services
Learn how the appropriate use of attribute member Value can support the selection and delivery of enterprise data in a more focused and consumer-friendly manner. Join BI Architect Bill Pearson in a hands-on examination of the attribute member Value property and its underlying settings in Analysis Services.
2008-11-14
1,898 reads
Service Pack3 Installation problem
Hi All, I am configuring the sample database of MS Project 2003 on Windows Server 2003. But it gives an error of sql server service pack 3. While i installs the sql server SP3 on windows server 2003 it gives an error meanwhile, when it executes script. Let me know ASAP if anybody knows […]
2004-11-15
RE: database logs
quote: Is there a way to check what happened to a specific database at a particular time? Are there any logs? I got complaints about db hiccups at specific time and lost some records. I dont see any in server logs. Any help greatly appreciated. you may want to put a trace to see what […]
2003-06-18
1 reads
RE: How much do you earn?
I will say less than $60,000 but am looking to fix that. But for my area I am on the 25% portion of the pay scale. I have seen jobs for as much as $130,000 but most want you to know about 40 languages (programming) and be able to walk on water all at a […]
2003-06-18
RE: SQL SERVER STALLED
Changing into Stored Procedure is not a problem,but it is the same query which is going to run in the Server.IS THERE ANY WAY WHERE WE CAN HAVE SIMULTAENOUS QUERIES RUNNING(MULTI THREADING).I mean when i run thsi reconcillation,if a person tries to log in into Application,it doesnt allow and wait until that query gets over.
2003-06-05
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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