Viewing 15 posts - 706 through 720 (of 1,241 total)
his part works but everytime I look at all the IFs I get confused so I thought there might be a better way to achive the same result.
Having before and...
----------------------------------------------------
November 27, 2015 at 1:28 pm
You mentioned you have tons of indexes. I hope on of them is a clustered? Lots of indexes ( lets say half the number of columns on the table) can...
----------------------------------------------------
November 25, 2015 at 1:53 pm
As mentioned in the blog, in a DW with over 100 Million rows , most of the queries will end up performing scans
I dont know what qualifies as "most queries."...
----------------------------------------------------
November 25, 2015 at 11:42 am
rjuarez71 (11/24/2015)
Good morning,Just to ADD, I saw that adding
DECLARE x_cursor CURSOR STATIC READ_ONLY FOR ...
Solves the issue
best regards 🙂
From MSDN,
"STATIC
Defines a cursor that makes a...
----------------------------------------------------
November 25, 2015 at 11:00 am
Glad that you were able to get a resolution. Only that uninstalling apps and the pain that goes with all that might get irritating if you run into this situation...
----------------------------------------------------
November 23, 2015 at 12:46 pm
Thanks Ed, I had to look at it for a minute to figure it out. It looks like that single quote is closing the first one in front of ren.....
----------------------------------------------------
November 23, 2015 at 12:21 pm
"export_File_IMG_'
I dont work with this a whole lot so I was wondering if the single quote closing the double quote is valid, or if it is just covering the...
----------------------------------------------------
November 23, 2015 at 11:54 am
Are you referring to exporting the data in a SSRS report to Excel ? OR are you referring to a report subscription ?
Please see if the below link helps...
----------------------------------------------------
November 23, 2015 at 11:49 am
I would approach this by using the SQL in your report (preferably the stored procedure that the report calls).
WITH myTop5 as (
select top 5 customer
from...
----------------------------------------------------
November 23, 2015 at 11:36 am
Typically a SCD type 2 has those validFrom and validTo fields in the dimension table. You can create your DSV by filtering on only those that have the validTo be...
----------------------------------------------------
November 23, 2015 at 10:59 am
Good concept and idea. I had implemented something similar. I am sure we have all seen the choose a month to report from . In these cases I instructions in...
----------------------------------------------------
November 21, 2015 at 5:20 pm
Try to start clean,in these cases. Create a SSRS project named like TempSSRShold for example. Then Right click the Reports node, add > existing item. From here navigate to the...
----------------------------------------------------
November 21, 2015 at 1:46 pm
Just to add a little here, recall that a FACT is just that. It captures something that happened at a point in time. There is really no updating here (unless...
----------------------------------------------------
November 20, 2015 at 6:14 pm
Just start writing, anything, everything and maybe something will catch fire
The problem is once you begin something there is this inertia that keeps you from wanting to go back and...
----------------------------------------------------
November 18, 2015 at 5:37 pm
I agree with the prior posts that the Kimball books outline well the approach to creating a data warehouse from the ground up. Be careful with defining the "grain." Some...
----------------------------------------------------
November 18, 2015 at 5:33 pm
Viewing 15 posts - 706 through 720 (of 1,241 total)