Viewing 15 posts - 3,016 through 3,030 (of 6,679 total)
GilaMonster (8/9/2011)
Insert in batches or use an insert method that can be minimally logged (and drop any nonclustered indexes before you start)
Don't drop the nonclustered indexes - disable them instead,...
August 9, 2011 at 2:50 pm
SwePeso (8/8/2011)
The behaviour change is documented here in Books Onlinehttp://msdn.microsoft.com/en-us/library/ms143359(v=SQL.100).aspx
Interesting - thanks for the link.
Another fix on a previously known bug - that will have some people making changes to...
August 8, 2011 at 2:54 pm
If it isn't clear - the reason by your transaction logs are growing is because you are not performing regular transaction log backups.
Sounds like you got in the 'habit' of...
August 8, 2011 at 2:45 pm
Now that this is fixed, you really need to remove that log truncation/shrink process. It is not necessary and is causing more problems than it would ever resolve.
And, please...
August 7, 2011 at 6:57 pm
Gift Peddie (8/7/2011)
August 7, 2011 at 6:48 pm
I was hoping that would lead you to look at how the variable @studentID is defined. Also, I believe you meant to say it is uniqueidentifier.
So, you have 2...
August 7, 2011 at 4:33 pm
Jeff Moden (8/7/2011)
sqlfriends (8/5/2011)
Our production server will be enterprise version
For the license issue, can I just use developer...
August 7, 2011 at 3:03 pm
What is the data type of the identity column on the table you are inserting into?
August 7, 2011 at 2:40 pm
I have absolutely no idea what you are talking about - nor do I think you do.
Care to explain in further detail how your environment differs from most normal installations...
August 7, 2011 at 2:32 pm
Gift Peddie (8/7/2011)
The only time you need to have the agent service account as part of the local administrators group is IF YOU REQUIRE the autostart functionality to be enabled....
August 7, 2011 at 11:45 am
Gift Peddie (8/7/2011)
August 7, 2011 at 11:17 am
I am biased towards SSIS also...found I can get much better performance and manage space using SSIS much easier than using linked servers.
That is the other thing I forgot to...
August 6, 2011 at 7:51 pm
I will second the SSIS option - it will perform better than using linked servers to update and won't require pulling the data across the linked server to a temp...
August 6, 2011 at 1:23 pm
You have to manually update the table - the table you want is the sysdtspackages90 table in the msdb database. Set the ownersid column to 0x1 (sa) for package...
August 6, 2011 at 1:20 pm
shaka.hi (8/5/2011)
Thank you..I just thought it was bit conicidental that the file is resized to almost exactly the same size as the original.
Check the autogrowth setting - the space you...
August 6, 2011 at 1:11 pm
Viewing 15 posts - 3,016 through 3,030 (of 6,679 total)