The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
41 views

Killing a process without login to MySQL

Here is the situation: I was running a very complex query on a database which was expected to execute within a few hours over night(server configuration is not good and data set is large). This ...
1
vote
1answer
133 views

Windows SQL Server Express 2012 and LDAP external server integration

I have a new installation of Windows Server 2012 with SQL Server Express 2012 with the management tools. I'm planning to create there a simple synchronization that will make queries twice per day to ...
0
votes
1answer
1k views

Why does max_connections in my.ini not match concurrent connections in Mysql instance config wizard?

MySQL 5.1.x | Windows Server 2003 Can someone please clarify why max_connections in my.ini is much larger than the manual value I specify in the Concurrent Connections Dialogue? For example, if I ...
0
votes
1answer
1k views

startup mount issues with Oracle

I am a newbie with Oracle so bear with me. I am trying to simply shutdown and restart an Oracle db instance on a Windows Server 2008 machine (Oracle 11.2.0). Logged in via sqlplus, I issue the ...
1
vote
0answers
9 views

How can I prevent SMB digital signing from killing SSIS performance?

My company recently turned on SMB digital signing on the Windows 2012 r2 server that runs SSIS. This has had a severe impact on data transfer performance. The security team did this and I can't get ...
1
vote
0answers
38 views

What is the best way to clear couple of tables each night at specific hour in Postgres SQL?

I need to clear couple of tables every night on my db so in the morning they will be empty and ready to use for the end users. I already wrote the query to truncate them but I'm not sure what is the ...
1
vote
0answers
92 views

How to check particular SQL UserID windows permissions in MS SQL SERVER 2012?

I would like to say as per my network system administrative security of windows Server 2012 R2. I am unable to start SQL Server agent. As per in MS SQL Server 2012 , i have "sysadmin" & "public" ...
1
vote
0answers
95 views

SQL Server scheduled backup to Azure Table bacpac

I moved my database from Azure SQL to Windows Server 2008 R2 + SQL Server 2012 Web edition virtual machine on Windows Azure. The Azure SQL provided automated backup to Azure Table as bacpac file. It ...
1
vote
0answers
488 views

Installing Netezza 6.0.8 ODBC driver on Windows Server 2008

Below are four Netezza drivers that are available for Netezza 6.0.8. I installed the second one on Windows Server 2008, and it placed it into the system32 folder (64 bit folder). However, when I set ...
1
vote
0answers
359 views

SQL Server 2012 Failover Cluster and attached SAN

I have three servers in a Windows Server failover cluster. SQL Server 2012 Failover Cluster is installed on all nodes. I have an issue with shared disks attached from SAN. overview with the same ...
0
votes
0answers
61 views

error 1067 process terminated unexpectedly

I am facing the following error while creating the Mysql instance from command line in Windows server 2012. Steps i follwed for creating a new Mysql Instance as a window service: I have stopped the ...
0
votes
0answers
33 views

Cant Import mysql system DB from another server

Both Servers are the same in hardware, OS, and MySQL versions (5.6.11). One server has MySQL on it and on the other one I just setup a fresh instance. I want to import all of the data to the second ...
0
votes
0answers
53 views

mirroring on sql server 2012 on different windows server 2012

I have 2 servers *.203 and *.205 I have sql server 2012 on each of them I tried to make mirroring between them every thing goes successfuly but when I tried to start mirroring it gives me ...
0
votes
0answers
74 views

Oracle 9i Low performance on Windows Server Enterprise 2003

I'm facing some problems with performance with my Oracle database running on a virtual machine with Microsoft Windows Server Enterprise 2003 with 8GB RAM. It works pretty well after the database is ...