1
vote
0answers
19 views

What are the different types of binary relationship types?

I'm new to databases and while studying questions on it, I've come across one that I can't find the answer to. Define the three different binary relationship types that are common in relational ...
3
votes
2answers
69 views

Rebuilding indexes on a list of tables

I have a large number of tables that may change, may have infrequent changes in index, etc. I may well hand this off to somebody else and I don't want indexes to become overly fragmented, slowing the ...
2
votes
1answer
38 views

How to Identify Who or What is Restarting SQL services via Service Control?

I investigated an instance that experienced an unexpected restart and came across the usual service control event but no user login associated with it. Is it still possible that an authorized user ...
2
votes
1answer
10 views

MySQL open_files_limit - cannot change this variable

I'm running into issues because my open_files_limit for mysql is only 1024. Centos 7, MySQL Community Server 5.6.22-log It's actually a vps dedicated to mysql for a WHM server (remote mysql), but ...
-1
votes
1answer
23 views

SQL Server 2008 create database problem [on hold]

When I create a database in SQL Server 2008 an error message is shown: Create database permission in master denied in database master. What can I do?
1
vote
0answers
22 views

Please explain log-shipping delta

I am trying to understand how Delta is monitored in log-shipping. We have log-shipping monitoring in place and I am seeing delta increases sometimes for random instances and it drops once database is ...
1
vote
0answers
19 views

Which is the best way for selecting dimension attributes while creating a dimension?

I'm a newbie to SSAS OLAP so please apologize me if it was a silly question but surely I need suggestions. I would like to make clear some concepts which was confusing for me. Let us consider five ...
1
vote
1answer
24 views

Index that mimics full-text-index

I have a database that is retrieving information quite slowly, I asked a question and was told to use full-text-indexing, this worked, but now we switched over to a .sdf file and Sql Server Compact ...
1
vote
1answer
55 views

SQL Server : scheduled JOB issue

I have one issue in my live server ... Issue is: I created a job for log file shrink & I have scheduled it for every day run with sa user When I run this job manually from Management Studio, it ...
-1
votes
0answers
13 views

MYSQL PHP slow response from server

I have max 72 connections at a time, normally it is 15 to 20 connections, but my server is response is slow and it is giving 500 internal server errors to users can you please tell me how to get rid ...
0
votes
0answers
7 views

MySQL cluster error: “Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock”

I am trying to configure MySQL cluster under three Windows 7 machines with disabled firewall, cluster information is like the following: 2 hosts with each running 1 data node 3rd host running ...
0
votes
1answer
19 views

Hierarcy Query Mysql

I have a table like this... ========================================================================== UID || PARENT ID || SPONSOR ID ...
1
vote
0answers
5 views

Using Netscaler datastream and MySQL

I configured MySQL service on a netscaler 10.5. When I perform some MySQL benchmarks using mysqlslap, the first time it runs correctly, the 2nd time I have an error message: When I run it the first ...
1
vote
0answers
16 views

How to modify an existing AlwaysOn Availability Group IP

I have an unusual question regarding AlwaysOn Availability Group configuration. I have built out an AOAG cluster on a VM. The build out did not use a Heartbeat network as I had originally requested ...
0
votes
1answer
32 views

Best practice - use of derived table or use the original table in join?

Imagine I have the following tables in Teradata : TableA : Field1|Field2|Field3 TableB : Field1|Field4|Field5 I am trying to join these two tables Method 1 : SEL TableA.Field3, TableB.Field4 ...
-1
votes
1answer
28 views

The sum of the distances of all employees and select the top 3 [on hold]

I have a table "raporty" in which there are reports of all employees. Each employee has their id. How to do that for each employee separately summed up his trip distance and choose the 3 largest in ...
0
votes
0answers
9 views

Set variable if variable didn't initialized

I'm creating alternate of uuid_short() function named custom_uuid_short. DELIMITER $$ CREATE DEFINER=`root`@`localhost` FUNCTION `custom_short_uuid`() RETURNS bigint(20) unsigned BEGIN declare ...
0
votes
1answer
18 views

