0
votes
1answer
914 views

How to create multiple graphs with TitanDB (+Cassandra) in the same machine?

I'm experimenting with TitanDB (with Cassandra as storage) + Rexter. I've been reading the documentation during hours and trying to create multiple graph DBs on the same machine, but I didn't find ...
18
votes
3answers
2k views

When to use CDC to track history?

SQL Server Change Data Capture is a feature that reads historical data from the SQL Server transaction logs and stores them in a special table. Through the use of special table value functions (TVF) ...
1
vote
1answer
3k views

stored procedure with multiple statements does not execute all statements when run from job

** see updates below I have a stored procedure (SQL Server 2012) that deletes old records from a table, then inserts new records from a view to synchronize the table with the view. When I execute the ...
1
vote
1answer
815 views

Data History Table vs Using a Current Record Flag [closed]

There are two strategies when dealing with data records which contain multiple versions. One is to have current records in one table, and their past versions in a history table. The other is to have ...
1
vote
1answer
442 views

How to aggregate pairs of id values into groups

I have a table with two id columns id1 and id2. Each row shows that 2 id values have been linked together. My actual data has both id columns as varchar(20) but I have used integers in the example ...
2
votes
3answers
4k views

What are the risks of copying MDF/LDF files without detaching the DB first?

Where DB backups are not available, our support team has been trained to restore using the following steps: Get a copy of the MDF/LDF from a file system backup. Stop the instance. Overwrite the ...
0
votes
2answers
2k views

How to trace a MySQL session like in Oracle

I have an application running in MySQL 5.1.58 community edition. My application is working fine, but suddenly any query stuck and then after all queries is getting logged in slow query log. I am ...
1
vote
1answer
255 views

Delayed availability of historical data when using CDC

