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
4
votes
1 answer

SQL Azure insert query ten times slower on V12 than V11?

I noticed performance degradation about two weeks ago impacting one of our applications with an SQL Azure backend. It's running on V12 on tier S1 90% of the time, sometimes scaling to S2, S3 or P1. Basically i was experiencing significantly slower…
enter.net
  • 51
  • 5
4
votes
4 answers

A good hostname convention for few servers with many different services?

I am looking at setting up a hostname convention for our servers based on the service they provide, such as http, https, smtp, pop, dns, sql, etc. Each service is on its own virtual machines on a Xen host server (dom0), for which there are multiple…
ryanklein
  • 53
  • 1
  • 5
4
votes
1 answer

How to find out who / what is hammering SQL Server TempDB

I am using SQL Server 2012 Enterprise. The server has one availability group configured. There are several databases for different tools on the instance. The tools all belong together and therefore were rolled out togehter. I recognized a rise in…
Tobi DM
  • 53
  • 1
  • 4
4
votes
1 answer

SQL Server 2008 Restored Database allows differential backup when no full exists

I restored a backup file (it's used as a template for new databases) as a new database. Normally as part of this process, I take a full backup after the restore, but this time I was called away on another issue before I could do that and in the…
Eyespi20
  • 41
  • 2
4
votes
1 answer

Update SQL Service Pack Named Instance

I have an existing SQL 2008 R2 on SP3. Have another instance in use that is SQL 2008 R2 SP1 I need to update the named instance with sp1 to sp3 but i'm not getting any options. It tells me my version is sp3 which for the named instance is not…
Tsukasa
  • 303
  • 1
  • 4
  • 13
4
votes
1 answer

Intermittent Error SQL Server Error 67 and 17

We are running Windows SQL Server 2012 Standard on Windows Server 2012. There is a SQL Database with an Access Front End which we migrated from older versions of Access and SQL. The Access front end communicates with the database most of the time…
CebicIT
  • 41
  • 1
  • 1
  • 4
4
votes
5 answers

Microsoft SQL Server dump utility

I have a need to dump a fairly significant number of Microsoft SQL Server databases to .sql files. I have a Unix background, and am used to using tools like mysqldump and pg_dump for MySQL and PostgreSQL respectively. Is there an equivalent program…
Duel
4
votes
2 answers

SQL Clustering or Hyper V Clustering

We will soon be implementing our Dynamics AX installation. Our aim is to have high availability and we are working closely with our implementers. We raised the question to them about SQL and Hyper-V Clustering. They recommended that when running in…
dqnet
  • 305
  • 2
  • 9
4
votes
2 answers

How to allow domain groups access to SQL server?

I'm sure this is a simple problem, bu I've looked for days... I have a SQL server that is part of a domain. The domain has many many users. I want to allow select permissions to anyone within a particular group on the domain. Right now I have to…
stuck
  • 687
  • 2
  • 10
  • 23
4
votes
2 answers

Can't restore SQL 2008 backup - error that the database is in use but it isn't

I am trying to restore a SQL Server 2008 backup and am getting the following error: RESTORE cannot process database because it is in use by this session. ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: RESTORE cannot process database…
aSkywalker
  • 555
  • 3
  • 9
  • 15
4
votes
1 answer

Ran out of disk space, how to tar without creating copy

I am at 98% of an 8GB SSD, and I have a 3 GB mysql data that I need to gzip and or tar and then download it, so then I can delete it. How can I tar or gzip the sql (or the mysql tables) so that that I don't have to make a copy of the 3GB file and…
ParoX
  • 302
  • 1
  • 7
  • 21
4
votes
2 answers

sql server trusted connection with windows 8 microsoft account

We have a few developers that work, connecting in through a VPN for access to the development SQL Server 2012. Historically they've used Win7 machines and develop the website against this database in Visual Studio, using the built-in webserver for…
Kurt Koller
  • 141
  • 4
4
votes
2 answers

Is it possible to exploit a sql injection vulnerability with a select only permission, if I knew admin credentials?

A friend pointed out a sql injection vulnerability one an application I work with. This search parameter: '; exec xp_cmdshell 'dir'; -- Returned the message: The EXECUTE permission was denied on the object 'xp_cmdshell', database…
asawyer
  • 151
  • 4
4
votes
1 answer

ERROR 1 (HY000): Can't create/write to file (Error code :13)

Iam trying to create a mysql table in linux with changing data directory to another location. The selected forlder having full permission. But I got an error 'Can't create/write to file'. I googled and found that this error related to permission…
Haseena
  • 151
  • 1
  • 1
  • 5
4
votes
1 answer

SQL Server 2012 Management Studio Express - no server

I am having trouble with SQL Server 2012 Management Studio. There is no server name. Earlier I installed the 2008 version but something wasn't right so I uninstalled and installed 2012. Upon installation 2nd time round there wasn't an instruction…
Adrian McGuinness
1 2 3
…
85 86