Changing mysql root password on Windows after removing mysqld-nt.exe

I am trying to change password of MySQL root by following the steps here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html unfortunately the mysqld-nt.exe doesn't exist in Windows ...
0
votes
1answer
14 views

Changing mysql root password on Windows after removing mysqld-nt.exe [duplicate]

I am trying to change password of MySQL root by following the steps here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html unfortunately the mysqld-nt.exe doesn't exist in Windows ...
0
votes
1answer
54 views

what's a reliable way to determine the ideal innodb_thread_concurrency setting?

on an article from 2006 , here they suggest such formula. 2*(number of cpus + Number of Disks) has anyone tried their settings according to this formula ? or do you have any other formula ? our ...
0
votes
0answers
9 views

Make a field in a form that count values [on hold]

i have a form that`s named classes and has a sub form named assignments i would like to create a field that will count the values in the sub form how much descriptions is in the assignments sub form ...
3
votes
2answers
38 views

Selecting minimum value in top grouping only

I have a query built in Oracle 10 which produces a set of data like this: EMP_ID WORK_DT TIME_TYPE ---------- --------- --------- 12345 19-DEC-14 10 12345 18-DEC-14 10 ...
0
votes
0answers
18 views

An efficient way to do “reverse queries” in MongoDB for an expert system?

I am working on an "expert system" in which I would like to perform "reverse queries", that is I want to store queries and find queries that match a given object. For example, if I have an object ...
0
votes
0answers
23 views

PostgreSQL indexing table on multiple columns

I have a table that holds half hour metering values in a compact form on a daily basis. The table has a structure as described below: day: timestamp without time zone, // describes a day ...
0
votes
1answer
25 views

I can not copy database MongoDB

I created a mongo cluster in ubuntu and run the copy in the sharding with a small database, everything works fine. The problem is that when I try to copy a database 300gb, is not getting done. The ...
10
votes
5answers
1k views

Reasons for avoiding large ID values

We are working on a web application, not yet accessible to users. My boss noticed that newly created records get an ID of over 10 000, even though we only have under 100 records in the table. She ...
0
votes
0answers
8 views

MySQL Socket exclusively

I've disabled TCP by using skip-networking in my /etc/my.cnf file I've deleted all users (mysql.user) that have other Host than localhost Now I went through the other tables in the mysql database ...
0
votes
1answer
9 views

mysqld got signal 11 - it's my fault but how do I fix it?

I was copying the database tables from our production server to my dev machine, and in the middle of the transfer I found out users were being locked out of the system because the select had locked a ...
0
votes
0answers
7 views

MySQL Socket connections and SSL

I'm currently running over some final tweaks and security measures for my MySQL server deployments. Mainly I'm running Google's Golang and connect to the MySQL database through a Socket connection. ...
1
vote
1answer
50 views

Investigating specific SELECT queries

For a particular row in a table how can I determine the number of reads done to it such as SELECT * FROM MyTable WHERE ID = <something> and when and where the read query executed? I'm ...
0
votes
0answers
6 views

Subreport Only Works In Some Situations

I have built a report that's a sort of "Landing Page" for two other reports. This report has two parameters, both of which can accept blank ("") values (not null). One of the reports is a "search" ...
1
vote
1answer
25 views

Pivoting with NULL Dates

I'm attempting the pivot below: SELECT EmpID as ID, [1] as January, [2] as February, [3] as March, [4] as April, [5] as May, [6] as June, [7] ...
3
votes
3answers
129 views

Login lifespan for password on SQL Server

What is the "lifespan" for a login with the option Enforce Password Expiration Enabled? Where can I find configuration/option to change the time?
-1
votes
2answers
43 views

Need help finding inactive users in my database

I am trying to figure out how to get this figured out. Problem: Users of inactive customers are receiving scheduled maintenance notifications Indicators: Organizations have a custom binary field ...
0
votes
2answers
12 views

creating table syntax error

I have a problem creating the table. It says unexpected parenthesis at line 3 CREATE DATABASE scl_teachers; USE scl_teachers; CREATE TABLE clteacher ( 'id' INT (10) PRIMARY KEY auto_increment, ...
0
votes
0answers
21 views

Upgrade from 2008 RTM to 2008 R2 RTM failed due to perf-ReportServer-rsctr.dll is being used by another process

I was upgrading SQL Server 2008 RTM on windows Server 2008 R2 Sp1 to SQL Server 2008 R2 RTM.I got this error " The process cannot access the file 'C:\Windows\SysWOW64\perf-ReportServer-rsctr.dll' ...
0
votes
0answers
7 views

Mysql Workbench Server Status CPU Metric

MySql Workbench 6.1 on Windows connecting to MySql 5.6 on Linux (Amazon RDS). The Management - Server Status page shows information about the connected Mysql server (Queries per Second, etc). It ...
0
votes
2answers
27 views

Get all the users that are managed by a targeted manager

I have the following model: Table user: (id, name, direct_manager_id) Table customer: (id, name, managed_by_id) i.e. users can have another user as their direct manager, Customers can be managed ...
0
votes
0answers
21 views

searching through entire database php script

$tableArray = array('tbl_course','tbl_faculty'); if(!empty($_POST["searchField"])) { $search=$_POST["searchField"]; foreach( $tableArray as $tblArry) { $out ...
-3
votes
1answer
39 views

Finding users with database owner role in sql server 2005 or so [duplicate]

I need a script which will list out all the users with DataBase Owner persmission for a specific database. Thanks
0
votes
1answer
25 views

MySQL InnoDB Deadlock For 2 simple insert queries

I have a deadlock for this two insert queries: insert into PlayerClub (modifiedBy, timeCreated, currentClubId, endingLevelPosition, nextClubId, account_id) values (0, '2014-12-23 15:47:11.596', 180, ...
-3
votes
0answers
50 views

Server CPU usage Issue [on hold]

I have a Database on MS SQL SERVER, The MDF file size os near about 30 G We have web application where this database is used. & while monitoring Live server, I Seen when number of User increase on ...
0
votes
1answer
23 views

SSIS import with header record

I have fixed length text files that I have to import into SQL Server daily. These files contain header records (01) and Detail records (02). I am trying to build an SSIS package to do this. I have a ...
3
votes
1answer
80 views

Effects of turning the transaction safety OFF

I am considering to turn off the transaction safety to maximize the performance. Before that i am interested in finding the current status of transaction safety. Is there any command that we can get ...
1
vote
0answers
29 views

Transactional Replication - Replication Order of Related Tables

** This was previously asked on Stackoverflow - I removed it from there and recreated here ** I have an issue with SQL Server Transactional Replication. My topology is as follows (and this cannot be ...
-5
votes
0answers
47 views

Incorrect syntax near the keyword 'AS' [on hold]

string strQry = @"declare @state varchar(max) declare @query varchar(max) set @state=(Select State from CandidateInfo where Id=1501000040) set ...
0
votes
0answers
18 views

Usage of temporary tables in my tempdb database on sql server 2005 [duplicate]

I am trying to resolve the disk space issue on one of my drives where tempdb residing occupies more than 100 GB: Stats shown below I read some similar post on the same and i found few queries using ...
0
votes
4answers
23 views

Pros and cons of a particular DB design approach for single vs multiple tables

I just got a new project (in JAVA) where I am thinking of all the pros and cons of a particular DB design approach. Some pointers: Our app has many "content" entities like News, Blogs, CMS pages, ...
0
votes
2answers
31 views

SQLPlus : default define settings

My workstation is Ubuntu 14.04. I have Oracle Express 11g installed. Whenever i run the define command in SQLPlus, is see the define _editor = "ed". Is there a way to change that permanently to gedit ...
0
votes
0answers
28 views

CodePlex: SQL Server Partition Management Tool [on hold]

I have implemented partitioning on a table and now I want to use the CodePlex Partitioning Tool to create my staging/archive table, with the intentions of wrapping it all in a "Sliding Window" job. ...

15 30 50 per page