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

-3
votes
0answers
16 views

How many SQL server 2016 RCs will there be? [on hold]

I understand SQL server 2016 is at Release Candidate 3. Does anyone know about how many RCs there will be until the final one gets launched? (Based on past SQL server RCs). Is RC3 close to the final ...
0
votes
0answers
35 views

SQL Server 2016 RC2 and RC3 Install ERROR (Pictures and logs provided)

Can't install, updated Windows Server 2012 R2 fully with all Optional and Important Updates. I enabled a proxy to gain outside access which works (since Windows updates work). There is no anti-virus ...
0
votes
1answer
10 views

How to change interface language of sql server 2008?

As you can see in the image below, the SQL Server Interface language is in Spanish and I want to change to English. I tried my best to find a way to change it without uninstalling this Spanish ...
0
votes
0answers
3 views

Transactional replication using articles filters and delete operations [migrated]

The problem with transactional replication using articles filters and delete operations. I have a problem with my transactional replication when I use articles filters and delete operation. When I ...
0
votes
0answers
17 views

Consolidating various applications and databases [closed]

I'm hoping that you may be able to advise me how to best consolidate and reduce the number of servers that we currently have applications and databases reside on, in our Windows estate. I'm going to ...
-1
votes
0answers
5 views

SSRS Reports in Dynamics CRM

I am currently working on SSRS and CRM Prem. connectivity. I have SSRS report which show detail information for specific client where I am passing GUID as ClientId to fetch all values in report. ...
-1
votes
2answers
45 views

MS SQL Server 2 identical databases on different servers replication or mirroring to each other possible? [closed]

Hi: I have one free version of SQL Server 2012 express database running on Amazon AWS with 1 CPU and only 1 GB Ram . As you can see the CPU and RAM power are barely enough for my PHP scripts running ...
0
votes
1answer
17 views

Azure SQL Database Failover But Use Same DNS Name

I am researching ways to make a highly available web application in Azure using the PaaS App Service and DBaaS SQL Database offerings. Standard databases include Standard Geo-Replication to ...
-1
votes
0answers
40 views

PHP 7 oci8 query with more than 8 fields causes segfault

Server: Ubuntu 14.04.4 LTS PHP:PHP 7.0.3-5+deb.sury.org~trusty+1 (cli) ( NTS ) Copyright (c) 1997-2016 The PHP Group Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies with Zend OPcache ...
0
votes
2answers
45 views

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

MSSQL query not working, even if there is data

Trying to run a more complex SQL query on an MS SQL server, but I get no data output. Logically should be fine, but I cant see why it doesnt work: SELECT D.NAME DATABASE_NAME,T.NAME TABLE_NAME,I.NAME ...
3
votes
0answers
31 views

When configuring rsyslog to log to mysql DB, what is purpose of SystemEventsProperties table?

I've configured rsyslog on my servers to log to a remote mysql DB. I did this essentially by following the rsyslog wiki and it essentially creates two tables: mysql> show tables; ...
0
votes
1answer
8 views

Use LDAP on top of simple mysql hash+salt user table

We have a huge table full of user accounts for our website that are stored in a very simple and standard mysql manner: the user-id is associated with a salted hash that represents the password and ...
1
vote
1answer
27 views

Intermittent Server Performance Degradation Troubleshooting

I have been troubleshooting an intermittent server performance issue for too long and I am running out of ideas. I am looking for any suggestions as to how I might be able to identify the cause of ...
-2
votes
3answers
72 views

Transition legacy software from Windows XP on Windows 10

I have a 'general' question regarding transitioning legacy software from Windows XP to Windows 10. I will provide all relevant info and the reason for doing so. Firstly, the legacy software was coded ...
0
votes
0answers
29 views

Setting up Active Directory, Adding Machines with Different OSes & adding a server with an instance of SQL

I have 2 servers to manage at work, a Dell Poweredge with has a software called "Abecas" which uses SQL Server, The Poweredge is running Win Server 2008, there is no AD in place as of yet. I have ...
0
votes
0answers
16 views

