The tag has no usage guidance.

learn more… | top users | synonyms

-2
votes
0answers
18 views

Can you please explain about Remedy ticketing tool [closed]

Can you please explain about Remedy ticketing tool
0
votes
1answer
30 views

Restore from SQL Server 2014 Enterprise to BI

Is it possible to restore a SQL Server 2014 Enterprise database with table partitioning (Production) to a SQL Server 2014 BI Version (Test/Development) ? Of course I don't expect to use the table ...
0
votes
0answers
7 views

Debian Server failover setup

I need to set up two servers with failover capability (Active - Passive model) sharing a common DB (Postgres)running over NAS. Could you please suggest me some workaround for the same ?
1
vote
1answer
35 views

MySQL Hardware Bottleneck

I have a web application that makes simple queries to a MySQL database. The database is quite large (8.4GB) and the time to lookup an entry needs to be as fast as possible. The database represents a ...
0
votes
0answers
36 views

Server Performance Comparison

I have two computers with MySQL installed. I get very different performance between the two. On one a query takes <1 second when using SQL_NO_CACHE and on the other it takes ~6-7 seconds. The ...
-2
votes
1answer
21 views

SQL Error (126): Incorrect key file for table '.\mysql\user.MYI'; try to repair it

To give you a bit more info I had moved my webserver from my C: drive to my D: drive and had upgrade my OS from Server 2008 to 2012. All my website are fine and load without an issue and I havent run ...
-2
votes
2answers
32 views

Migrate a table from ms access to Sql server 2012? [closed]

How to migrate a table from MS Access to SQL Server 2012? Suppose I am inserting data in MS Access, how will it get upgraded in SQL Server 2012 without dropping or recreating a table?
1
vote
3answers
68 views

How to create a non-sa sql server login / access without control server permission

I have an ms sql server, and I need to give access to other users to run basic queries (just select on 1 database). I have created a login for a user, and have amended their permissions, but once I ...
-1
votes
1answer
44 views

Password protected Database Engine with Server features and Store procedure [closed]

I like MS access password protect feature but it does not useful for server based software like as SQLite which has password protect but not useful for server. MS SQL server is one of the best DB ...
2
votes
1answer
43 views

Restoring a replicated SQL Server database in a non-replicated testing enviroment

Sorry in advance if this is already answered, but it's quite difficult to search exactly what I need. We have a SQL Server 2008R2 DB in Production. Originally, the DB didn't have replication. Every ...
0
votes
1answer
67 views

User databases inaccessible after physical restart

We have an unusual error happening on the SQL Server. After restarting the physical server where the SQL Server instance is installed, the user databases are not accessible. System databases are ...
0
votes
1answer
55 views

Whether my table is stored as heap or b-tree?

I have a SQL Server 2005 database. It’s .MDF & .LDF can be downloaded at https://www.dropbox.com/s/uj2mw410jm2m078/MyDB.rar?dl=0 Now I want to know whether two table are stored as heap or ...
0
votes
1answer
90 views

MySQL: Creating a numeric user ID from distinct combinations of IP and user agent from a server log

I'm trying to create a numeric user ID from the distinct combination of IP addresses (alphanumerically anonymized) and the user agents. The table is a pre-processed server log file and contains among ...
0
votes
1answer
51 views

Mysql is shutting down in every 5 minutes

My MySQL 5.6 is shutting down about in every 3-5 minutes. I only can use it after restart. I don't know what happened; everything was OK 2 days ago. What do you suggest to me? Here is my ERR file ...
1
vote
1answer
178 views

SQL Server failover cluster installation fails on primary node

I'm trying to install SQL Server 2014 fail-over cluster, but the installation fails with following log i have tried a lot of things but without any success.. The installation failed with following ...
0
votes
0answers
15 views

Optimise communication to check record status

Imagine an universe full of products. I have an app that electronically marks products and saves this status into the server DB. The app may be used from different devices so each one will mark ...
2
votes
2answers
151 views

What is the usage of sys.sysrowsets in SQL Server?

