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
11 views

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

SQL Event Notifications to Remote Server

I have event notifications for SQL and I currently have them writing to a another DB on the same database server. Is there a way to have it write to a remote DB on another DB server? My goal is to ...
0
votes
1answer
11 views

Insert multiple sql files

I've 297 sql files, I want import them to mysql but it must be in different databases. I tried: find . -name '*.sql' | awk '{ print "source",$0 }' | mysql -u <db_user> -p --batch -D ...
0
votes
0answers
9 views

Strange Postgres PreparedStatement behaviour (JDBC)

i have a strange problem with the following parameterized PreparedStatement in Java: PreparedStatement ps=DBUtil.newPreparedStatement( "SELECT * FROM msg as m WHERE " + ...
0
votes
2answers
19 views

SQL randomly disconnects in the middle of querying data

I have a strange problem - when I am querying SQL table with more than 9000 rows, SQL randomly disconnects with some unrelated error. 1.) What I mean with randomly disconnects: On average it happens ...
0
votes
0answers
7 views

SQL Sending Maintenance Plan Notification WITH the actual error message

For some time, we searched for a solution to provide details from a failed SQL Maintenance plan to the IT Support team, who were responsible for the services being scheduled; trying to escape the ...
0
votes
1answer
16 views

Allowing remote connections to SQL Express

On Windows 2008 Server R2, I installed SQL Server Express 2014 successfully and enabled TCP/IP on the default port (1433) and also added an inbound firewall rule to add port 1433. The database option ...
1
vote
2answers
29 views

Business Intelligence for VS 2012 on WS2008 R2 Enterprise

I have Windows Server 2008 R2 Enterprise, x64 with Visual Studio 2012 Pro. I want install Business Intelligence, but can't do it: What I do wrong? Solution: use it
0
votes
0answers
77 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
17 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 ...
-1
votes
2answers
62 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
19 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 ...
0
votes
2answers
66 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
25 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 ...
0
votes
1answer
10 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
36 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
75 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
21 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
25 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
39 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
10 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
13 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
33 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
12 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
22 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
100 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
77 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
22 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
154 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
179 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
223 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
14 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
18 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
108 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
86 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
54 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
34 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
10 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
13 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 ...