Viewing 15 posts - 5,191 through 5,205 (of 11,678 total)
Ville Lucander (8/13/2013)
I must ask the guy where the time is spent if possible to pinpoint that.And the difference is two hours against one minute in this case...
v
Such differences are...
August 13, 2013 at 2:32 am
Ville Lucander (8/13/2013)
But isn't the Sql in the Where sub select only run once before the actual select starts?
It should be, but you can only know for sure by looking...
August 13, 2013 at 2:26 am
When it is run in VS, where does the package spends most of its time? Source, transformation (for example a sort) or the destination?
SSDT is 32-bit, so there might be...
August 13, 2013 at 2:23 am
... why should there be, it is normal sql with no locking issues...
Except for the fact that you are using the F table in the source as well as in...
August 13, 2013 at 2:18 am
Depends on what you're doing in the package.
Are you running it on the same machine?
August 13, 2013 at 2:15 am
SQL Surfer '66 (8/13/2013)
You can still install local help files with Microsoft Help Viewer.Check out http://msdn.microsoft.com/en-us/sqlserver/hh272029 for more information.
Keep in mind that this works only for computers with access to...
August 13, 2013 at 2:03 am
durai nagarajan (8/13/2013)
Oh thanks like older versions i thought it is installed by default.
Nope, they changed it in SQL Server 2012. Probably to preserve space on the installation media and...
August 13, 2013 at 1:13 am
I would first split the data - you can use the function described in this article: Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url] - then join it with...
August 13, 2013 at 12:20 am
I don't think that is possible. Kind of a weird request by the way.
August 13, 2013 at 12:14 am
fgrubercpa (8/12/2013)
I don't see that installed anywhere for 2012. Does anyone know if...
August 13, 2013 at 12:12 am
Maybe parameter sniffing? I noticed some threads where this was the cause of slow SSRS reports.
August 13, 2013 at 12:10 am
fgrubercpa (8/12/2013)
Pulled Up Tablet View (Management Studio displays), right-clicked and clicked option 'open in folder', then I was able to see the program in a folder (which...
August 13, 2013 at 12:04 am
You can't put a space in a date column.
August 12, 2013 at 11:58 pm
Are you sure the reason the report runs so long is the query (data retrievel) and not the generation of the report?
August 12, 2013 at 2:51 pm
Viewing 15 posts - 5,191 through 5,205 (of 11,678 total)