1
vote
1answer
441 views

How to perform a multiplication by a different select query

Hope my question is accepted here and I haven't made a mess out of renaming the tables and columns so you can understand what I need! :) Query A: DECLARE @var VARCHAR(7) SET @var = 'xtpo' SELECT ...
16
votes
1answer
990 views

24x7 vs Night Time Window

Where can I find resources on how to better move to a 24x7 operation? How do the big companies with big databases accomplish this? Our nightly jobs such as purge old data reindex update ...
0
votes
1answer
110 views

How can I normalize this database?

I've got legacy ecommerce database, which is awfully designed and I need to move all products from it to new solution. But I stuck with how product properties stored. So it basically has tens of ...
3
votes
1answer
390 views

Determine the currently executing statement in a long running PL/pgSQL stored procedure

I have a long running PL/pgSQL stored procedure in PostgreSQL. How can I determine the currently executing statement in it?
0
votes
1answer
79 views

Performance on updating row

When updating in SQL Sever, it is my understanding that the entire row is deleted and then recreated (which is why you get a new timestamp). So then, if you update 1 field or 500 fields, does the ...
0
votes
3answers
177 views

From freelancer to team of two : best way to share/sync db?

I am a webdev. I have just hired a dev. Before that I was alone. Thus, I have to change a bit my organization. I am looking for the best way to develop on the same database (MySQL). I am considering ...
0
votes
1answer
928 views

Mysql Innodb as Key value store, performance

I read about NoSQL databases using Key value pairs (KVP) tables. So i wanted to find out if KVP tables would be faster than conventional relational tables (with multiple columns) in mysql with innodb ...
3
votes
1answer
121 views

MS SQL Server using SSL Connection over the Web?

I'm looking to have an external SQL Server 2008R2 Express instance and be able to connect to this via SSL using a 'sql.my-domain.com' address. So far, I've looked at a few Microsoft links on the ...
0
votes
2answers
43 views

mysql replication

I have a master mysql server (M1) with two replicating slaves behind it. I also have another master mysql server (M2) with it's two slave servers. The slave servers currently replicate everything from ...
0
votes
0answers
97 views

Overcoming the HDD IOPS limits on a billion row table? Is getting SSD the only solution?

