Viewing 15 posts - 5,191 through 5,205 (of 11,676 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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 13, 2013 at 2:18 am
Depends on what you're doing in the package.
Are you running it on the same machine?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 13, 2013 at 12:20 am
I don't think that is possible. Kind of a weird request by the way.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 13, 2013 at 12:14 am
fgrubercpa (8/12/2013)
I don't see that installed anywhere for 2012. Does anyone know if...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 13, 2013 at 12:12 am
Maybe parameter sniffing? I noticed some threads where this was the cause of slow SSRS reports.
T-SQL Best Practices - Parameter Sniffing
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 13, 2013 at 12:04 am
You can't put a space in a date column.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 12, 2013 at 11:58 pm
Easy one thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 12, 2013 at 11:52 pm
Are you sure the reason the report runs so long is the query (data retrievel) and not the generation of the report?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 12, 2013 at 2:51 pm
Viewing 15 posts - 5,191 through 5,205 (of 11,676 total)