I have a few tables which are used in a view (SQL 2012), but the query takes far too long to run and I am looking at suggestions
to improve performance. I do howevver know that clear bottleneck is the following join..
LEFT JOIN dbo.ToneDictionary D
ON CHARINDEX(Dictionary,Title) > 0
The...
Hi,
I need to distribute an SSIS package to another person to use in a demo, but it is very important that I retain the IP, so must only provide him the ability to run the package, and disable the ability to open, view or modify the package. But I am not sure how to achieve this. It seems that...
Using a Twitter Tweet loaded to a SQL table as an example, how would I create new columns to show # and @ string parts. For example the column called 'Tweet' contains 'Our home @pmanfoggers #home #house #garden #adelaide #southaustralia #building #brick #bricklove... http://t.co/YkaHqYg6 <via...
Hi,
I have a measure I want to shown ONLY at a certain scope. But cant seem to get this to work. The measure aggregation type is set to None, as to show nulls when analysed normally.
But in MDX the measure is set to aggregation using a scope (which specifies the ONLY intersection where the user...
Hi,
I think this is quite unique, but there is hopefully a way to achieve this.
My data has 2 identifyers and 3 values:
state city value1 value2 value3
SA Adealide 100 50 60
SA Port Adl 20 50 20
WA Perth 15 20 10
WA...
Hi,
We want to deploy a BI solution and have 3 environments:
A large database server (DB Server), a SharePoint environment (MOSS2007) and another unused server (Additional). Looking for some guidance/ validation:
Current:
DB Server - SQL Server databases including the data warehouse, MOSS2007...
Thanks for all the responses.
I do normally steer clear of dynamic SQL. So I did end up following George's route, which is good to see validated by him.
Etienne
EO
Hertfordshire, England
Hi,
I am writing a function. The function is based on a single table with 10 datetime columns. Lets call then DataTime1, DateTime2, ..., DateTime10.
The user will decide at runtime which Column to return, so I thought of parameterising the function to allow the user to select between...
Hi,
Technologies - SQL Server 2008 R2, MOSS2007, and Office 2007
I have a set of SharePoint lists which I would like to expose to a variety of reporting technologies (SSAS, SSRS, etc).
I am constrained with out of the box functionality, so custom solutions or third party options is not a...
Hi,
I know this is like saying how long is a piece of string, but I need to advise (just as a starting point) for the provision of SQL Server 2008 r2 clustering/ HA solution to the business.
There are three geographical locations. The topology broadly:
• The client side
• Data centre A – Here...
Hi,
SSAS 2008. I am trying to use currentmember properties on a dimension attribute value as a calculated measure. The dimension has (amongst other) two attributes. Balance and Status. Balance is a value that could have been in a fact table, but is in the dimension due to many other reasons I...
Hi,
I have a task table, which contains Task Start Date, Task Due Date and Task Completed Date. I want to use this information to calculate a variety of things.
I created a degenerate dimension from the FACT_Task table called TimeTransactionTask with the three datetime fields as dimension...
And just to add, a postcode could have two, or one start alphas. So it could be WD11 3RU, or E1 2NY. So I need something to calculate when the first numeric from left to right occurs, and then to use RTrip to cut all the characters off from that point onwards.
Dunno how to est when the first...
I have played around with CharIndex, but cannot get this to work. I need to convert full UK postcodes from (example WD11 3RU to WD. I.e. drop any numeric or character to the right of the first numeric.
Any ideas?
EO
Hertfordshire, England
I am actually looking for a calculated measure. So I have used what you said and tried
CREATE MEMBER CURRENTCUBE.[Measures].[LoanRequested]
AS
SUM({[DateAsAt].[HierarchyDateAsAt].[DayNumber].FIRSTCHILD:[DateAsAt].[HierarchyDateAsAt].[DayNumber].CurrentMember}
, [Measures].[Loan...
Hi,
SSAS 2008.
SQL Server 2008 Standard Edition
I have two measure types in my cube, standard sum aggregated measures (which are baased over deltas/ changes from one day to another), and semi additive.
The semi-additive have been implemented succesfully (using MDX calc measures) and so has the...
SQL Server 2008 (Std)
I have a SP, but the data generated will ignore where no transactions have occurred. For example the first dataset is grouped in the second, and you can see April 2010 obviously ommitted as there where now data in April 2010:
Dataset 1:
TransDate Amount
01/01/2010...
@George - the DIM_CO_Account_SSK and TransactionDate_DATETIME is most likely unique and logic for creating @StatusAccount is
DECLARE @StatusAccount TABLE (
StatusTo_DWSK uniqueidentifier null
,StatusFrom_DWSK uniqueidentifier null
,DIM_CO_Account_DWSK uniqueidentifier null
,DIM_CO_Account_SSK...
SQL Server 2008
Hi
I created a query that returns the earliest record in a group, and links it as a new field back to the orig dataset, but it behaves very badly. Is there a more optimal version of such a query?
select a.UnifiedAcctApplNumber
,a.DIM_CO_Account_SSK
,a.StatusTo...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.