Viewing 15 posts - 691 through 705 (of 1,229 total)
It looks like that Left Join is essentially an inner join... you are filtering the results back down AFTER you are first putting together the bigger recordset. Make this
tbl_documents...
November 27, 2015 at 4:41 pm
So you are able to change the index on the table and not a query? If you knew for a fact that changing the query will not break anything else...
November 27, 2015 at 4:17 pm
siugoalie78 (11/25/2015)
November 27, 2015 at 3:04 pm
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
Viewing 15 posts - 691 through 705 (of 1,229 total)