0
votes
0answers
3 views

Fragmentation Eliminate From Table In SQL Server

How can we Eliminate Fragmentation from table in SQL server. is it improve performance of table(e. g. read Operation).
-1
votes
0answers
4 views

How to modify maintenance plan using T-SQL script in MS SQL Server 208

How to modify maintenance plan in sql server 2008 using tsql script I want to change the schedule of maintenance plan I want to change the path of .bak file all this changes are done by using t-sql ...
0
votes
0answers
12 views

Dumping stored procedure result to a text file programmatically

How can I save stored procedure execution result to a text file? I need to do this from SQL script (not Management Studio nor external utility) and I need to preserve correct characters encoding ...
0
votes
0answers
4 views

After Merge Replication Setup, tables at subscriber not getting any data from publisher

I have created the Replication Setup through Replication Wizard, After Sync, it is observed that the DB gets created with the Exact tables in Publisher as intended but At subscriber the table is ...
0
votes
0answers
3 views

table design approach for a rental application with several one to many relationships

I'm trying to go about designing a database/tables for the following situation I'm being presented. I'm developing a rental web application with MySQL as db engine. It is for a nonprofit organizations ...
0
votes
1answer
12 views

Mysterious inequality behavior when comparing date strings

Can someone explain this mysterious Postgres behavior? I'm performing the following queries at the psql command line. mydb=> select '20150526' > '2015-05-25'; -[ RECORD 1 ] ?column? | t ...
0
votes
0answers
2 views

How to subtract records from a table based on their existence in another

I have an Access 2010 table Assignment key Empl Number key Year Number key Week Number key Proj Number It assigns employees to zero or more projects for given work weeks, thus, all ...
0
votes
0answers
19 views

System.OutOfMemoryException SQL Server 2012 and 2008R2

I have a 64-bit and 64gb memory for both SQL Server 2012 and 2008R2, when I generate a report w/c has 900K rows, it finished the query smoothly and no problem, but when I'm going to copy the result ...
0
votes
0answers
7 views

SQL SERVER - Split Address Line [on hold]

I have a field that contains an address line that is like this Dr Robert Ruberry, West End Medical Practice, 38 Russell Street, South Brisbane 4101 I want to be able to select or create a view for ...
0
votes
1answer
12 views

designing a database with type and sub type

I am trying to build a publications database, and i want to develop a genre relation that has various (maybe look up tables) sub-genres attached. as an example, in the genre relation there would be a ...
0
votes
0answers
10 views

SQL Server 2012 Standard Cluster in a Box

We currently have a Microsoft SQL DB “cluster in a box” with two physical servers and a SAN. This is done with just Hyper-V and SQL Standard installed on the physical servers while having one ...
-1
votes
0answers
6 views

Filter several columns and order it from a table

I am looking to filter it for values 1 and 2 (door open/shut)… and ensure it is sorted in DATE and TIME order…. and finally by bus stop id. From that picture ... Anybody can help me with it? Thank ...
0
votes
0answers
4 views

Why is there a difference in CSV Export Results of Oracle SQL Developer and SQL Plus Spool

When I export data from SQL Developer GUI, setting format: csv, left enclosure: ", right enclosure: ", and Encoding: UTF8, I get data exactly the way that I need it for processing in Python. ...
0
votes
1answer
21 views

Script works but Im not sure this is the best format

I have a survey table which contains mostly integer. I want to make it readable for end user so I use select statement as below: SELECT CASE s.Country WHEN 1 THEN 'One' WHEN 2 THEN 'Two' ...
3
votes
1answer
18 views

Query the definition of a materialized view in Postgres

I'm wondering how to query the definition of a materialized view in Postgres. For reference, what I hoped to do is very similar to what you can do for a regular view: SELECT * FROM ...
1
vote
0answers
4 views

pg_restore fails with materialized view

I’m trying to pg_restore a db dump that contain a materialized views. If it is relevant, the materialized view is of a foreign data wrapper. It fails with the following errors: pg_restore: ...
1
vote
1answer
15 views

Long running backups on small databases

We normally perform backups across the network to a file share on a different SAN. This works very well for all but 1 of our database servers. The problem machine is a new server running Windows ...
2
votes
1answer
10 views

