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. [tag:mysql], [tag:postgres], [tag:mssql], [tag:oracle]

learn more… | top users | synonyms

0
votes
1answer
30 views

Virtualized IIS 7 Intranet page is slow when querying against SQL database

OK… I’ve been tasked to figure out why an intranet site is running slow for a small to medium sized company (less than 200 people). After three days of looking on the web. I’ve decided to post what ...
0
votes
2answers
141 views

application response times grinding to a halt in .net - cant stop crashing

We have about 200 desktops across the US using our point of sale/website application on a daily basis. This application is considered mission critical and cannot go down for our retailers. For the ...
0
votes
1answer
31 views

slapd configuration for back-sql: how to traslate examples from slapd.conf to slapd.d

I'm trying to configure slapd with back-sql (specifically postgresql backend). All documents I found (Postgresq LDAP Howto seems to be more complete) are related to old configuration that use ...
3
votes
2answers
2k views

Command line scripts to restore the 4 system databases of MS SQL Server 2008

can someone give me some advice on how to restore the 4 system databases (master, msdb, model, tempdb) of a sql server 2008 please? I've already done some testing myself (on restoring the master ...
-1
votes
1answer
4k views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
13
votes
6answers
38k views

How do I change the collation of a SQL Server Database?

I'm trying to standardise all databases on a single collation - Latin1_General_CI_AS (the standard collation). I have some databases that are in SQL_Latin1_General_CP1_CI_AS. I know I can use ALTER ...
0
votes
3answers
47 views

How to find a word in SQL? [closed]

Lets say you are filtering on rows in a column that contains the word Engineer in a phrase. How can I exclude words like 'Engineering' or 'Engineered' or 'Engineers' when I wouldn't know all the ...
3
votes
6answers
2k views

What does it mean when Twitter says their entire database is in RAM?

I am wondering where to begin with database scaling/optimization strategies. After reading articles like highscalability.com's facebook architecture article, and this twitter architecture article, I ...
0
votes
0answers
68 views

sql-php-sqlyog: Access denied for user .. unable to connect to database

I browsed around all other answers provided for this same issue. But didnt find a solution. So I thought to ask mine here. I am not very good with sql. But this is the first time I am facing this ...
0
votes
1answer
39 views

on prem SharePoint 2013 size limitations

I am attempting to provide some of my remote users (bandwidth limited) with a on prem sharepoint server (Sharepoint 2013 foundation) on a Dell poweredge t110 II running windows server 2012 r2 ...
0
votes
0answers
17 views

SSIS Package stops SQL Server services

I built a SSIS package to populate Fact Tables. I came across a strange issue. So whenever i run the package/DFT task it results on failure. On inspecting it, i see that connection problem to the sql ...
1
vote
0answers
73 views

Error when viewing database mirroring monitor in SQL Server with non-default port

I have database mirroring set up (with witness) on SQL Server 2014 Standard. Both servers use default instance on a non-default port (not 1433). Mirroring works perfectly fine. However, when I try to ...
1
vote
1answer
310 views

In SQL Server 2012 Failover Clustering, we are getting “The action 'Move' did not complete. Error Code: 0x80071398”

We have setup 2 VM Nodes for SQL Server 2012 Failover Clustering. The iSCSI drives are on our SAN. Cluster setup and SQL Server 2012 SP2 install succeeded without errors. Connecting to SQL Server from ...
2
votes
0answers
18k views

Cannot telnet to SQL Server on port 1433

I've been working solidly on this issue for the past three weeks. I cannot seem to find where the actual issue is. I just recently found this article on how to troubleshoot the connection. I made it ...
4
votes
3answers
5k views

ODBC: trouble removing system DSN

I have a colleague who has two DSNs with the same name - one's a user DSN and the other, a system one. He removed the user DSN but can't remove the system DSN in ODBCad32 Anybody encountered this ...
3
votes
2answers
361 views

