Viewing 15 posts - 3,961 through 3,975 (of 6,676 total)
SQL Server will take all of the memory up to the max memory setting. It does not guarantee that it will take all of it.
If that instance does 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
April 2, 2010 at 5:59 pm
I wouldn't say a default of 80% is good - nor would I say one of 90% or any other value. There are definitely some tables in your system...
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 2, 2010 at 4:10 pm
Mani-584606 (4/1/2010)1. Do we need to required to set the Min memory setting, if we have multiple instances?
It is not required.
2.Three of the instances using Max of allocated memory. i.e...
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 2, 2010 at 3:34 pm
Paul White NZ (4/2/2010)
Jeffrey Williams-493691 (4/2/2010)
Exactly the same reasons I prefer them also. Thanks.Heh, so I passed? 😉 😎
No - more like I passed. Just confirms my own...
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 2, 2010 at 10:50 am
Paul White NZ (4/2/2010)
Jeffrey Williams-493691 (4/2/2010)
I am curious why you prefer this approach over using views.
Synonyms were created to meet exactly the sort of need presented here.
They are easy to...
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 2, 2010 at 9:13 am
Paul White NZ (4/2/2010)
Jeffrey Williams-493691 (3/31/2010)
Using views is one approach - another approach is to use synonyms.
I would tend to prefer the synonym approach - assuming the database in question...
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 2, 2010 at 8:36 am
Using views is one approach - another approach is to use synonyms. For example:
-- First, create a schema for your synonyms. Not necessary, but organizes them for you
CREATE...
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
March 31, 2010 at 2:18 pm
liteswitch (3/30/2010)
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
March 30, 2010 at 7:19 pm
Paul White NZ (3/30/2010)
A view is the definition of a single (restricted) SELECT statement. The definition of the view is expanded into any query it is referenced by...
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
March 30, 2010 at 7:15 pm
Perry Whittle (3/30/2010)
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
March 30, 2010 at 3:20 pm
It is very hard to tell - because the file extension does not tell us what kind of file that is. Is it a SQL Server backup file? ...
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
March 30, 2010 at 3:02 pm
David Portas (3/30/2010)
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
March 30, 2010 at 2:58 pm
Paul White NZ (3/30/2010)
CirquedeSQLeil (3/30/2010)
tosscrosby (3/30/2010)
Paul White NZ (3/30/2010)
WayneS (3/30/2010)
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
March 30, 2010 at 2:15 pm
HowardW (3/30/2010)
Jeffrey Williams-493691 (3/29/2010)
SQL will then automatically create a log file in the default location of the default initial size which you can then move/resize.
Do not do this - unless...
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
March 30, 2010 at 2:13 pm
You can query the backup table in MSDB to get the backup size. The size of the backup will show how much space was being used in the data...
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
March 30, 2010 at 2:02 pm
Viewing 15 posts - 3,961 through 3,975 (of 6,676 total)