How to maintain a global index on a large table undergoing regular partition purges?

Problem I've got giant table haystack weighing in at nearly 3 TB, partitioned by month (date) and subpartitioned by client. I need to create a global index that spans all clients to facilitate ...
0
votes
0answers
4 views

WAL Streaming Failure PostgreSQL 9.4

I'm trying to setup streaming replication but I'm stuck, please help! I followed the steps in https://wiki.postgresql.org/wiki/Streaming_Replication On Master I have (postgresql.conf) archive_mode ...
0
votes
1answer
38 views

Using Like with variables?

I have an odd situation where I have a column called (TransmittalNumber) with datatype of VarChar (75) in a table named (Transmittal Sheet). I want to query this table to find the transmittal numbers ...
0
votes
1answer
16 views

Big Size Database and increasing number of users [on hold]

Me and my colleagues are using quite big size normalized database. Basically it's used for warehouse management and daily minimum 100 of the user perform data manipulation operations. 80% of the ...
0
votes
0answers
21 views

MYSQL taking 17.5 GB of RAM

This is what top shows how MySQL is taking a large amount of memory. VIRT RES SHR S 3967 mysql 20 0 17.5g 1.4g 7008 S 41.2 2.3 17426:16 mysqld this is ...
0
votes
0answers
13 views

Azure SQL Database “Login failed for user” in application, but works fine in SSMS

I wanted to try out the contained database users feature on Azure SQL Database V12, but I'm having a problem authenticating that seems odd to me. I created a database called Classifier. I added my ...
0
votes
0answers
12 views

SQL Loader Pass Dynamic Value

I'm newer to Oracle so I hope what I am trying to explain makes sense. I am required to used SQL Loader to batch load CSV files. There are about 20 organizations uploading around 15 CSV files each. ...
0
votes
1answer
26 views

How to store a version sequence per product

I need to create a table like the following one: +----+---------+---------+ | Id | Product | Version | +----+---------+---------+ | 1 | 1 | 1 | | 2 | 1 | 2 | | 3 | 2 ...
0
votes
0answers
9 views

When to use tags vs binary fields in a constituent management system?

I have a table of Constituents and I want to track yes or no qualities like: are they a teacher? are they an elected official? are they philanthropists? There will be less than a dozen of these ...
2
votes
2answers
47 views

Can't select 2 tables at the same time

I have a pesId (peopleId) column at pessoas (people) where is stored data from medics and patient. Also I have a table that stores medical consult information like Date, patient id, medic id and ...
0
votes
1answer
14 views

sqlplus not connecting to Oracle XE 11g

I installed Oracle XE 11g on my Ubuntu in vmware fusion. The oracle installation is all went fine but I am not able to connect the oracle database using sqlplus. I am getting this exception: $ ...
0
votes
1answer
13 views

SQL Server 2012 Error 9512 when modifying user login

We are attempting to grant access to a database to one of our employees. We open up his user properties in Security -> Logins, navigate to the User Mappings page, select the database, select db_owner ...
2
votes
1answer
28 views

Understanding & Resolving Deadlock in SQL server 2008R2

I am trying hard to figure out what may be going wrong for below shown deadlock graph: I am receiving alerts for deadlocks similar to above for almost every 10 minutes , its just the query changes, ...
0
votes
0answers
6 views

Why postgresql pg_dump exports a view as a table?

I am using postgresql 9.3 pg_dump tool for extracting only the public schema definition using: pg_dump -s -n public -h host -U postgres --dbname=db > ./schema.sql but when I check schema.sql one ...
0
votes
1answer
9 views

SSRS 2008 Security - can't run reports

I have SSRS2008 set up and running locally on the server (SRV0100). It is set up to run under the localsystem account for the service account (default). I changed the rsreportserver.config to use ...
1
vote
1answer
35 views

Permissions required to alter a database file

