Viewing 15 posts - 856 through 870 (of 1,248 total)
DonlSimpson (12/2/2014)
Jeff Moden (10/25/2008)
As soon as something needs to "go in in a hurry", all notions of standards and well intended code reviews will go by the wayside.+1
You may even...
----------------------------------------------------
December 2, 2014 at 5:49 pm
I'm assuming you are deleting/archiving based on the date here. I would try to build a clustered index on your table by date if it is not there already. Take...
----------------------------------------------------
December 2, 2014 at 1:50 pm
Hmm, he may be interested in having the time portion to report what time of day he has the most business. In this case it would be ideal/wise to just...
----------------------------------------------------
December 1, 2014 at 8:36 pm
You could schema bind a view to a table , so that the columns the view depends on are not altered until the binding is removed. This would have no...
----------------------------------------------------
December 1, 2014 at 6:33 pm
Be aware to first sort by the actual date field , then your derived time field in the report. Else although your time filed will be ascending, the dates will...
----------------------------------------------------
December 1, 2014 at 12:47 pm
Jeff Moden (11/24/2014)
Sean Lange (11/24/2014)
paul s-306273 (11/24/2014)
Reading 'XYZ', I'm surprised that the use of views is discoraged.
You read that document (which btw is more than 6 years old) and you...
----------------------------------------------------
December 1, 2014 at 12:41 pm
revanappa.shivanagi (11/22/2014)
Thanks!!!. In my project column names of source and destination table are diffrent. So is ther any way to map individual column between source and...
----------------------------------------------------
November 22, 2014 at 1:07 pm
rhythmk (11/18/2014)
Koen Verbeeck (11/18/2014)
Did you try to do a repair of the SSIS installation?Or maybe remove it and install it again.
Not yet Koen.Actually this is PROD server and not maintained...
----------------------------------------------------
November 21, 2014 at 3:25 pm
The reason the dataflow does not work inside a for each loop container, my thinking, is that every column passed through the dataflow data buffers has a unique lineageID. ...
----------------------------------------------------
November 21, 2014 at 12:21 pm
I dont think temporary tables have anything to do with the inability to return results to excel. I dont think you need to avoid them. The final select in the...
----------------------------------------------------
November 19, 2014 at 7:38 pm
iammichaelclark 21625 (11/18/2014)
I am having two columns with the money datatype values.
Column1 Column2
$134,456 $15,897
$123 ...
----------------------------------------------------
November 19, 2014 at 4:48 pm
Eirikur Eiriksson (11/18/2014)
serg-52 (11/18/2014)
kriskumark96 (11/17/2014)
The three queries is of the same tables with different where condition are used , so that we cannot have a join or cross join on...
----------------------------------------------------
November 19, 2014 at 4:17 pm
The first thing that stood at at me was that you want to invest in new infrastructure rather than investigate the cause of report slowness. I do like the idea...
----------------------------------------------------
November 19, 2014 at 2:32 pm
On the SSRS server you can reach the firewall settings through the control panel.
I am curious as to what changed two weeks ago from your post. I would talk...
----------------------------------------------------
November 18, 2014 at 6:14 pm
This might help comparing the versions
http://msdn.microsoft.com/en-us/library/cc645993.aspx
For an older version you could search Ebay though I am not knowledable on the legals of transfering licenses.
----------------------------------------------------
November 18, 2014 at 2:33 pm
Viewing 15 posts - 856 through 870 (of 1,248 total)