How do you speed up an SQL query on a huge database? [duplicate]

I'm currently dealing with a table that has 30 million rows of 8 columns. I'm only selecting the columns that I need. SELECT column_a, column_b FROM table_name This is happening from a python script ...
0
votes
1answer
11 views

auto grow SQL 2008 in relationship to file groups

I am moving some indexes\tables to a secondary file group. What are the ideal settings on the DB in question in regards to the 'Auto Grow' options after the tables moves ?
0
votes
1answer
20 views

MS SQL replication run only with system account

I'm trying to configure a new replication with SQL Server 2012 I configured the distribution While configuring the publication, it asked for a user to run the snapshot agent. I set a strong user ...
0
votes
0answers
19 views

MS SQL - HA & load balancing best solution for servers at different geo-location

Customers has App server (MS Server 2012) and Storage server (MS SQL 2012), with several hundred clients accessing server app via VPN. Now they want to have a high-availability and also load ...
1
vote
1answer
38 views

SQL Server Full BackUP functionality

In SQL Server 2008 R2 (or Any other Version); Transaction-1 had started at 11:50:00 and it takes 1hr.5min to complete(i.e., completed at 12:55:00) and Transaction-2 had started at 17:45:00 and it ...
0
votes
0answers
9 views

SQL request in Bacula database

I would like to get all the files that are at least in one job which is now saved on one determined tape in the Bacula database. This could replace a tape listing. I have tried several request to ...
-1
votes
1answer
42 views

Web page generating error on SQL stored procedure [closed]

I am a total newbie to SQL. I am a networking specialist so like most smaller IT positions I kind of got this problem dropped into my lap. I have been able to pinpoint some issue through event logs ...
0
votes
0answers
12 views

Separated Java EE and PHP APIs running in the same machine and sharing the same SQL database general workaround

Having in mind the Java EE and the PHP APIs are completely separated (this is not about using java processes from PHP or PHP processes from java) and they will only share the database, is there any ...
0
votes
0answers
32 views

Connection issues after separating database from the web services

We had performance issues where server would run out of resource and decided to move database onto another server. It seems to work but crashes every few minutes with the following errors: Warning: ...
0
votes
1answer
11 views

SharePoint 2010 not accessible

My complete SharePoint 2010 site is not accessible. However, the admin site is. The database is still OK. Error: Cannot open database "WSS_Site_Content" requested by the login. The login failed. Login ...
0
votes
1answer
21 views

SQL Server Mirror issue on Mirror side

Team, I am having an issue on one of my Mirroring environment. It is SQL2008R2. DB mirror was somehow broken between principle and Mirror side. Someone(Not sure who is he/she due to offshore support) ...
4
votes
1answer
85 views

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

Unable to start SQL server agent automatically

I am working on SQL 2012, I already been set up my SQL server agent in automatic start up mode in windows services as well in SQL config. Even though it was not starting automatically. How can I fix ...
1
vote
0answers
20 views

Alias with all users in mysql table for postfix/dovecot

I have a table with users for my mail server. This table for imap authenfication in dovecot: ...
0
votes
1answer
20 views

How can I export a database to Azure in SQL Server Mgmt Studio 2008?

I'm trying to export a database to Azure using the most recent version of SSMS 2008, and I'm having trouble because I don't have the options listed under "Tasks" that the tutorials I've found indicate ...
0
votes
0answers
14 views

SQL Equivalent to Mysqltuner

We are running SQL Server 2008 R2 which powers our order processing system. I am familiar with the linux products like mysqltuner. Is there one that would do the same for sql databases?
0
votes
1answer
127 views

SQL Server very fast in local network and extremely slow when accessing over Internet [closed]

What I did, for a test, since my database that I work on is very slow when accessing over the Internet, is: I've installed SQL Server 2014 with latest MSSMS I've opened a port on a router and I've ...
3
votes
0answers
156 views

