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 Import to update existing records?

I've got a table in a database that contains costs for items that gets updated monthly. To update these costs, we have someone export the table, do some magic in excel, and then import the table back to the database. We're running MSSQL 2005 and…
Kenundrum
  • 43
  • 1
  • 1
  • 4
4
votes
1 answer

Error creating Sql Server in Azure this location is not available for subscription

Im trying to create Sql Database resource and any location i select i get: "this location is not available for subscription" Im trying to create WebAPP with Database. Plan is pay as you go
Mostafa Farahmand
  • 41
  • 1
  • 2
3
votes
2 answers

MySQL using ridiculous amount of memory to import 1-2GB SQL files

I have a MySQL server running on an Ubuntu 18.04 machine via Docker. The machine has 32 GB of RAM. I have about 300 1-2GB SQL files which need importing into a database on the server, into a single table. The database itself is completely empty, and…
Billy
  • 31
  • 2
3
votes
4 answers

Joins performed without indexes: 5568

I was trying to do mysql optimization. Yesterday the CPU usage was 100%. I am trying to optimize with mysqltuner but this time I gave a mysqltuner warning. I have a high-traffic db. 500-600 connections in a day. Maybe more. How can I fix it? [!!]…
Tota1907
  • 39
  • 1
  • 1
  • 4
3
votes
4 answers

Running SQL 2008 on a VM

We are pondering trying to set up a SQL 2008 instance inside a VM for a production environment. All our SQL instances use iSCSI over gigabit ethernet to talk to a NAS, as would this new instance. Any reason this is a bad idea or any considerations…
chris.w.mclean
  • 155
  • 4
  • 13
3
votes
2 answers

Potential issues with SharePoint 2007 and SQL Server default collation?

SharePoint installation guidance specifies that SQL Server collation should be set to Latin1_General_CI_AS_KS_WS (case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive). However, our internal hosting group uses the default SQL…
MDRoz
  • 131
  • 2
3
votes
1 answer

Prestashop + Google Cloud SQL

I am currently trying to setup a Prestashop 1.7 instance using Google Cloud Compute Engine and Google Cloud SQL (MySQL 5.7). I managed to get to the installation page of Prestashop, but when I try to connect it to Cloud SQL, I get the following…
Thien42
  • 31
  • 2
3
votes
2 answers

Unable to Windows Update and WSUS broken

for a while now, despite working faultlessly for over 3 years, both WSUS and Windows Update have stopped working on our single domain contoller running Windows Server 2008 (not R2). The error we get when trying to run Windows Update is "80072efd"…
fRAiLtY-
  • 83
  • 1
  • 2
  • 10
3
votes
2 answers

How to convert a MyISAM .sql dump into InnoDB?

Can I convert dumped .sql MyISAM database into InnoDB engine before importing it to my MySQL server? Unfortunately, importing the current .sql file takes ages to complete.
Jakub Pastuszuk
  • 153
  • 1
  • 7
3
votes
0 answers

postgresql invalid command \

When trying to import an .out file back into a postgres database, I get many (thousands) of rows like this: psql:G:/Backup/main_db_backup.out:251875: invalid command \ With a different number where "251875" is each line Does this mean the restore…
SLipman
  • 31
  • 1
  • 2
3
votes
1 answer

How to get High Availability if using SQL and a NAS?

In a scenario where we want to use a NAS as storage for a big (MS SQL) database, how would you handle the high availability if the mdf files are stored physically only in the NAS device?
Horaceman
  • 145
  • 1
  • 4
3
votes
1 answer

Why does TFS need an SQL Server Instance?

It's been over 3 years since I am using TFS 2012 for source code management, reporting and project management. However, until now, I've never installed from scratch any version of TFS. In order to use SSRS 2016, I need to install TFS 2015, and by…
Luis Gouveia
  • 211
  • 1
  • 3
  • 8
3
votes
3 answers

MSSQL I/O performance degraded after SAN consolidation?

Recently I have consolidated all our Dell Equallogic SANs into the same group; previously each SAN was in its own group. They are all populated with 15k RPM SAS drives in RAID 6 so I haven't bothered to tier the storage of the new consolidated…
NaOH
  • 411
  • 2
  • 10
  • 19
3
votes
1 answer

SQL Injection Filter IIS

Currently running an IIS server with some legacy asp & sql. I was wondering if there are any good isapi filters which would automate checking for SQL injection attacks ?
Yucel
3
votes
6 answers

How do I report SQL Injection attacks (e.g. to User's ISP)?

EDIT : Sorry, my question clearly wasn't clear. I don't want to report attempted server attacks internally; we already have systems that log. record and report that activity. What I was keen to do was to report the attacks to the perpetrator's ISP…
Kristen
  • 187
  • 8
1 2 3
…
85 86