I am using the SQL Change Data Capture feature to retrieve historical data from my tables. During testing, I noticed that when I insert/update a row and query the change data right afterwards (see my ...
1
vote
1answer
253 views

Make MySQL dump from parts of each table

I need to export some data from different tables. I tried this query select * into outfile 'C:\Users\\User\\Desktop\\ololo.sql' from db.users where id % 2 = 1; After this query, the SQL file was ...
0
votes
0answers
67 views

SQL Server consistency I/O base error

I have received this error while performing queries on a database (SQL Server 2012) msg 824, level 24, state 2, line 1 sql server detected a logical consistency-based i/o error. Incorrect page ID ...
0
votes
0answers
567 views

database filesystem backup error

I get this error earch time: postgres=# select pg_stop_backup(); NOTICE: pg_stop_backup cleanup done, waiting for required WAL segments to be archived WARNING: pg_stop_backup still waiting for all ...
1
vote
2answers
523 views

How to retrieve the Capture Instance for a given table?

Working with SQL Server 2012, I have a hierarchical table layout (TPT). All tables "inherit" from the same base table (dbo.DataObjects). All tables have history tracking via CDC enabled. I am trying ...
1
vote
0answers
1k views

Solved Mysql connection lost with HAProxy

I have master-master replication with mysql. and haproxy configured front of my master-master replication. When I connect my replication via HaProxy, mysql says that "MYSQL has gone away". But when I ...
1
vote
2answers
1k views

psql: id SERIAL PRIMARY KEY not starting with 1?

This is something I don't understand, can somebody explain? I create a table CREATE TABLE cali (id SERIAL PRIMARY KEY, ALK_from char, ALK_to char, AND_from char, AND_to char); Then ...
0
votes
0answers
1k views

SSIS and Script Component - WebReference problem

Within my SSIS package-dataflow I have a script component and within this component whenever I add a Web reference and close editor, script component gives me "Validation error. Data Flow Task ...
1
vote
1answer
76 views

Postgresql view how to do the query

I have 4 tables: Project: id name Keyword: id, name ProjectKeyword: project_id, keyword_id (project has many keywords, keywords has many projects) ProjectReport: project_id, keyword_id, ...
0
votes
1answer
64 views

Postgresql create database from backup programmaticly [closed]

I got a big problems here. Let's say I got the table A (with columns like id, name etc) in the main database. So when I making INSERT into A I need to create new database lets say B_id. I got .backup ...
1
vote
2answers
325 views

Restoring the superuser account on the postgres server

I have a complete curious situation with a postgres dbms. I have installed the database and due to a misconfiguration of my installation scripts I made the superuser role to be a regular user. Now I ...
0
votes
1answer
79 views

EMStagePatches_$ORACLE_SID is using up space

We have this directory: $ORACLE_HOME/EMStagePatches_$ORACLE_SID We are running out of space and this directory is using up a lot of space. Is it safe to delete it? I think it is something to do ...
0
votes
1answer
541 views

MySQL 5.1.x: Performance improvement in Enterprise edition Vs community edition

My application is running on MySQL 5.1.58 community edition. I tried to search enterprise edition of MySQL 5.1.X but only MySQL 5.6.X version of enterprise edition is available. Is it possible to ...
-1
votes
2answers
605 views

Create Table Script in SQL Server 2008 R2?

When I Generate a script for Particular table in SQL Server Extra line is added in my Script What is the purpose of that line in SQL Server 2008 R2? Thanks. PAD_INDEX = OFF, ...
2
votes
1answer
690 views

Are TCP loadbalancers an alternative to Postgres 9.X read slaves load balancers like pgPool II or pgBouncer?

To scale read traffic on PostgreSQL streaming replication slaves, I want to be able to load-balance the requests. Postgres documentation suggests using tools like pgPool and pgBouncer, but I am ...
2
votes
0answers
62 views

Problem with reaching second normal form in a database

I'm currently taking an Databases/Database server course as a part of my education, and for this week we have been assigned a simple project to complete. I'm facing a problem regarding normalization. ...
0
votes
1answer
146 views

Is not in (a,b,c) faster than where != a, b, c

When writing a query which is faster? SELECT * FROM table where column not in (a,b,c); or: SELECT * FROM table where column != a AND column != b AND column != c ;
0
votes
4answers
2k views

Stored Procedure result is not showing in Datagrid pane in Toad for Oracle

I have created a procedure in Toad for Oracle 12. When I execute the procedure it does not show the dataset in datagrid pane, while the procedure is being executed successfully. What I am doing wrong? ...
0
votes
2answers
353 views

Is it possible to know how many times a user connected to an Oracle database?

Is it possible to know how many times a user connected to an Oracle database? If possible where we can find this information?
0
votes
1answer
40 views

Database engine that share a row among multiple tables

I'm wondering whether exists any database engine that can share cells or rows amongst many tables. For example: TABLE Customer ( CID: int Fullname: nvarchar(50) Age: int ) TABLE Group ( ...
2
votes
2answers
2k views

How to do partition on a non clustered index column?

I have table ORDERS .Where there are Million rows in it .I need to add Pationed Index on Order to store data in one of two files based on the new IsLocked field.But when i checked table there is a Non ...
3
votes
5answers
1k views

Steps after restoring to a different server

We have a 30 GB Database on SQL Server 2008 R2 Standard Edition. Yesterday we backed up the database and restored it to a different Virtual Machine which has exactly the same specs as the previous ...
0
votes
3answers
224 views

Can we restrict the number of connections to a database in SQL Server?

I have a database on SQL Server. My web application contacts this database. Is there a way in which I can restrict the number of connections to this database through some settings on the SQL Server?
1
vote
3answers
3k views

Help with SQL Server Error “ad Hoc access to OLE DB Provider 'Microsoft.ACE.OLEDB.12.0'”

So we have an interesting issue where users are receiving the following error when attempting to query a view in SQL Server 2008 R2: Msg 7415, Level 16, State 1, Line 1 Ad hoc access to OLE DB ...
1
vote
1answer
97 views

Purpose of Nonclustered indexes in SQL Server 2012

(New to SQL Server) I am struggling to understand purpose of Nonclustered indexes in SQL Server. Read though MS documentation (both for v2012 and v2008 that has pretty pictures) and some online ...
1
vote
1answer
128 views

Difference between sql agent account logged in as NTLM and UPN?

Can someone please tell the difference between a sql agent account logged in as NTLM and UPN? What is the difference if the sql agent account is logged in as: domain\username and username@domain.com? ...
1
vote
1answer
264 views

Innodb buffer pool and multiple joins

assume we have 1 Billion records and want to store them in One or Three tables by post_type. post_id -> primary key post_type -> ( page, group, user ) user_id -> index date -> ...
0
votes
1answer
2k views

Cannot access Properties page of a database

I'm in the process of decommissioning a database server and migrating the databases from one server to another. I was attempting to get the the properties of the database and received a SQL Error ...
0
votes
0answers
83 views

Database migrated to SQL Server 2005 with 80 compatibiltiy from SQL Server 2000 experiencing locks

I am supporting an application whose code my company did not write, and was originally developed back in 2000-2002, by a company that no longer exists. The code, while not great to maintain, ...
0
votes
2answers
68 views

How to use keys in a table so two columns are unique

I want to create a basic database that handles photos. Also, i want to show a photo of the day to the user. I´ve created a table called ´photo´ and another table ´photooftheday´, like so CREATE ...
7
votes
0answers
226 views

Why would function based indices I’ve created lower the cost but not show up in the explain plan breakdown?

Sorry for the terrible column/table names but since this is for a work project I wanted to insure it was OK to ask. I was just hoping to at least learn why I'm not seeing my functional indices being ...
0
votes
4answers
100 views

SQL Where Clause Efficiency

Say I have a SQL statement: SELECT * FROM MyTable WHERE KeyColumn1 = 1 OR KeyColumn1 = 2 OR KeyColumn1 =3 OR ... KeyColumn1 = 10 And another: SELECT * FROM MyTable ...
0
votes
1answer
175 views

Slow queries with many self joins in variable-column database

I'm creating a table structure which needs to handle a variable number of columns. To handle that case the table structure is a listing of cells with a column and row number. To view the table a ...
0
votes
0answers
14 views

In Amazon Redshift, running GRANT as a superuser does not grant privileges on table to a regular user [duplicate]

I'm trying to run a query in Amazon Redshift, but I keep getting the error permission denied for relation mytable As far as I understand, this is a privileges issue. According to this question: ...
2
votes
1answer
33 views

Splitting metadata inside Postgresql

I have metadata in a postgresql table that I need to split. So far I have been attempting to use Select col_name from "tbl_name" split_part('QGC|WGPLNW|IR|BBC|FCPC|WGPLNW|ARME|QPC', ", 1 | 2 | 3 | ...
1
vote
1answer
184 views

MySQL: SLEEP injection

I was wondering if someone could help to understand this query, basically I'm aware about SLEEP() function but I've never seen this implementation before. Why there are no any results returned? ...
1
vote
1answer
490 views

SQL Server - Service User Accounts and Licensing? [closed]

Maybe this is the wrong place to post, since its not necessarily sql server related, but here goes. If I want to setup some service user accounts in the domain to use to run sql services like the sql ...
5
votes
2answers
5k views

Find which session is holding which temporary table

We have a SQL Server 2005 database the temp database has become full. By going into SQL Server Management Studio I can see all the temporary tables in the tempdb. Is it possible to tell which session ...
0
votes
1answer
132 views

Nightly reload of tables from a linked server

I have a number of tables that need to be reloaded nightly from a linked server. My current method of doing this is to create a nightly job to pull the data using something like the following: ...
1
vote
1answer
1k views

Is there anyway to make this stored procedure thread safe?

I have a stored procedure that deletes X rows. This procedure is called by a Job Scheduler (Not SQL Server Agent) from one of three Azure Instances. The deletion task is run every 30 minutes from each ...
2
votes
0answers
192 views

Cross-talk with temp tables with SSRS over a shared data source?

I have a data source that is setup to store credentials on the report server and to use them when running reports. Given the following factors, I'm concerned about reports that use temporary tables in ...
0
votes
1answer
170 views

Is there any danger using binary data over an UTF-8 MySQL connection?

My application uses UTF-8 as the default encoding for all fields, and the connection itself; every connection starts with: SET NAMES utf8; I need to store a few SHA-1 hashes though, and for ...
0
votes
1answer
123 views

Comparing INT and NVARCHAR

T-SQL newbie here. I am sure you guys can help me with a little problem I'm having. Here's my situation: I want to do a select from a certain table. And with that select I want to display the count ...

15 30 50 per page