Viewing 15 posts - 1,276 through 1,290 (of 1,790 total)
Wayne,
Do you have a question to go along with this?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 1:32 pm
Thanks for the update. I was wondering how things went for you and the follow up is appreciated.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 11:22 am
If you are confident that you will have a COMPLETE set of activity types that are going to occur against the database then by all means you could allow the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 10:20 am
Back with a couple of questions then, is the port open that SQL Server is communicating on open to the internet? Typically by default it is closed.
Are you specifying...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 10:13 am
Based on your description of having the app potentially pointing at two servers as you change connection strings the only method of replication would be to enable Merge replication. You...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 9:07 am
There is a great post on your problem exactly here - http://weblogs.asp.net/omarzabir/archive/2007/10/19/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspx
Please reply and comment as to whether it was useful and fit your situation. There are several links there...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 8:37 am
I found the Performance Dashboard reports to be pretty inspiring.
Enjoy.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 8:29 am
Those are the datatypes that would be affected by collation settings. If you select * from sys.types you should see the datatypes represented in the query. You should definitely check...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 8:09 am
Once you change it at the database level you will need to update all the text related columns as they are assigned the database collation and will retain that even...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 8:00 am
Agreed with all the comments. SQL Server 2005 / 2008 are both very capable of handling that and more, the question really has to be "what do you have skills...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 7:03 am
Is the port that SQL Server communicates on open to the internet? If that is the way that you are connecting then that will have to be opened up to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 5:31 am
I haven't looked in a while but I'm pretty sure that Books Online have a pretty good overview and some pretty solid configuration steps. Additionally, it would be good to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 1, 2008 at 7:23 pm
This appears to be a common problem when installing SQL Server on a Read-Only Domain Controller;
From MS
"On a domain controller, the Local Users and Groups tool is not...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 1, 2008 at 5:26 am
Do you have a MAPI profile established on that server with Outlook installed? If not that is the first thing that needs to happen. In that process I alwasy try...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 1, 2008 at 4:59 am
So, there are a couple of ways to do this but first of all, you need to be careful, especially being that you are dealing with production data.
Option 1...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 29, 2008 at 2:15 pm
Viewing 15 posts - 1,276 through 1,290 (of 1,790 total)