SQL Server 2008 R2 + Create new instance

I have a SQL Server 2008 R2 that's running as default instance. This instance has been patched with SP1 earlier this year. I would like to create a new instance for a new application. Once the ...
1
vote
3answers
115 views

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 ...
2
votes
2answers
23k views

how to get mysql.sock file, mistakenly deleted from “/mysql/tmp/”

I was stuck with a PDO Exception PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in lock_may_be_available() (line 167 of ...
0
votes
0answers
8 views

Is CAL licen for SQL Server [duplicate]

We have build a web application in asp.net and sql server 2014 but i was searching around and found that any who uses sql server requires a CAL. How are SQL Server CALs counted?. But what if non of ...
0
votes
0answers
6 views

Maintain and version controll config- and SQL scripts

I'm looking for recomandations of handling variouse config scripts for a few databaseservers. The scrips fall into the following categories: OS Config scripts and files, such as crontab for multiple ...
-5
votes
2answers
80 views

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

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 ...
0
votes
1answer
171 views

SQL Server 2012 Native Client returns missing DLL error on install

OS: Windows 7 Pro SP1 Whenever I try to install the SQL Server 2012 Native Client x64 the install process gets to the end, the "removing backup files" stage then throws up this error: "There is a ...
3
votes
1answer
1k views

How to Explain a query in PostgreSQL 8.3 that has bind variables

I need to explain an application generated SQL statement in PostgreSQL 8.3. I captured the SQL statement in the log but it has a lot of bind variables. Is their any way that I can explain this SQL ...
0
votes
0answers
48 views

Bridge server for connecting two databases?

I'm in a bit of a pickle. I currently have 2 database servers. One is hosted in the US and is online on the internet. The other is local, working only on LAN and external connections are not allowed. ...
3
votes
2answers
664 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
0
votes
1answer
119 views

Disabling TLS v1.0 with SQL & RDP

How do I disable TLS 1.0 without breaking MS SQL & RDP on Windows Server 2008 R2? If I simply disable it, RDP stops working along with MS SQL. Tried googling but I can't find a solution. Is this ...
3
votes
2answers
239 views

Performance azure disks, high average queue length

I'm having a classic developer-system admin battle where I am stating that there is an IO problem on the disk of the shared sql server while the system admin tells me that the capacity hasn't been ...
0
votes
0answers
290 views

How to export SQLCMD output to Excel

I am using SQLCMD command in powershell to run SQL scripts. When i pipe the output to TXT ,the formatting is all messed up. i want to export the results to excel file. how can i do that. My command ...
0
votes
0answers
86 views

How to Restore from sql Maintenance plan backup

I have a SQl 2005 Instance in my PROD SQL server. I have been given a task to migrate databases inside that instance to different SQL box ( SQl 2008 r2 in Win 2008 r2 box) Database. Current sql ...
0
votes
0answers
41 views

Upgade SQL Express 2012 -> 2014 gives: Script level upgrade for database 'master' failed because upgrade step

Trying to upgrade my SQL Express 2012 to SQL Express 2014 with the upgrade wizard, but get the error: Script level upgrade for database 'master' failed because upgrade step ...
2
votes
1answer
64 views

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 ...
-1
votes
4answers
202 views

MYSQL - is LOCALHOST speedy than i.e. (domain) mysql.domain.com [closed]

I am interested, on some hosting(although they are paid hostings, for example, DreamHost. probably 000webhost too), in database server, you have to insert: mysql.domain.com (instead of: localhost). I ...
0
votes
1answer
23 views

SQL alwaysON and WSFC

I have a WSFC configured on 2 (hardware)nodes with SQL AlwaysOn group. The problem is, if the node Where I have created the cluster goes down the cluster is not available for second node and here ...
0
votes
1answer
94 views

SQL Server 2012 AlwaysOn Availability Groups Server Logins Fails When Switching Between Nodes

I am setting up a 3 node cluster as part of an availability group. Initially I tested failover between nodes using SQL Management Studio and everything failed over successfully when I stopped a node, ...
2
votes
2answers
813 views

why would adding a crossover private nic cause IP address resource fail?

2 node Win 2008 R2 quorum cluster Configured 192.168.0.0/24 "public network" Configured cluster MSDTC Installed SQL 2008 R2 cluster instance Manually failover groups - OK Reboot server w/o failing ...
0
votes
1answer
36 views

SQL clustering without WSFC (Windows Server Failover Clustering)

Is it possible to cluster, or make SQL "highly available" without having to pay the huge enterprise prices? By the looks of it, any type of SQL clustering requires enterprise edition Windows Server. ...
0
votes
1answer
28 views

Migrating from SQL 2008 to SQL 2012 but cannot connect to the database

We are now migrating from a SQL 2008 to a SQL 2012 server. I am testing the databases one at a time as these are live databases. I have backed the database up and then restored this onto the new ...
2
votes
2answers
2k views

How do you migrate a SQL Membership database with encrypted passwords where the decryption key is autogenerated?

I have a server where the machine.config states the following: <machineKey validationKey="AutoGenerate,IsolateApps" decryptionKey="AutoGenerate,IsolateApps" validation="SHA1"/> A decryption ...
0
votes
1answer
63 views

Azure SQL - Sudden connection spike

At first: This is my first question on Serverfault. I am not sure if it fits better on Information Security. If so, please leave a comment and I will move the question. Question My company is ...
0
votes
0answers
12 views

Having Trouble Setting up OLAP/Analysis Services on SQL Server 2014

I have been having extreme trouble setting up an azure server with a sample multidimensional database i have been using this tutorial ...
-5
votes
1answer
73 views

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 ...
2
votes
1answer
121 views

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 ...
-2
votes
0answers
70 views

Where are the latest benchmarks on SQL-on-Hadoop performance? [closed]

I'm investigating adoption of Hadoop in my company, and a key requirement will be use of SQL for doing analytics. Hard to know exactly what the main usages will be but no doubt a mix of small and ...
0
votes
2answers
727 views

Copy DB table across 2 different MSSQL servers

I have 2 MSSQL servers running, with more or less the same data set. It is really a production/development setup. Now, my workflow is like this. Every day backups are made of each one of the ...
0
votes
1answer
36 views

how to create public SQL server [closed]

I installed sql server on my computer. I can work with it as localserver. But i want to it to be a public server. I followed lot of tutorials but it's still don't work(I can't connect the server ...
5
votes
2answers
2k views

Renamed a SQL Server, however maintenance plans still have old name

A colleague has renamed a SQL server, however all of the maintenance plans still have references to 'OLD_NAME' as 'Local Server Connection'. The text boxes containing the server names for Local ...
0
votes
1answer
164 views

32Bit ODBC DSN “Server does not exist or access denied” but 64 bit ODBC OK connecting to SQL Server 2014

Using a new SQL Server 2014 Connecting via 32bit ODBC fails giving the error "Server does not exist or access denied" Connecting via 64 bit ODBC is successful What might cause this?
1
vote
1answer
74 views

SSH Tunnel issues

Our setup is as follows; - 2 tomcat servers hosting sites - 1 load balancer - SSH connection to client server which contains database This approach has worked fine with the exception of one client ...
0
votes
1answer
38 views

Does SQL Azure Data Sync conflicts get logged?

I have successfully synced my SQL Azure DB with my on-premise DB. The log shows the following: Sync completed successfully in 1884.76 seconds. Upload: 405323 changes applied Download: 0 ...
0
votes
0answers
113 views

How do I create an SQLAlchemy class with two foreign keys (to different tables)?

Contrived example: class Person(Base): __tablename__ = 'person' id = Column(Integer, primary_key=True) name = Column(Unicode) class Location(Base): __tablename__ = 'address' id = ...