Viewing 15 posts - 4,396 through 4,410 (of 6,676 total)
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
November 5, 2009 at 10:30 am
george.greiner (11/4/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 30, 2009 at 5:18 pm
You said it Jason - yep, we are all crazy....:-)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 30, 2009 at 3:07 pm
CirquedeSQLeil (10/30/2009)
SSCrazy = Jeff
How do you know I'm not crazy? :w00t:
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 30, 2009 at 2:57 pm
vision59 (10/29/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 29, 2009 at 8:44 pm
vision59 (10/29/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 29, 2009 at 6:49 pm
Viewing 15 posts - 4,396 through 4,410 (of 6,676 total)