Viewing 15 posts - 4,201 through 4,215 (of 6,676 total)
Why did you change the memory per query option? That generally does not need to be changed and should be left at the default value.
On x86 systems, task manager...
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
January 31, 2010 at 11:00 pm
Mani-584606 (1/31/2010)
how to find if the statistics are out of date? As our indexes are not getting fragmented, so I'm planning to run update statistics to keep the statistics...
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
January 31, 2010 at 12:31 pm
Mani-584606 (1/31/2010)
thanks Jefferey,Here I considered the page_count>1000. Is that right criteria to consider for finding Index fragmentation that are only having page count>1000?
thanks again
The classic answer applies here - it...
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
January 31, 2010 at 12:26 pm
Okay - you do not need to rebuild every index, just those indexes that are fragmented. Using any one of the scripts available to identify and rebuild or reorganize...
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
January 31, 2010 at 11:21 am
Are you really concerned about having a 15GB log file? How large is this database and how large do you expect it to get?
Having a large transaction log 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
January 31, 2010 at 10:21 am
tjp8 (1/22/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
January 31, 2010 at 10:14 am
Drop the min memory value - leave the max where it 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
January 30, 2010 at 5:53 am
This will generally happen when the client tools have not been upgraded to at least the same version as the server you are connecting to.
Validate your clients tools have been...
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
January 29, 2010 at 3:35 pm
Steve Jones - Editor (1/29/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
January 29, 2010 at 3:31 pm
You should not set the min memory equal to the max memory. This prevents SQL Server from managing memory correctly and can cause some problems (as you are seeing).
Drop...
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
January 29, 2010 at 3:14 pm
Roy Ernest (1/29/2010)
"Slap myself in on my forehead" Forgot that you cannot connect from SSMS 2005 to SQL 2008 DB
Well Roy - you might want to slap yourself a bit...
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
January 29, 2010 at 1:04 pm
I have found that the easiest way to do this is to use a comparison tool like Redgate SQL Compare. To use the tool you do the following:
1) 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
January 29, 2010 at 12:54 pm
Review this thread: http://www.sqlservercentral.com/Forums/Topic561810-5-1.aspx
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
January 28, 2010 at 6:31 pm
From SSMS 2008 and above:
1) Create a group in Registered Servers
2) Register the servers into this group that you want to work with
3) Right-click the group, select New Query
4) Run...
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
January 28, 2010 at 5:30 pm
Create a new Integration Services project in BIDS. Right-click on the SSIS Packages folder and Add Existing Package.
In the dialog box, select the correct package location, the server and...
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
January 28, 2010 at 4:53 pm
Viewing 15 posts - 4,201 through 4,215 (of 6,676 total)