Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql]

Database language for managing data in relational database management systems (RDBMS). Note that each database implements SQL with slight variations. Please remember to tag with your specific database as well, e.g. [mysql], [postgres], [mssql], or [oracle].

An abbreviation of "Structured Query Language," SQL is a database language used to manage data in relational database management systems.

Due to many vendor implementations of SQL (such as T-SQL for SQL Server & Sybase, PL/SQL for Oracle and PostgreSQL and MySQL) it is a fractured language and syntax that works with one vendor may not work with another.

1284 questions
-1
votes
1 answer

Azure Database Permissions

Is it possible to create a Server Login with a Master database user that is able to create a Server Login with a Master database user ? I have not been able to do this, I always need to use the Admin user that was initially created when the server…
Cebben
  • 1
  • 1
  • 2
-1
votes
1 answer

Sql 2008 r2 wildcard certificate

I have installed wildcard certificate in Certificates(Local Computer)\Personal in sql server. We are using Windows 2008R2 server and 2008 R2 SQL. Certificate is issued by StartCom. With certificate everything is ok (I have used it in IIS), but it…
christus
  • 19
  • 1
  • 5
-1
votes
1 answer

Resell SQL Server 2008 Volume Licenses

This may sound like a strange question, but it's incredibly relevant to my company. If it's legit to purchase previously used VL keys for SQL Server 2008 and have them legally transferred over to us through VLSC, that would fill a huge gap for…
user207411
  • 51
  • 4
-1
votes
1 answer

Very Slow SQL Performance on VM rinning 2003 through 2012 r2 host

I have an OLD HP proliant ML350 used as HYBERv Host (win server 2012 - 16 GB RAM , 3x146 GB SAS , one processor). i have a VM (win-server 2003 32bit + sql server 2000) , every thing is working fine with no complains from the users. I decided to…
Anan Zitawi
  • 3
  • 1
  • 3
-1
votes
1 answer

need help scripting website reboot

I have a small website that crashes once or twice a week. I have spoken to both the websites original designers, who has now retired and its host and both blame the other. The website can be recovered by simply renaming a .dll file on the server…
Adam Morley
  • 1
-1
votes
1 answer

Guide to choose which is the best for VM - microsoft or vmware

i am confused between VM Ware and Microsoft Hyper V whic one is the best in terms of all. is there any comparison chart then please let me know. as to run os in vmware need to install esxi; it is same in the microsoft to run hyper v. as i want to…
user188142
  • 1
  • 2
-1
votes
2 answers

Keep Getting an Error When Running My SQL Code

I keep receiving the dreaded "An expression of non-boolean type specified in a context where a condition is expected." errorr at the bolded "dbo.v_R_System.ResourceID" in the code below in the "From' statement section. And I also get the "Incorrect…
The_Ratzenator
  • 150
  • 1
  • 2
  • 12
-1
votes
1 answer

SQL Server 2008 R2 memory consumption for no usage

I have a application that uses SQL Server 2008 R2. I have a problem of memory consumption on the client side. Whenever the client runs the application, the SQL server starts consuming memory even if the client is just on stand by and not using any…
user2640578
  • 1
-1
votes
2 answers

SQL 2012 Server Database Transaction Replication performance issue

We have configured SQL 2012 Server Database Transaction Replication for our client's .NET Web application to distribute SQL transaction and reporting on different SQL servers. We had implemented transaction replication on to SQL-Node1 is working as…
Nirav Patel
  • 1
-1
votes
1 answer

SQL Server 2012 - No connection could be made because the target machine actively refused it

I've searched for the solution for this problem for days now, found a lot of stuff but none of it worked. I've got an SQL Server 2012 running on Windows Server 2012. I'm trying to connect to the SQL Server from a client computer remotely (with…
David Fenko
  • 1
  • 1
  • 1
-1
votes
2 answers

SQL Server account and login permissions for NAS?

We use MS SQL server express 2008 R2 to store data for our application. Recently, we've started storing the databases on a shared NAS drive. Previously, we had the sql server "log in as" built in account: local system - because our database were…
Sugrue
  • 173
  • 1
  • 9
-1
votes
2 answers

The good SQL database to process a lot of data?

I have to process like 10-100 millions records. I have to give the data to the client when it's finish. The data is givent as SQL requests to execute in the database. He have a powerful server with MySQL, I think it will be fast enough. The issue is…
Dorian
  • 103
  • 5
-1
votes
1 answer

Windows Server 2008 R2 Cluster with just two nodes

May be this question was already made, but I dont find an exact answer to my dilema. I have a consulting IT job, my client have only 2 servers (16GB RAM, 2 Xeon 5160 and 500GB HDD) and him want to do a SQL Server R2 failover cluster, the Windows…
ElMangau
  • 31
  • 2
-1
votes
1 answer

Big SQL database platform that performs well

I would like to know your opinion on which DBMS (probably SQL) can perform fairly well and not stress the server too much from the CPU / RAM point of view. I'm used to MySQL but I found (maybe it was a bug of MySQL at the time - about 4 years ago)…
user76949
  • 141
  • 7
-1
votes
3 answers

Server Monitoring Options

I'm trying to find the best way to monitor my MS SQL server. I have been using pingdom for my web server and want to look at something else. I have done a lot of googleing but they all seem to be the same. Was hoping someone could tell me their good…
1ftw1
  • 103
  • 2
1 2 3
…
85 86