0
votes
1answer
85 views

4 tables, find department with the highest average salary [closed]

ABC is an organization operating in a certain country. Below are the data for the database that manages the information on this organization's employees: employee(employee_name, street, city) ...
1
vote
1answer
71 views

Trigger that records values for 5 columns from 3 tables when a value for column Z in table 3 is of a certain value

I am new to triggers and SQL in general. Sorry in advance if this forum is only for experts and this is a newbie question... I need to create a trigger that fires when someone tries to submit a ...
2
votes
1answer
163 views

Powershell Output Help

I have wriiten the following SQL script to execute using powershell. cls foreach ($svr in get-content "demo.txt") { $con = ...
0
votes
1answer
21 views

Selecting one variant out of different similar results

I have a table that looks as follows: Book Format Contents A html ... A markdown ... B html ... C markdown ... I want to return only 1 version of a book. ...
0
votes
2answers
187 views

what is a good use case for splitting user table by role

I have a requirement where there are primarily 5 roles in the system. Each of these roles increase in hierarchy from junior to senior most role. Each junior role is a subset of its immediate next ...
0
votes
1answer
205 views

Mysql Percona 5.6 slave lags gradually

I have got into slave lag gradually say every minute it lags around 5secs on slave. So it started morning 10AM the Seconds_behind_master was 13. Now at 4:30 PM it has reached to 560. No variable ...
0
votes
2answers
146 views

Writing Conditions in Left join sql [closed]

I want to know why these queries give different results Select * FROM Table1 T1 Left Join MyTable MT ON MT.studentId = T1.StudentId AND T1.class = 7 Select * FROM Table1 ...
0
votes
2answers
46 views

Timestamp to milisecond conversion

I am a beginner to mysql. I would like to convert a timestamp like this "12:00:00 AM.260" to miliseconds. The reference for the conversion will be "12:00:00 AM.000". How should i go about this ? ...
2
votes
1answer
68 views

Having problems with concurrency while trying to lock a record in custom messaging system (Queue)

We are building our own custom messaging system and are having concurrency issues. Here are the rules: A process (EXE) console application locks 3 records and returns them No other process running ...
0
votes
2answers
2k views

Adding Last 12 Months to a row in a table (SQL Server)

I want to add the last 12 months to a SQL Server table, something like the following: FixedText Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Please can ...
7
votes
4answers
1k views

At What Point Should I Split or Partition a Very Large but Simple Table

Our site has some large but simple (INT, INT, DATE) tables for stats. Each table has up to 300,000,000 rows, and gets bigger every day. The hosting provider has suggested that we split or partition ...
0
votes
2answers
732 views

In Oracle, how to get a list with the names of schemas that a user has read permission?

In Oracle, i need list which schemas a particular database user (or the current database user) has read permission. Based on this information, also need to get all the tables and views are in each ...
1
vote
1answer
1k views

MySQL: summary query for date activity by last 7 days, week and all year totals

I have a customer table with records like +-----+-------+-------------+-----------+ | ID | Name | Date | Status | +-----+-------+-------------+-----------+ | 1 | Joe | 2014.02.01 | ...
1
vote
1answer
899 views

Dropping multiple KEYS of a table

Dropping multiple KEYS in a table is a preferred option or one by one is preferred? “DROP KEY A,DROP KEY B,DROP KEY C" For more 900 million records in the table. How does it work internally?
-6
votes
1answer
364 views

normalization NF1, NF2, NF3 [closed]

Pls I need an urgent help ,Can you create a Student school Transcript normalization NF1, NF2, NF3 in excel..... I actually need for someone to help me create a database of " Student School ...
2
votes
2answers
175 views

Should I set document version field to be part of a primary key

Should I set document version as a primary key I am working on a document management system, and I have these two tables representing part of the whole tables. On the DocumentVersion table I have ...
1
vote
2answers
204 views

Mysql might have too many indexes

I am using the php framework Laravel for my application, together with mysql 5.6, in order to have full-text search with innoBD. But I am not sure if I have too many indexes. My application allows ...
1
vote
1answer
46 views

Having troubles creating table SQL [closed]

I'm new to SQL and Im trying to create a simple database, but I'm having problems with second one, I'm using Oracle Database express 11 and when I try to run this code I get error: Missing right ...
3
votes
1answer
134 views

How to create a Relation between a table and a many-to-many relation table

I am buildng a new database inside an Sql server 2008 r2.I have the following tables & business rules:- Skill that have predefined levels assigned to it, such as junior, senior, manager. Staff ...
8
votes
2answers
246 views

Are “out of the row” fields read when a clustered index is used?

I know that when VARCHAR(MAX)/NVARCHAR(MAX) columns are used the data is stored out of the row - the data row will have a pointer to another location where the 'large value' is stored. I have the ...
2
votes
1answer
110 views

Resource cost of a blocked query

I'm currently reviewing a case where an SSRS server is experiencing frequent blocking and deadlocking. The reports are not business-critical, and they are frequently killed to alleviate the blocking. ...
1
vote
1answer
1k views

Add a column with Not Null [duplicate]

I have a existing table in which i am adding a column as NgoId whose datatype is int. I want to add as NOT NULL to the column . When I'm adding this I am getting the following error: Unable to ...
1
vote
1answer
2k views

How to start Sybase server

I have installed Sybase(Developer's Edition for ASE 16.0) on a linux machine. I have executed the setup.bin file, and installed it using GUI. After this, I tried connecting to the localhost server, by ...
2
votes
3answers
626 views

mysql replication master 5.5 slave 5.1 error on create database

I have a replication system where my master has a mysql 5.5 version while the slave is mysql 5.1. I know that this is not supported because the slave version should be greater than the master, but we ...
4
votes
2answers
2k views

How to remove identity specification for multiple tables

I am having total 109 table in Database and now i am migrating to Amazon server with identity insert and now i want to remove auto increment column specification for all tables. How set auto increment ...
7
votes
1answer
3k views

Why not rebuild indexes with page count <1000?

I use Ola Hallengrens script for Index maintenance. Before I did that, I used the following query to see which indexes are fragmented most: SELECT dbschemas.[name] as 'Schema', dbtables.[name] as ...
2
votes
2answers
336 views

Count multiple tables as one count

I have seen how to do multiple counts for different tables, but never how to combine them all into one. I have a MySQL DB where I am running the following query: SELECT characters.name, COUNT(*) AS ...
1
vote
0answers
157 views

Connection error except with SQLYog

I have a problem connecting with the database with PHP or with MySQL in Linux . I can only connect to the DB with SQLYog. The error I'm getting is this: SQLSTATE[HY000] [2003] Can't connect to MySQL ...
5
votes
1answer
317 views

Chunk Size is shown as 1 KB in mongo db logs even it is set to 300 MB

I am running a mongo cluster. Chunk size set is 300 MB but for today morning it is showing me in logs taht chunk size is 1024 Byte. I checked in current op there also it is showing chunks of 1024 ...
1
vote
1answer
123 views

mysqld can't start without any info

mysqld can't start without any info, that is the only information I get is 'Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!'. I edited the my.cnf file to enable logging on ...
1
vote
0answers
231 views

Import a directory of dbf files to sql server

I am trying to import .dbf files using for each container in SSIS. But i keep getting errors to map the files and other errors. Here is what did. Use for each container. Use a data flow task in ...
4
votes
2answers
1k views

Join on dm_db_index_physical_stats very slow

I'm running a small query below in a MS Dynamics AX 2012 database and it runs more than 5 minutes which I had to cancel and it is showing PAGEIOLATCH_SH wait type. The database data file is 560GB and ...
4
votes
3answers
1k views

TNS-12541 Error

I have grid installed in my pc but the problem is LISTENER does not start automatically. I have to start listener manually and then only LISTENER get started. But before starting listener if you check ...
0
votes
1answer
4k views

sql server authentication login failed

I have SQL Server 2014 on my Windows Server 2012 R2. I can connect locally to SQL Server from Management Studio using Windows Authentication. I decided to switch to SQL Server Authentication ...
2
votes
1answer
8k views

Linking Fields From 2 Different Tables (Microsoft Access)

I am trying to link 2 fields from 2 different tables on Access but I will give an example to try and make the issue clearer. I have 1 table called "Employee Details" which contains the field ...
1
vote
0answers
52 views

Error 18456 State 38 on Deleted Databases [closed]

I deleted some databases but a service account keeps trying to access them. This is filling up my SQL Server errorlog file. I used profiler and got the names of the databases, but I do not know how ...
1
vote
1answer
737 views

Can't insert arabic text into mysql database using mysql prompt

I had a local table with arabic values.when exported i got the following query. DROP TABLE IF EXISTS `type`; CREATE TABLE IF NOT EXISTS `type` ( `bs_id` int(11) NOT NULL AUTO_INCREMENT, `types` ...
1
vote
1answer
300 views

High mysql throughput

on a big server with many user and website from 11AM - 00AM our mysql throughput reaised in max (60 - 80M) this timestamp our customer website load slowing . we have,'t any Disk IO , and server HDD : ...
0
votes
1answer
72 views

Cannot connect from computer to server database

I'm trying to connect from my computer to a server which has a SQL Server 2008 instance installed. My computer and the server are in the same domain and the name of the server is "SERVER". The ...
8
votes
1answer
312 views

unable to insert row at id, but row does not exist

Here is the weird problem i am facing. I am trying to enter data using following query insert into product_product (id, product_tmpl_id, make_equip, model_equip, name_template, serial_num_equip, ...
4
votes
2answers
100 views

Store Repeated Data

I have a table (Key tinyint, Value bigint). There are a billion rows for each distinct Key value and only about 100 distinct Key values. Is there a way to not have to store Key in the every row ...
1
vote
0answers
44 views

Is that create table statement correct? [closed]

Although i am not part of this community for long time, i already feel like you are my family, since thats what family does. We help each other. I am thankful to everyone who helped me! CREATE TABLE ...
2
votes
2answers
409 views

Foreign key set to cascading but fails to update - why?

As mentioned elsewhere, I am rather new to SQL and databases. Getting my hands dirty at the moment and trying all the different possibilities. I have a server running MySQL and set up the following ...
1
vote
1answer
171 views

mysql multi-source replication to single slave from Debian repo's?

I've been experimenting with mysql 5.7's feature to backup multiple sources to a single slave, but have legacy db's on source servers where I'm not sure if upgrading to 5.7 will break things, and also ...
10
votes
3answers
692 views

Avoiding multiple `or` expressions

I have the following oracle SQL and its works and all but it's quite ugly with all of the ors. Is there a more concise way of doing this? SELECT * FROM foobar WHERE (SUBJECT ='STAT' and TERM ...
2
votes
1answer
145 views

Duplicate table structure with different data [closed]

I am looking for a way to resolve a design issue with a Microsoft Access project that is being converted to use SQL Server 2014 as a backend. We have several Access backend files, two of them have ...
13
votes
2answers
527 views

Paging performance with customizable sorting over many millions of rows

In our application we have a grid where users can page over a large number of records (10-20 million). The grid supports sorting in ascending and descending order in a number of columns (20+). Many of ...
3
votes
1answer
840 views

View last several innodb deadlocks

I see that I can view the latest deadlock in mysql/innodb, but is there a way to view past deadlocks? We have two deadlock issues, one being important and the other not. The less important deadlock ...
1
vote
2answers
75 views

Separate login for user / administrators using mongodb

I have 2 separate groups of users on my website. One is user and the other one is admin. Currently I put them in 2 different collections user and admin and login respectively. My questions is: ...
4
votes
1answer
159 views

Schemas and user permissions

When our custom, home-grown CMS creates data tables using the GUI, it creates them against the site-specific user schema (i.e. sitename) instead of the dbo schema. The issue is that our ...

15 30 50 per page