Viewing 15 posts - 1,246 through 1,260 (of 1,291 total)
How large is the Database and How long is the Job taking to run? Any Idea ?
October 22, 2009 at 8:40 pm
As, mentioned earlier by others, what is the Query Execution Plan displaying ???
and also how many Records exist in the Base tables and do you have Index on the columns...
October 22, 2009 at 8:37 pm
Use DBCC SHRINKDATABASE Command.
Follow the Link on Microsoft http://support.microsoft.com/kb/307487
October 22, 2009 at 8:30 pm
Can somebody help me?
I have two difference Server Machine, i want replication .....
But can't running...
Please help me...
Thanks
It seems to be you are in a hurry !!!
But Can't understand...
October 22, 2009 at 8:23 pm
This is for improvising your thoughts on implementing.
try enabling checkpoints so that you would also have a way to restart the Package executions
from the point of failure instead of restarting...
October 21, 2009 at 7:08 pm
Sorry forgot to answer about NON-DBA to be able to doing it.
If you edit your package and incorporate this logging you need not do anything, as the SSIS Packages execute...
October 21, 2009 at 7:02 pm
Open/Edit your SSIS Package,
Right click in the Control Flow in the Design Mode and select Logging.
You need to enable logging at the Package Level.
See the attached Screen Shots.
October 21, 2009 at 7:00 pm
Shrink/truncate every 30 minutes seems like overkill. It took 6 months to get to 124GB, wouldn't a daily process be sufficient? Or is simple recovery sufficient enough?
If you...
October 21, 2009 at 6:36 pm
You must be having an Idea what is that you are trying to achieving by setting up the test Server.
It's a general rule of thumb that your test Server is...
October 21, 2009 at 6:23 pm
Hey Jason,
After seeing your post, I tested and it was working perfectly fine (on 32 Bit Servers)
My setup was Enterprise Edition was Publisher and Subscriber and Standard Edition was the...
October 21, 2009 at 5:49 pm
October 21, 2009 at 7:54 am
Looking at your posts for the past week or so one thing I found is it looks like you are preparing in SQL Server seriously and posting the questions that...
October 21, 2009 at 7:28 am
Obviously when you get backup and try to restore in the same SQL Instance, this error would occur, I thought you would have been aware of this. When...
October 21, 2009 at 7:19 am
When you overwrite the existing Database, you do not need to worry about creating the new Filegroups in the database2, it will be written by the new backup of the...
October 20, 2009 at 8:14 pm
Yeah I found it on the web.
I need to enable the trace flag 3226.
Thanks Sugesh for the Blog
http://sugeshkr.blogspot.com/2009/01/introduction-to-sql-server-trace-flags_14.html
October 20, 2009 at 10:32 am
Viewing 15 posts - 1,246 through 1,260 (of 1,291 total)