Viewing 15 posts - 4,606 through 4,620 (of 6,676 total)
Nope - can't suggest anything more than setting the max memory. SQL Server will take the max memory you assign it - and shouldn't take any more than that.
What...
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
August 31, 2009 at 3:24 pm
Do me a favor - lookup REPLACE in Books Online and post what you have tried so far. I am more than willing to help you out, but 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
August 31, 2009 at 3:09 pm
Apurva (8/31/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
August 31, 2009 at 3:06 pm
Timothy.Cloud (8/31/2009)
The application server in question is running HP Support Manager 7.0.
That particular application 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
August 31, 2009 at 2:57 pm
Not sure why you would be worried about that - since you have control over the max memory setting for SQL Server. If you set the max memory -...
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
August 31, 2009 at 2:42 pm
Why are you rebuilding all of the indexes? You should only be rebuilding those indexes that need to be rebuilt, that is - on indexes with greater than 1000...
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
August 31, 2009 at 2:39 pm
In addition to what Gail has stated - remove that maintenance plan that shrinks your databases. You shouldn't be scheduling a shrink of data files (or log files) anyways.
You...
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
August 31, 2009 at 2:23 pm
Nope - no problems. I am currently running Windows 7 x64 - accessing SQL Server 2000/2005/2008 instances running both x64 and x86 with no problems.
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
August 31, 2009 at 2:13 pm
Brad (8/31/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
August 31, 2009 at 1:26 pm
Item 1: Not necessarily...packages can either be stored in the file system (on the SSIS Server), or in a SQL Server store, or in MSDB for a particular instance. ...
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
August 31, 2009 at 12:01 pm
sqlbuddy123 (8/31/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
August 31, 2009 at 9:50 am
Using SSMS to connect to reporting services, the first thing you need to do is select Reporting Services as the type of connection, then type in the instance name you...
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
August 30, 2009 at 10:47 am
Indianrock (8/28/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
August 28, 2009 at 2:13 pm
Thanks Gail - that was what I remember from another article, but couldn't remember the steps to be done.
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
August 27, 2009 at 9:33 am
If this was a copy of a database that was setup with replication - I would bet anything that it still thinks replication is set up.
I believe the process 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
August 27, 2009 at 7:44 am
Viewing 15 posts - 4,606 through 4,620 (of 6,676 total)