Exit code 0x84C40013 in silient installation of SQL 2008 service pack 3 installation

Following Command is utilized for installing SQL SP3 pack in Windows server 2008 R2. start /WAIT C:\Temp\SQLSP3.exe /quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances This complete ...
1
vote
0answers
11 views

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

Is this an SQL injection attack? If so, what's it trying to do?

I'm seeing a number of entries in my access log where 'A=0 is added to a query parameter, eg: http://www.server.org/foo/?bar=1'A=0&type=xml The parameter that 'A=0 is attached to varies, but ...
0
votes
1answer
29 views

Get password for all failed MySQL logins

Im having issues trying to figure out what is the cause of a failing SQL login. The password seems correct to me, but it still isnt working. I want to see what exactly the user login is sending when ...
0
votes
0answers
13 views

Access denied error connecting to SQL DB with Postfix

I have no idea how to go about debugging this. I have created an SQL user called postfix and i have verified that i can log into the DB with this user and edit tables. I have configured postfix to use ...
0
votes
0answers
4 views

xp_cmdshell fails to call outside procedure W2K12

SQL Anywhere 12 DB event calls xp_cmdshell to run cmd.exe and points to a .bat file. This same exact process works on all verison of Windows Server but 2012. "the database event calls a procedure ...
0
votes
1answer
30 views

SSIS 2014 - map NFS

We are migrating SSIS from SQL 2008 to SQL2014. Old OS: WINDOWS 2008 R2 SP1 New OS: WINDOWS 2012 R2 I use the Execute Process Task to map an NFS share to a drive. Executable: ...
0
votes
0answers
17 views

Merge and transactional SQL replication…database empty (SQL 2005)

Firstly, let me just say that I'm a novice at SQL in general and this might be an easy fix for someone reading, but I've been unable to find anything that would explain or help my issue online. If ...
0
votes
0answers
95 views

SQL Server 2008 R2 eventually sends RST instead of FIN/ACK

My SQL Server 2008 R2, running on Windows Server 2012 R2 unexpectedly sends connection resets (RST packets) to its clients performing series of small queries. The problem is, it eventually happens. ...
3
votes
1answer
80 views

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

After move SQL isn't releasing memory for queries

We recently made a move from one VM hosting environment to another. The machine we moved is a clone so all settings are identical pre- and post-move. However in our new environment our SQL server is ...
1
vote
0answers
11 views

Sql Partitionning a table time by time [closed]

I try to do a partioning into a SQL table with Microsoft SQL Server Management Studio. I want to do this partition all night at 23h. For example i put all lines with a 0(on the column) on my ...
0
votes
0answers
31 views

Bacula stopped working after pool delete from catalog and from disk

We had 2 identical backups of 1 server. 1 was done by real name and the second was done by alias (CNAME in DNS). I deleted the one that was done by CNAME to free up disk space. First I deleted pool ...
1
vote
0answers
9 views

Hadoop Hive, Impala, Pig, and more — SQL access to Hadoop?

It appears that Hive, Impala, Pig, and others all provide SQL or SQL-like access to data stored on Hadoop clusters. They all seem to have support for HDFS, S3, and other forms. So why are there so ...
1
vote
0answers
11 views

SQL Server Table Partitioning & Impact of Raid Levels

How does SQL Server Table partitioning get impacted by the DISK RAID level ? We have a SQL Server with 8 data disks . The main table in the database has over 200 million rows partitioned by day of ...
0
votes
1answer
87 views

Restoring a differential database file “the backup set holds a backup of a database other than the existing”

I am trying to test restoring a SQL database using a full/differential approach to a different server than it was backed up from. The database is in simple recovery mode as it is a test data ...
0
votes
2answers
135 views

Website/Server down for maintenance - Redirect to 'Landing Page'?

I have been given the task to make it so when customers try to access their websites while maintenance is taking place (Whether on their website, or taking the whole server offline) they are ...