Viewing 15 posts - 4,396 through 4,410 (of 6,679 total)
Here is the process I use:
1) Create maintenance plan in SSMS as template. Create all sub-plans, tasks, etc...
2) Open BIDS and create new SSIS package
3) Add Existing Items to...
November 9, 2009 at 2:21 pm
SQLNewbie-610691 (11/9/2009)
How do you setup to delete .BAK file...
November 9, 2009 at 11:58 am
When you looked at the maintenance plan history - which task failed? What was the error message for the task that failed?
November 7, 2009 at 8:40 am
When you setup the dataset - you have two values returned from the query. The first will be the label (what the user sees) and the second will be...
November 6, 2009 at 7:23 pm
As everyone else has already stated - this is a known situation. Sub-queries have access to all of the columns from the tables in the outer query where the...
November 6, 2009 at 12:02 pm
Yes, you are going to have to format it in your dataset. Additionally, you are going to have to include the numeric month to order the dataset - or...
November 6, 2009 at 11:51 am
On this box that peaks at 8GB - do you have AWE enabled for SQL Server? I am assuming this is a 32bit machine. If you do not...
November 6, 2009 at 11:15 am
andy russell (11/5/2009)
Why would you not page because you had 32 GB of RAM?
SQL Server should not be paging at all - if it is, you have problems that need...
November 5, 2009 at 10:30 am
george.greiner (11/4/2009)
November 4, 2009 at 8:03 pm
With SQL Server 2005 and greater - changing the service account using the Configuration Management tool will add that user to the appropriate Windows Groups on that system. If...
November 4, 2009 at 1:54 pm
Okay, if I have read this correctly you have two issues you want help with:
1) Transaction Log is growing when performing a delete operation
2) Memory issues when running same delete
For...
November 1, 2009 at 10:19 am
For more specific error messages, view the history for the maintenance plan instead of the logs. I don't find the logs useful at all.
I suspect that your problem is...
November 1, 2009 at 10:11 am
Pedro,
You cannot setup separate filegroups for full recovery model or simple. The recovery model is defined at the database level. If the database is set to full recovery...
October 30, 2009 at 5:31 pm
rew-370421 (10/30/2009)
Correct. At least now I now that we have to buy separate software because there is one for 32-bit and one for 64-bit!
No - you don't have to buy...
October 30, 2009 at 5:18 pm
Viewing 15 posts - 4,396 through 4,410 (of 6,679 total)