Hi Dishdy, the way to specify a plan is quite straightforward: 1. start the profiler 2. run the query in doubt 3. retrieve the query text In my case, I started a "process full" on a partition in my cube. Then, just paste your query in t...

Mike, thanks for jumping in! The query is created by an SQL Server Analysis Services Cube, but it's basically a select {some columns} from {some view} where dataversion>=2012103100 and dataversion < 2012110100 The same query with another d...

Hi, if you have a field named GeoLoc and populate it like this UPDATE Table1 SET [GeoLoc] = geography::Parse('POINT(' + CAST([Longitude] AS VARCHAR(20)) + ' ' + CAST([Latitude] AS VARCHAR(20)) + ')') then you...

Hi,

I have a BI solution that uses a "dataversion" as the primary key for all major tables. A dataversion is an integer that has the format yyyymmddxx, where xx is the number of dataversions for a given date.
My "date" table...

I recently had a strange problem where a SSIS lookup seemed not working. I tracked the problem down to a SELECT statement in the lookup source. The statement looks like this: select ID, cast(somePercentage*10000 as int) as IntNumber from someTable wh...

I recently had a strange problem where a SSIS lookup seemed not working. I tracked the problem down to a SELECT statement in the lookup source. The statement looks like this: `select ID, cast(somePercentage*10000 as int) as IntNumber from someTable`...

<p>Valarmathy,</p> <p>i think you overestimated the use of CTEs a bit.</p> <p>For example, the third cte just UNIONs the first two. This is a case where the direct coding would speed up things.</p> <p>Instead of</p> <p><pre class='brush: sql'></p...

Valarmathy,

i think you overestimated the use of CTEs a bit.

For example, the third cte just UNIONs the first two. This is a case where the direct coding would speed up things.

Instead of

<pre class='brush: sql'>...

Yunus,

the answer to this question depends a lot on your particular situation. If you are running a complex web ab that serves a lot of users (although I wouldn't suspect that from your computer's configuration) and do not need much data, the...

<p>Yunus,</p> <p>the answer to this question depends a lot on your particular situation. If you are running a complex web ab that serves a lot of users (although I wouldn't suspect that from your computer's configuration) and do not need much data, the SQ...