Totally at the beginning in administering a database. Using EMS SQL Manager ... latest version. How do I over come below ALTER DATABASE joneslocker2 MODIFY FILE ( NAME = joneslocker2, ...
0
votes
1answer
38 views

GROUP BY very slow when returning many rows

I have a query to aggregate data per day. When I run the query for a single day it is very fast. However, when I run the query for multiple days the time cost increases much faster than ...
1
vote
2answers
18 views

Troubleshooting high disk read - buffer cache query

I have a table tbl_Table1 that is about 5 GB in size and has millions of rows. It has these columns: ID, ContractID, Person, Address1, Address2, and many more. One clustered index on the PK, ID. I ...
0
votes
1answer
19 views

SSIS package hits “login failed for user” when simultaneous operations occur against the same target database

Quick summary We have been working on migrating our library of SSIS packages from SQL Server 2008 hosted on physical Windows Server 2003 to SQL Server 2012 hosted on virtual Windows Server 2012. The ...
1
vote
4answers
287 views

Improve delete speed for SQL Server

We have huge production database, its size is around 300GB. Is there any approach to improve performance of a delete query? Right now deletion speed is between 1-10k per minute, it is very slow for ...
0
votes
1answer
22 views

SQL Error (2027): Malformed packet

I have a mysql database (Version 5.6.23-log running on windows) that is set up for use with Teamcity. When running a command against it using HeidiSQL I am getting an error: SQL Error (2027): ...
1
vote
0answers
25 views

sp_send_dbmail causes session to hang

We had an issue in production (2008R2 SP3) yesterday, where a developer was running a piece of code in SSMS that was executing sp_send_dbmail inside a transaction, and including an attachment from a ...
0
votes
0answers
7 views

Exporting / copying a database with phpMyAdmin

I have a database on a hosting website so I am using phpMyAdmin to experiment with it, before I change anything I would like to make a copy of it or download it and look at it through MS Access or a ...
0
votes
0answers
19 views

Estimate the number of Tuples from relations

Quick question, and great help if possible: I have an exam tomorrow on a database module which I'm revising for, and one of the past papers had this question: Consider the following three relations: ...
0
votes
1answer
21 views

How can I delete all users except 1 [on hold]

How can I delete all users except 1 in mysql database in phpmyadmin.(it's a joomla 1.5 website database)
0
votes
1answer
13 views

Oracle 10 xe; backing up oradata folder enough to recreate a duplicate later?

Let us say, I backup of the the oradata folder. Is that enough to recreate the exact same database? E.g., I reinstall oracle xe 10 on the same pc, using the same installer, into the same folder, and ...
0
votes
1answer
20 views

Is it possible to select distinct values in a json document using PostgreSQL?

I have a column that is using the JSON type. I would like to perform a query to select all distinct records for a particular field in the JSON string: I.e. given these three documents { id: 1, s: ...
1
vote
1answer
22 views

Incremental (not differential) backup of SQL Server 2008 R2

Is it possible (out of the box or free software) to make an INCREMENTAL backup of SQL Server 2008. My problem is, the full backup and differential backup, backs up my 30gig database to 1 file. So ...
3
votes
3answers
108 views

Is Primary Key Non Clustered recommended?

I am designing a database table. Columns are RouteId ,Origin , Destination. RouteId is a string, it is always unique but length will be more than 60 characters. Since RouteId is unique, I am ...
0
votes
1answer
34 views

PizzaShop - DB - Normalized Schema

I am trying to make a simple DB in Access for a theoretical pizza shop(the db is for an assignment). What I am trying to do is link one type of pizza to one or more types of toppings. I just wanted a ...
-1
votes
0answers
21 views

Sequential file reading warning in datastage

When I try to load data from sequence file to oracle database, delimiter is '|', ETL Tool is IBM datastage 9.1, Compile was correctly, Load process finalize without any error,my issue is some rows ...
0
votes
1answer
13 views

Difference between “Table-Incremental” and “Table-Update” for “Population Type” when scheduling Full Text Index Population

I want to schedule a Full Text Index's population to keep it more up to date rather than leaving it to Automatic and not knowing the next population time as the users are complaining about the data ...
0
votes
1answer
16 views

Database with FILESTREAM enabled gives Error 3056 during backup

I have a SQL 2014 database enabled for FILESTREAM and I am getting errors 3056 during backup. The message is DESCRIPTION: The backup operation has detected an unexpected file in a FILESTREAM ...

15 30 50 per page