I have a table with this structure: CREATE TABLE `requests` ( `userid` int(11) NOT NULL, `messageid` int(11) NOT NULL, `queueid` int(11) NOT NULL AUTO_INCREMENT, `problem_id` int(3) NOT NULL, ...
0
votes
1answer
1k views

Support to SQL Server 2000 from Visual Studio 2013(SQL Server 2012)?

I can't access to a database created by SQL Server 2000 from Visual Studio 2013, I asked this before in StackOverflow, but I don't get an useful answer: ...
2
votes
1answer
104 views

What is happening with locks in my database?

I'm having some problems on my database. At any given time, I'm trying to execute an update with five records on my table, but this table is locked and I get a time out executing the query. I ...
1
vote
3answers
483 views

What happens when we take a timediff between timestamp and datetime

Say I have following table in mysql (5.5+): CREATE TABLE IF NOT EXISTS `test` ( `id` int(11) NOT NULL, `x_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, ...
1
vote
2answers
4k views

SSIS Package Truncation may occur due to inserting data from data flow column

I've a dataflow in SSIS 2008. It reads the data from flat file and inserts in to database. The flat file is CSV. For some reason, all the fields in flat file connection manager seems to have 50 ...
2
votes
3answers
176 views

How to make stored procedures more readable without harming performance

I come from OOP background, and I need to write and maintain huge stored procedures. Naturally, the sprocs become quite unreadable very quickly, no matter how much I try formatting, giving readable ...
1
vote
1answer
2k views

Oracle 11g DBMS_CRYPTO invalid identifier

I'm trying to encrypt a column and I found many tutorials that use DBMS_CRYPTO. However, when I test this, it says DBMS_CRYPTO is an invalid identifier. I was using SYSDBA account. I've searched the ...
2
votes
2answers
573 views

What are the options of reducing tempdb latency?

Took the job of monitoring and tununing a SQL Servers 2012 Enterprise Ed. SP1 (64 bit) on Windows Server 2008 R2 Standard Ed. All of them are running inside virtual machines. One SQL Server per a ...
0
votes
1answer
60 views

What are the compelling resons to update SQL Server name to a real one after its changing?

Took the job of monitoring and tuning a few dozens SQL Server 2012 Enterprise Ed. SP1 (64 bit) on Windows Server 2008 R2 Standard Ed. running inside virtual machines. All of them on running ...
3
votes
2answers
6k views

How to create a server alias in SQL Server 2012

We have a Windows Server 2012 server running with 2 instances of SQL Server 2012 installed on it - Live and System. Both instances are accepting connections on 1433 & Live is the default instance ...
0
votes
1answer
140 views

Use SQL Server Database Mail with Amazon SNS

Is it possible to configure SQL Server 2012 Database Mail (hosted on EC2) with Amazon SNS? I'd love a single place to manage all alert notifications and their subscribers in SNS, but Database Mail ...
0
votes
0answers
2k views

SQl Server 2012 Powershell script to generate database with schema and data

Using Sql Server 2012, could somebody be so kind and show me a simple powershell 3 script that generates my entire database (schema and data)? I tried this one: $Filepath='d:\b\t' # local directory ...
0
votes
1answer
36 views

String templating technique

I am working on a fitness app that is going to deliver notifications to the user. I intend using MySQL events to populate the necessary tables, and then using an Ajax timer or Websockets or whatnot to ...
1
vote
1answer
47 views

Best way to handle column that doesn't conform to one particular type

I have a Settings table: CREATE TABLE `Settings` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Code` varchar(100) NOT NULL, `Name` varchar(250) NOT NULL, `Description` text NOT NULL, `Default` ...
0
votes
1answer
363 views

Importing data from MS Access database to an existing Postgres database

I'm developing a Django based website with a Postgres DB. The problem I'm having is importing the data from an Access DB into it. To be specific, I'm not trying to translate/import the schema from ...
3
votes
1answer
71 views

Which items are table entities and which are fields?

I'm a mystery novelist with a series of three books that will end up at around 20 novels. I am having trouble getting the tables and fields sorted out. I want to be able to: create a list of all ...
3
votes
1answer
154 views

Suppressing the SSMS prompt to save changes

Is it possible to configure SQL Server Management Studio (SSMS). so that the dialog box shown above does not appear when I close an unsaved query window?
0
votes
2answers
73 views

SQL Server replicated databases swap

I have a SQL Server 2012 database. I would like to be able to make changes to this database or to it's replication, then make the replica, the real one. The point here is to have 0 downtime on ...
2
votes
2answers
124 views

Oracle database Architecture

I need to know to correct order between these following steps, it's hard to find information on the internet on what happens first, i'd be really grateful if someone could give me the answer A. ...
3
votes
4answers
5k views

Select rows based on latest date with multiple joins

I have this query (SQLFiddle): SELECT c.name, a.user_id, a.status_id, a.title, a.rtime, u.user_name, s.status_name FROM company c LEFT JOIN action a ON a.company_id=c.id LEFT JOIN user u ON ...
4
votes
1answer
3k views

SQL Server 2012: Generate Scripts from command line

I am running SQL Server 2012. The SQL Server Management Studio has the option to right click on a database then select Tasks and Generate Scripts. Is there a way to automate that via command line ...
-1
votes
4answers
32k views

How to determine if an Oracle table is locked or not?

We've been using BI software and a repository database that are installed on Oracle Enterprise 11gR2. Some of these batch reports will try to access a database table which may still be locked. How ...
5
votes
1answer
2k views

How to reclaim disk space on PostgreSQL?

I have local installation of 9.1 database with few tables which had cca. 300 mio records and the database grew to about 20 GB. Afterwards I issued delete from command to delete all records from it (I ...
0
votes
0answers
81 views

Detecting changes in a table without enabling CDC [closed]

We are doing a transaction based on a weekly basis, where the first transaction is recorded on 1-Jan-14 in the table a. Subsequently, the second transaction that was done on 8-Jan-14 also got ...
1
vote
0answers
700 views

SQLite Design: Better to have many tables with few columns or few tables with many columns?

I am struggling to figure out the best design for a Sqlite database that will hold data about Facebook pages so that I can calculate benchmarks for how the average Facebook page performs. I have an ...
0
votes
1answer
292 views

Reset Variable when row value is changed

Below is an example of a SELECT statement. I have a variable @total that is set to 0, which works fine if I am doing a WHERE clause but I need the final total for each agent. Currently how this works ...
-2
votes
1answer
107 views

how to count result set for select statment [closed]

I have to make query from DB. I found some solution but it isn't so precise as it need to be. Here result of my query: country weight Germany 1687.5 Gt.Britain 1687.5 Japan ...
1
vote
1answer
479 views

“Scan interface error” when connecting to a DB2 database restored on a different server

I restored a database backup taken on a different server using this script: FORCE APPLICATIONS ALL; RESTORE DATABASE MY_DATABASE_NAME FROM /backup/db2inst1 TAKEN AT 20140104051657 ON ...
0
votes
2answers
121 views

I can't import my database into mysql

I have a website based on drupal and I tried to export its database via both Backup wizard and phpmyadmin. the database was exported but I can't import it on my localhost database.this the error ...
2
votes
1answer
272 views

Getting each status change in a table

I have a table that holds status changes per item. The item can go in and out of a status multiple times. ItemTable (ItemId int, Status varchar(50), DateOfChange date) I need to pull the date of ...
4
votes
2answers
331 views

How can I enforce ensure uniqueness of an association with a time dimension?

I have a database table AB which tracks the association of A and B over time: create table AB columns ( ARef ..., -- FK of A BRef ..., -- FK of B Since as Timestamp, Until as Timestamp, ...
3
votes
1answer
50 views

How to show the related (suggested) keywords?

We do a program for cataloging images by assigning keywords (tags) to them. An image has the following keywords "John", "Jane", "Portrait". Another image has the following keywords "John", "Jane", ...
3
votes
3answers
2k views

Allow update access to only 2 tables in a database schema

I would like to have a login which is capable of accessing a specific schema but should be having only update access to 2/3 tables. Is it possible? The Database runs on SQL Server 2008 R2. Kindly ...
1
vote
0answers
260 views

Missing rows in MyISAM tables with 10-20 billion records

I've got 2 tables with 10-20 billion records each. Currently these are in MyISAM (MySQL). They only require to be built and indexed once, after this only SELECT is used. They are currently ...
0
votes
1answer
408 views

Problem deleting detached partition in DB2 LUW V9.7

Recently in prod environment we are having problems while dropping the detached partitions its giving this error """ DB21034E The command was processed as an SQL statement because it was not a ...
0
votes
1answer
1k views

PostgreSQL user permissions

I have a PostgreSQL 9.3 database with the PostGIS extension backing a web application and GeoServer. I have created three users. A read only user for accessing the data in the reference data schema. ...
3
votes
1answer
400 views

Replace MySQL table with data from csv

I have a CSV file on about 200 MB/1 mill rows, which is updated every night. I need the values from this file available in a MySQL table. I get this working by using LOAD DATA INFILE filepath REPLACE ...
0
votes
1answer
142 views

How can I use package classes and call packages from Oracle11gr2 stored procedure in certain schema?

When a stored procedure begins with 4 create or replace procedure user0.import 5 is 6 f1 utl_file.file_type; compiler throws an error Error(6,6): PLS-00201: identifier 'UTL_FILE' must be ...
0
votes
0answers
301 views

ClassNotFoundException when trying to deconfig Oracle Enterprise Manager

The Enterprise Manager for my Oracle 11.2 installation doesn't work anymore as described in How can I change the connection descriptor used by Oracle Enterprise Manager? and I tried to re-configure it ...
0
votes
2answers
49 views

Combine tables only if no results

We have a table FOO that has a huge amount of data in it, most of which is only used infrequently and by (slow) user-interaction. We would like to move all data that is more than 12 months old to an ...
1
vote
3answers
150 views

Creating a copy of primary database and attaching the copy database in the same sql instance

I just got into a project in which we have only one SQL Server 2012 copy. We have 12 databases attached to the primary instance of SQL Server 2012. As I don't have SQL Server 2012 or supporting OS, I ...

15 30 50 per page