Viewing 15 posts - 5,221 through 5,235 (of 6,676 total)
Ed Wyant (5/6/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
May 6, 2009 at 10:49 am
No degree - went the Army route instead. Started as a computer operator, moved on to programmer and eventually DBA. I have now been a DBA for more...
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
May 5, 2009 at 9:35 am
SQL Server does not automatically allocate the minimum or maximum memory when it starts. It allocates the memory as it is needed. Once it reaches the minimum amount...
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
May 5, 2009 at 9:19 am
It depends - how much memory does the server have? Is this a single instance server - in other words, are there other SQL Server instances running on this...
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
May 4, 2009 at 1:51 pm
I generally use SET myself - mostly because it prevents issues where you can get the wrong value returned from a SELECT. When using SELECT - if you are...
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
May 4, 2009 at 1:44 pm
Not sure why you are getting these errors - I have no problems running those types of processes using Standard Edition.
Could it be that you don't have the standard version...
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
April 29, 2009 at 4:30 pm
That drop-down works more as an MRU type of list - basically listing the most recently used server connections. There is another tab available on that dialog - select...
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
April 28, 2009 at 8:36 am
I am not sure what the problem is - but when running SQL Server 2005 Standard Edition (x64) there are issues when you have lots of memory.
I know that I...
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
April 27, 2009 at 5:21 pm
Is this SQL Server 2005 Standard edition? If it is, you may need to drop the max memory even more. With 16GB of memory available, you might find...
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
April 27, 2009 at 4:36 pm
I am not sure what you mean - where are you looking for localhost and it is not appearing?
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
April 27, 2009 at 3:44 pm
Matt (4/27/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
April 27, 2009 at 3:42 pm
psangeetha (4/27/2009)
We are having some issues on a few programs that runs a...
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
April 27, 2009 at 3:40 pm
This looks good to me - but, here are the questions I would ask:
1) Is this an upgrade from 2000? If so, have you updated statistics/rebuilt indexes/etc...
2) Is this...
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
April 27, 2009 at 3:20 pm
Steve Jones - Editor (4/27/2009)
Most of the systems I've run were rebooted less than once a quarter, some once a year without issues.
We end up restarted our servers on an...
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
April 27, 2009 at 3:05 pm
Instead of modifying all of the code to use a different linked server - modify the linked server to point to the new instance.
You can't do this through the GUI...
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
April 27, 2009 at 2:59 pm
Viewing 15 posts - 5,221 through 5,235 (of 6,676 total)