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

Is using MySQL Workbench over the Internet safe?

Let's say I have a server with an SQL Database somewhere on the other side of the planet. Is it safe to establish a connection over the Internet? e.g. with MySQL Workbench. I'm asking because I heard that connections to servers, particularly using…
technical_difficulty
  • 143
  • 1
  • 6
2
votes
5 answers

Why does this SQL run so much faster in a Oracle server with the same hardware/data than another Oracle server?

My application has a SQL that takes ~ 30 min to run in the Oracle server in production. It takes about the same in a test Oracle server. For some reason, in another Oracle server, it runs much faster: only 5 min or so! These timings are really for…
b.roth
  • 259
  • 1
  • 4
  • 12
2
votes
0 answers

Connecting to ssl mysql always fails with error 2026

I have mariadb version 10.1.21-MariaDB-1~jessie (on debian 8) running a master-server replication scenario via ssl and it's working : MariaDB [(none)]> show slave status\G; *************************** 1. row *************************** …
Horatiu
  • 41
  • 5
2
votes
1 answer

Cannot generate SSPI context SQL Server 2016

First post here :) I've been trying to connect to a SQL server 2016 in a pc using SSMS 2016, both EXPRESS editions. Server shows up in Network Servers window. I'm trying to connect with HOSTNAME\SERVERNAME and Windows authentication , I already…
João Sequeira
  • 21
  • 1
  • 4
2
votes
1 answer

Cant connect to sql server database using ip

I've created a sql server database on server A. I was always using Windows Authentication to connect, but now I want to connect to database from server B. Then, I added a new user to database and turned Sql Authentication ON. Now, I can connect to…
Damian
  • 21
  • 1
  • 3
2
votes
1 answer

Powershell DSC - Info 1625. This installation is forbidden by system policy

I'm using the Powershell Desired State Configuration to set up a server. The server needs a SQL Client msi installed. As a logged in user, I'm able to click the msi, and install it with no problems. However, when I attempt to install it through…
Black Dynamite
  • 523
  • 2
  • 5
  • 16
2
votes
4 answers

SQL 2005 Standard Questions

I have a question about the tempdb files and hyperthreading. Here are the sw/hw specs. Server 2008 SP2 Standard X64 SQL 2005 Standard Sp3 x64 Dual Quad Core Xeon's E5540's (HT enabled) 12 GB Ram My first question is how many tempdb files should I…
Harris
2
votes
1 answer

SQL Failover Cluster Clients not updating DNS

I have a multi-subnet SQL Server 2012 failover cluster running on 2 Windows 2012 R2 nodes. The cluster is located on 192.168.1.10 when on NODE A and 192.168.5.10 when running on NODE B. When I look at DNS on the domain, I see 2 A records:…
edgesrazor
  • 41
  • 1
  • 3
2
votes
3 answers

MySQL stopped running on Ubuntu: Can't change to run as user 'mysql'. How to save data?

Today out of the blue stopped running MySQL on a Ubuntu server. When I try to log in there, I get this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Inspecting the error: mysqld…
user984621
  • 135
  • 1
  • 1
  • 7
2
votes
0 answers

Show or log long queries with values instead placeholders

I have any very long sql query in postgresql. I tried show what postgress do with: select * from pg_stat_activity unfortunately I see something like: select some_fields from anytable1 anytable2 where \ ( anyfield1.anytable1=$1 )and(…
Znik
  • 348
  • 1
  • 3
  • 12
2
votes
1 answer

Full-text catalog timeout, SQL Server 2005

we are re-loading a db with new data using backup/restore process. Once restore is complete, we re-build the full-text catalog. Full text searches work, no timeouts for about a day or so. However if the search hasn't been used for a day, two days,…
Igor Timofeyev
  • 21
  • 2
2
votes
3 answers

Do SQL backups run faster if you set the databases to read only first?

I have to do a backup of all databases back to back (3.25 GB of data for all .BAK files combined). Will it go faster if I configure the script to set the database to read only first before backing it up? I am using the RESTORE VERIFYONLY option to…
Michael
  • 39
  • 3
2
votes
1 answer

Hyper-V Guest data encryption

I have a new requirement to encrypt the data inside an sql database while it is at rest. So far I've looked at Bitlocker (see below), and other commercial products (I won't name because I'm not looking for this product is best answers). I've also…
Drifter104
  • 3,773
  • 2
  • 25
  • 39
2
votes
4 answers

SQL Server I/O Error 21

I am trying to take backup of one DB Which is showing Continuosly I/O Error 21 (The device is not ready) deteceted during read at offset 0x000000000000000040 in file e:\test.ndf Error 823. The Step Failed. The backup was running smoothly for last 2…
unknown (google)
2
votes
1 answer

backup compression ratio in SQL 2012 worse than in SQL 2008

We have SQL 2008 Enterprise with TDE enabled and upgraded to SQL 2012 with TDE still enabled. Everything works fine except that I am getting worse backup compression than in SQL 2008. I do understand the limitation with Compression when TDE is…
Peter
  • 21
  • 1
1 2 3
…
85 86