Viewing 15 posts - 5,926 through 5,940 (of 11,678 total)
Your question isn't entirely clear for me.
How many servers do you have?
What is the "BI server"?
January 28, 2013 at 5:52 am
Please do not crosspost. It wastes people's time and fragments replies.
Original thread can be found here:
http://www.sqlservercentral.com/Forums/Topic1412112-147-1.aspx
January 28, 2013 at 5:51 am
What exactly are the package tasks?
Does the webapp user have the required privileges to execute the package?
January 28, 2013 at 5:48 am
If you don't have a lot of connections, I would set-up a configuration table and store the username and password there.
That way you won't have to use a password to...
January 28, 2013 at 5:46 am
(condition contains no aggregate functions)
This is very important. Since you specify you can't filter on aggregate values, the HAVING clause acts the same as the WHERE clause. In other words...
January 28, 2013 at 12:58 am
Apparently, there are 4 winter months? 🙂
Anyway, I don't have AdventureWorks 2012 installed on this machine, so I had to guess. Quite a pity, because the idea of the question...
January 28, 2013 at 12:53 am
So you get a csv file with a comma delimiter and a double quote text qualifier. What's the issue with SSIS?
January 25, 2013 at 1:24 pm
purushottam2 (1/25/2013)
Hi Grant,Thanks for your reply,
Surely i will remove coalesce. Should i remove nolock, does it also affect my performance. Performance is our first priority.
NOLOCK will probably enhance performance,...
January 25, 2013 at 6:19 am
paklich (1/25/2013)
http://support.microsoft.com/?id=972498
This was a collation issue, not a low memory issue.
January 25, 2013 at 3:18 am
Bhuvnesh (1/24/2013)
..., CTE is basically used to handle recursive operation not a performance boost alternative to temp table.
CTEs are not always used for recursive operations. You can also just...
January 25, 2013 at 12:54 am
Maybe you can use the ACE OLE DB provider, this one is available in 64-bit.
January 25, 2013 at 12:52 am
Admingod (1/24/2013)
January 25, 2013 at 12:50 am
Didn't know you could install SSMS seperately. Isn't this an express edition?
I always install SSMS using the full SQL Server media.
January 25, 2013 at 12:41 am
I watched Total Recall, and it was OK. Nothing special, but a good night of "popcorn no brain needed" action. I liked the original better though.
My favorite geek movie of...
January 25, 2013 at 12:36 am
Viewing 15 posts - 5,926 through 5,940 (of 11,678 total)