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
-3
votes
2 answers

How do i set the default instance of Microsoft SQL Server?

I have Sql Server 2000 and Sql server 2005 installed on the Server. How do i set the default instance to 2005? On Running this script Select @@Version i get: Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c)…
George
  • 1
  • 1
  • 1
-3
votes
1 answer

How To Change MS SQL 2008 R2 Hostname?

I Installed MS SQL 2008 R2 Express And Plesk 11 MS SQL Hostname is ".\MSSQLSERVER2008" Right Now ! I Want Change it to "localhost" Can U Help Me ?
Mehrpouyan Co.
  • 1
  • 2
-3
votes
1 answer

RazorSQL vs SQL Server Management Studio

I have absolutely no problem connecting to my SQL 2008 database remotely when using RazorSQL. However, I have never been able to connect successfully when I try connecting via SQL Server Management Studio. How can I connect with SQL Server…
peterbata
  • 1
-3
votes
2 answers

MySQL fails once per day. How to change "localhost" to 127.0.0.1

I get a can't connect through this socket once per day. Is this datadir correct?: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock Aborted connection 1270592 to db: 'leechprotect' user: 'leechprotect' host: 'localhost' (Got timeout…
mashup
  • 330
  • 1
  • 14
-4
votes
2 answers

Is RAM size related to SQL performance?

I have some simple code that generates 3 millions insert queries. I have two VPSes, one with 512MB RAM and one with 2GB RAM. On the 512MB RAM VPS, I can insert about 50,000 rows in 5 minutes. On the larger VPS, I can insert 1 million rows in the…
user210461
  • 1
  • 1
-5
votes
2 answers

How to stop/start only SQL Server in Windows 7 when logged in as Limited User

I have an employee working as a data entry operator on Windows 7 PC. I want to create backup of the data and for that I have to stop SQL server while in administrator mode, to move data files to dropbox. my employee cannot able to stop SQL Server…
Fawad
  • 9
  • 2
-6
votes
1 answer

How much a typical web request usage of resources can be?

I have been making my very first web application, and I am using PHP to develop it. I can see my VPS being able to flawlessly handle some decent amount of requests, even though it does few SQL queries on every request I understand this is a very…
OverCoder
  • 143
  • 1
  • 8
-6
votes
1 answer

DB Server and Fully Qualified Domain Name

I have a hosted virtual server (Windows Server 2012 R2) that exists solely to host a few SQL databases. I need to purchase a SSL certificate to encrypt data but purchasing a certificate requires that the server has a fully qualified domain name. …
DBS
  • 1
-6
votes
2 answers

Learning PostgreSQL after using MySQL

I'm looking for a simple resource for getting the hang of Postgres after using MySQL for years. So far I've figured out \l, \d, and \c, but I'm having trouble listing the tables in my MediaWiki installation. The Postgres documentation is great, but…
5ba8cabe450348c7fbe2
  • 1
1 2 3
…
85
86