I just wonder what is the usage of sys.sysrowsets in SQL Server? Microsoft said it “Exists in every database. Contains a row for each partition rowset for an index or a heap.” But what is a partition? ...
0
votes
0answers
11 views

with innodb engine, connection timed out & MySQL server has gone away error occured [duplicate]

I have created chat application which ping server every sec for messages. Currently I have done load test with httperf, with 500 request/sec. "Connection timed out & MySQL server has gone away ...
3
votes
1answer
130 views

SQL Server query on server taking longer than laptop

Our program uses an SQL server database as its back-end (SQL server 2008-r2 - 2014). The program is OK for performance but the Database seems to slow down a bit too much. As part of the nightly ...
3
votes
2answers
42 views

innodb_flush_log_at_trx_commit=1 and flush-to-disk reality

I use the default settings of MySQL 5.5 on various servers and I have the following table: create table test._perf ( name varchar(255) not null ) engine=InnoDB; I have an .sql script which ...
1
vote
1answer
55 views

SQL Server 2008 R2 Transaction Counts

Good Afternoon, We have a pretty big SQL Box 32proc 128gb. We had a change in our environment, not sure what exactly change, db/code. We're investigating that aspect as well. One of the things ...
3
votes
1answer
44 views

Does it make sense to limit Mongo RAM?

I have a Windows server running MongoDB. My database has big indexes and all RAM is usually busy. As I know, it can be a cause of Windows swapping and performance issues. Does it make sense to limit ...
0
votes
1answer
90 views

Documenting SQL Server Database [duplicate]

