|
Is it good, bad, or indifferent to run SQL Server on your webserver?
I'm using Server 2008 and SQL Server 2005, but I don't think that matters to this question.
Started by Lance Fisher on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
When you have your database server running on the web server, if your web server is compromised memory.....
That way you'll save is good.
Say it was best to run them on the same server until it becomes a problem.
|
|
My end users are not able to use autocomplete when they use a web application hosted on a particular server. Autocomplete is usually a client-side setting. My users can use autocomplete when they are on other websites so I think it is a server setting...
Answer Snippets (Read the full thread at serverfault):
Have you looked at web pages/web applications that you are serving to check .
It's possible that the app might use something that's disabled on the server, I suppose from the server side.
Of the server.
|
|
I'm trying to square up licensing, and I'm looking at a few SQL 2008 boxes that are in a cluster and I can not see where it says Enterprise Edition anywhere, even though I know that's what it's running.
I need to figure this out, because I have a few ...
Started by Jim on
, 7 posts
by 6 people.
Answer Snippets (Read the full thread at serverfault):
Version returns the complete description of the SQL Server version that is running, including version be shown when the server is started; for example one of my servers has the entry
2009-05-17 00:00:01.86 spid89 Microsoft....
|
Ask your Facebook Friends
|
When running any kind of server under load there are several resources that one would like to monitor to make sure that the server is healthy. This is specifically true when testing the system under load.
Some examples for this would be CPU utilization...
Started by oneself on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
That last, for that I recommend installing "logwatch" ( Logwatch Website ) on your server which sends you an email it from your server....
I also use Nagios to monitor CPU, Memory, and logged in users (on a VPS or dedicated server).
|
|
I'm having a problem running this query:
DELETE FROM [IRPROD]..[BUDGET_USER].[GL_EXP] WHERE FISCAL_YEAR = 2010
IRPROD is a linked server to an Oracle 10g database. It's linked using the Oracle OleDB provider. There are ~79000 records that need to be deleted...
Started by Clint Davis on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If you send....
This is OleDB provider and Database Bug 5043675: Setting up a linked server works fine to read data, then SQL Server must do a remote scan on the table, which basically retrieves the data and has to one-by-one delete each row.
|
|
I am in the proccess of setting up a few virtual servers and i decided that our active directory server has the most free resources currently but when i started the install it returned a warning saying that it is not a good idea installing vmware server...
Started by Shard on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at serverfault):
If your server only has one NIC you can still use Hyper-V, but note that you won't be able to run the DHCP Server on the server as it won't bindI also think so......
NICs on the DC does not affect any VMs running on it.
|
|
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider...
Started by Carlos Kirkconnell on
, 9 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
I generally always useCan you connect to the SQL Server via Management Studio from a different machine? This might help you narrow down whether it is ....
Since both the web application and sql server are running on the same machine.
|
|
[i meant to ask this question on StackOverflow...]
I have been using VisualSVN Server without any problem on Vista.
When it is time to change everything to Windows 7, I wonder what's the best way to do that?
Is it best to "check in" all the code from ...
Started by Jian Lin on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I have VisualSVN running fine in Win7 as well as tortoise , to do a relocate command on your working ....
Now back to the question.
As a good practice try not to run your source control on the same machine you are working on since are free).
|
|
Is it possible to configure multiple database servers (all hosting the same database) to execute a single query simultaneously?
I'm not asking about executing queries using multiple CPUs simultaneously - I know this it possible.
UPDATE
What I mean is ...
Started by chopeen on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It is possible using distributed queries to run a query that references both Server A and Server B, with each/library/ms191440.aspx
For example, Server A may hold my Customers table and Server B holds my Orders table....
|
|
How do I find what port is my remote SQL Server 2005 running on?
Started by Ajay on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If you Server's Error Log on the....
SQL Server's default port is 1433.
Find out which port SQL Server is running by opening your command prompt: (Start > Run > CMDUnless it's modified, it's the default port 1433.
|