I wrote the following (Quick and Dirty) script to document a database schema: Note - The relationships part came from another guys site (I just can't remember where). Does anyone know how to ...
3
votes
1answer
438 views

Database server down: file /dev/vda1 used up all diskspace

My database server went down last night because there was no diskspace available. I checked what used up diskspace and it was 28GB by /dev/vda1 I have no clue what this is. The database all together ...
1
vote
0answers
43 views

MySQL sizing tool for Hardware [closed]

Is there any sizing tool for hardware? I'm not sure what kind of servers we need to offer to my customer like CPU, memory, Disk or number of servers? What kind of questions do we need to ask our ...
2
votes
1answer
206 views

unable to shutdown mysql server

I am using yosemite, if that matters. I have tried using the system preferences and then shutting down mysql there, but to no avail. I also tried typing killall -9 and -11. Both failed :(. I also ...
1
vote
0answers
31 views

Creating a simple backend solution [closed]

I'm doing an internship for a NPO for deaf and hard of hearing children and their website is very outdated and requires going into specific .html files to make changes or update content when a user ...
1
vote
2answers
97 views

MySQL server cannot be stopped

I am using Ubuntu release 14.04, MySQL 14.14 Distrib 5.5.43. To reset the MySQL root password, as described in the official MySQL doc How to reset the root password, I need to stop the MySQL server. ...
0
votes
2answers
230 views

Analysis Services not allowing other/remote connections other than localhost

Analysis services not allowing any connections except localhost. Authentication box is disabled and only allow windows authentication. How can I connect to different remote analysis servers using ...
0
votes
1answer
32 views

Configuring Listener on Oracle Server

I am very much new to Oracle environment. I was trying to connect to my Oracle server from another machine on the same network. I found out that I need to configure Oracle Listener on the server that ...
1
vote
1answer
101 views

Install PostgreSQL using source code or using apt-get?

I want to install PostgreSQL on a server that runs Ubuntu 14.04.2 LTS. I understand that I have two options: 1) Install PostgreSQL using the source code distribution e.g., ...
0
votes
0answers
115 views

CREATE OLAP server

I have a MySQL database server along with replication server, i.e. OLTP system altogether. As I have very heavy data fetching queries for the decision making reports. I need to create data-ware house ...
-1
votes
1answer
33 views

Set up MySQL server database [closed]

I want to set up MySQL server database for my office on my windows 8 pc, but i dont know exactly which products to use. Can anybody help me with it. I want to set the database such as my pc would be ...
2
votes
1answer
325 views

MongoDB installation Ubuntu 12.04 LTS errors

I need some help with my MongoDB installation on a clean, fresh Ubuntu 12.04 LTS server with no nonsense installed. I thought it would be a piece of cake, but I got some errors and the Ubuntu-forums ...
0
votes
1answer
159 views

Processors: E5-4620 v2 vs E5-2620 v3 [closed]

We're debating between: R820 - E5-4620 v2 - 2.6GHz - 8 cores, 20MB Cache, 1333MHz max memory speed - max of 768GB ram - 8 core R730 - E5-2620 v3 - 2.4GHz - 6 cores, 15MB Cache, 1866MHz max memory ...
0
votes
1answer
74 views

How to optimize a slow query?

I work as an administrator and software developer for a company that provides services to the car selling business. In essence we develop the software that they use when selling cars and such. This ...
1
vote
1answer
63 views

Setup MongoDB replica servers with different power?

Is it a good practice to setup replicas with the same machine size (wrt. CPUs, RAM, Bandwidth, etc.) or can replicas be based on smaller machines? One usecase might be to have a small non-voting ...
1
vote
1answer
106 views

mysql query from 1st domain and insert in 2nd domain

i have data in one of my website and i want to print these data in other site.these two are in same server.at present i have to export mysql data and import into other then do this code to insert in ...
0
votes
1answer
379 views

odbc connection from windows machine to mysql server running on ubuntu?

I was able to install mysql server on an ubuntu machine and set up a test data base, created a user and granted that user access to the database. I also changed the binding address to the IP of the ...
0
votes
1answer
355 views

Small business SQL Server [closed]

I'm asking the experts.. I work in a small business (<10 employees) but I need a production database. I wouldn't go as to say I'm a DBA but I well versed in creating databases, tables, ...
0
votes
2answers
420 views

How to know what server and port to select in MongoVue

I am unsure about which server and port to select when trying to start up MongoVue. FYI, MongoVue is the windows GUI for using mongodb (for those macusers who may want to answer this question). I have ...
0
votes
2answers
87 views

Is it advisable to restart a SQL server box running Windows when disk space is low?

We've had a sudden drop in hard drive space on the OS partition of our SQL server (as databases are being stored there). It's causing various issues, and we're unable to move one of the databases, as ...
0
votes
1answer
148 views

Multiple left join hangs server

I have a problem with left join query. It connects 3 tables and calculates sales value for categories. Query: SELECT categories.name, categories.id, ...
0
votes
1answer
2k views

Issues with self signed certificates, SSL and MongoDB

Note: As specified in my comment I've figured out a solution to this issue regarding a single client/mongo connection. The next step is to figure out a solution for a replica set involving this fix. ...
2
votes
2answers
11k views

Can't start MySQL server because of wrong file permissions?

I'm trying to start the server and then fix the root user by $ mysql -u root mysql $mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root'; $mysql> FLUSH PRIVILEGES; But ...
0
votes
0answers
20 views

RAID configuration for mysql [closed]

I attached 4 10G disks to mysql Server and I used RAID 0 but still same mysql performance the same, Do I have to change configuration in my.cnf to let mysql know about RAID 0
1
vote
2answers
518 views

RAID configuration for mysql

I attached 4 10G disks to mysql Server and I used RAID 0 but still same mysql performance the same, Do I have to change configuration in my.cnf to let mysql know about RAID 0. this is my mount ...
2
votes
1answer
426 views

Inconsistent MySQL query execution times

We run tests on two servers: one in production [Old Server] and the other one in tests [New Server]. Both tests used the same database. [New Server] Dedicated MySQL 5.6.17 server on Ubuntu 14.04 ...
0
votes
1answer
214 views

MySQL server parameters default empty string to null

How can I set MySQL server parameters to default empty strings to null on insert? is this possible?
1
vote
1answer
2k views

How to set bytea_output to hex?

I cannot seem to change bytea_output to hex. I have tried this method: ALTER DATABASE dbname SET bytea_output TO 'hex'; I have tried to edit postgresql.conf bytea_output = 'hex' and restarted ...