0
votes
0answers
4 views

Can user defined roles cause problems with colliding permissions?

I recently ran into a problem with an application crashing accessing a SQL Server 2008 database. An "APPCRASH" was recorded in the Event Viewer, but I have little else to go on. The tables are owned ...
0
votes
0answers
5 views

Adding a second database to the same instance of a server

I already have a multi user software program running on Windows 7 work stations and the server is running Windows Server 2008r2. I am trying to setup another program using the same server. The code is ...
0
votes
0answers
8 views

Find out beforehand how many records a query has

I develop reports in ExtJS resulting of queries in MSSQL 2012. I use Ext.Grid with paging, therefore I can use offset to limit the amount of records a query will return. But for this ExtJS feature to ...
0
votes
0answers
7 views

Extract timestamp from UUIDv1

Is it possible to extract timestamp from uuid version 1 in PostgreSQL? I am also curious is it possible to order by uuid's timestamp value like it's done in Cassandra's TimeUUID datatype?
0
votes
1answer
10 views

soccer leauge er diagram

i am planning on creating a database to track teams and players in a soccer league. the stats i wish to track are as follows... goals scored/conceeded(gk), assists, minutes played, cards received and ...
0
votes
0answers
7 views

How to determine is a value exists in a column within a partition

I have a set of data where I need to look at partitioned data and determine if a value exists within that partition. Example data: AccountNumber Code Status Credited ...
0
votes
2answers
29 views

Quickly clone a database in SQL Server Management Studio

For testing purposes, I often have to clone databases (onto the same server). Currently I do this by creating a backup and restoring it as a new database. I would love to have such a functionality ...
0
votes
0answers
12 views

Best practices for generating a tnsnames.ora entry

I need to integrate some scripts that export and import data from Oracle databases. They are shell scripts that rely on the TNS name being set up (e.g., scott/tiger@tns). The application owners are ...
0
votes
0answers
2 views

Decision Tree English Rules and Dependency Network in MS SSAS

I created a Decision Tree model in Microsoft Analysis Services (SSAS, Visual Studio 2010). There are two tabs in the Mining Model Viewer tab: (1) Decision Tree that shows a tree itself, and (2) ...
0
votes
1answer
12 views

Can't cast a SPROC parameter?

I have several sprocs that take a date/time input, one of which takes a date only in the form of an nvarchar because it utilizes dynamic SQL. When I try to cast the variable going into the sproc I'm ...
0
votes
0answers
14 views

IMPDP twice with same Oracle EXPDP dumpfile with different results?

At my work, we receive data in the form of an Oracle dumpfile generated by an EXPDP command using Oracle DB 11.2.0.4.0. We import it using IMPDP into an Oracle DB (same version) set up with roles, ...
0
votes
0answers
6 views

pg_restore certain tables only

I'm looking for a way to use pg_restore to restore a newly-created database from a dump file, but only certain tables from that file. (There are a lot of extra tables in the database that are slow to ...
0
votes
0answers
9 views

Issues with Optimizing TSQL Script

I have a temp table that has a SecurityCode column. This SecurityCode column gets updated based off value from CrossReference table. The value selected from the CrossReference table depends on how ...
0
votes
1answer
22 views

Need to query records based on Date only (Sample Query given)

sSQL = " SELECT ordID, ordName, ordDate, ordShipping, ordStateTax, ordHandling, ordTotal, ordDiscount, ordPrivateStatus FROM orders WHERE (ordStatus = 7) " I want to display orders that ...
0
votes
1answer
19 views

Counting SQL Server Transactions

Is there a method to count total transactions by type (read/write) by day/hour/peak? ...
0
votes
1answer
22 views

SQL weight multiplication

Hi all i have two columns in a table : +--------------------+----------------+ | Units/Pk | PackWeight/Vol | +--------------------+----------------+ | 1.0000000000000000 | 150g | ...
0
votes
0answers
8 views

Broken foreign keys on MySQLWorkbench forward engineered db. Table creation order matters?

I recently generated a forward engineered database script in MySQLWorkbench. The script wouldn't run, and by pasting chunks in the shell interpreter, I determined that a particular table was causing ...
0
votes
0answers
22 views

changing SQL data types from varchar(50) to smaller rational types increases table space

in my case i want to understand why changing varchar(50) types to optimized smaller types caused the table containing 61065164 rows to grow from 3.1 GB to 4.46 GB and not get smaller as expected. ...
0
votes
0answers
13 views

Convert Teradata Database to SQL Server 2012

I am just wondering if anyone has any experience, knowledge, or recommendations on migrating a Teradata database to SQL Server 2012. I have never worked with Teradata before so I am unfamiliar with ...
1
vote
1answer
18 views

Non-sequential Primary Key performance in PostgreSQL 9.3

Due to requirement to support distributed environment, each of my clients has been assigned unique node id, it appends the node id with running number as primary key and stores at local database. E.g. ...
2
votes
0answers
25 views

When does SQL Server acquire locks?

The list of isolation levels in SQL Server found here states that write locks acquired within a transaction are retained until the end of the transaction. However it doesn't mention anything about ...
1
vote
1answer
31 views

PostgreSQL SELECT primary key as serial or bigserial query review

I've meshed together a way to determine what the data_type is as in the data_type you use in the syntax when creating a new table (not the political definition) based off of the PostgreSQL wiki page ...
1
vote
1answer
30 views

Cannot install SQL Server 2012

I'm trying to install SQL Server 2012 on Windows Server 2012 Standard and got this message: SQL Server Setup has encountered the following error: The resource ...
0
votes
1answer
13 views

Footer with counter of records, using union of query

I have a report that has a header (display the current date), I use UNION to join the header with the main query that returns multiple records, it has 10 columns. After that another UNION for joining ...
0
votes
0answers
9 views

What could cause the built-in NT Service\SQLAgent$ identity to be unable to connect

Something has happened, I don't know what, which has caused our nightly scheduled (maintenance plan) backups to begin failing. They were working, but then, started to fail. The error is shown below. ...
0
votes
0answers
6 views

Will coloum size change when trying to use single unicode character in place of multiple ASCII characters?

I have a column in utf8_unicode_ci collation for text type in MySQL. The content is in Unicode, I have used tags like {br}, {v}, {t}, {h} etc.., throught the database. I am now thinking of changing ...
0
votes
0answers
9 views

How to optimize search restricted by boolean column?

I want to optimize a query1 of the form SELECT yid, xid FROM x WHERE is_principal; Here, is_principal is a non-null boolean column of x. If I run EXPLAIN QUERY PLAN on this query, the output I get ...
0
votes
0answers
12 views

database_quiestion_determine_2NF_3NF

I solved this example to determine 2NF and 3NF. I would like to check if my answer is correct. Can somebody check the 2NF and 3NF of this example, please? R( A B C D E F G H I J) with functional ...
1
vote
1answer
44 views

Table size is not changed after new column is added

I am trying to check how the table size is going to be increased after adding new column with default values. I use the following default values: NULL, ''(empty string) and some text(some random ...
0
votes
1answer
16 views

Add linked server from SQL-Server to MySQL: “Data source name not found” (Error:7303)

I'm trying to link my SQL-Server 2005 on Windows Server 2008 R2 with MySQL 5.5.40 on a different computer. I have followed this guide: ...
0
votes
2answers
38 views

SQL Multiple JOINS Interpretation order

I have a big problem of using multiple joins in one SQL Statement. For example i have 10 Tables which they are tbl1,tbl2, tbl3,..,tbl10. I would like to select some columns from each table from tbl1 ...
-2
votes
0answers
7 views

off-site Dataguard replication status check [on hold]

Kindly assist with step by step approach for monitoring replication status from our Primary to Secondary Data Center. A short script or command that can accomplish this task will be appreciated, ...
0
votes
0answers
10 views

Query optimization to redis

Have next problem. Data stored in redis store like this(example): application_1::version => 1.0 application_1::branch => master application_1::name => some_application ... ...
0
votes
0answers
2 views

How to get all documents from a particular chunks in MongoDB?

From mongos log, I got the following message balancer move failed: { chunkTooBig: true, estimatedChunkSize: 408839903, ok: 0.0, errmsg: "chunk too big to move" } from: shard4 to: shard1 I know ...
1
vote
1answer
21 views

Alternate per 2 postgresql rows, but start over if there are rows remaining

I'm trying to select below table, grouped by two (=max, if there is only one, show one) of each supplier_id. But, after all suppliers are selected it needs to start over. So this is the table: Table: ...
0
votes
1answer
30 views

Combine two updates [on hold]

I want to combine the following SQL statements into one: Update ENGROYLIB/UCOMPFL Set AddrLn1 = 'ELECTRIC LIGHTING STATION,', AddrLn2 ...
0
votes
1answer
16 views

Does DB2 support host based access control?

Coming from MySQL I was wondering whether DB2 has something similar to MySQL's user@host access rights concept.
0
votes
0answers
7 views

Mongo Memory mapping file size issue

I am witnessing some performance issues in my Mongo Sharded cluster. I checked the serverStatus for the memory uses on my shards This is the output Shard one Primary RAM size 512 GB "mem" : { ...
1
vote
1answer
14 views

Purge mysql log bins older than two weeks automatically

I have to manually write purge binary logs bin to "mysql-bin.somenumbers" ; Once in a while, I need to reduce the spaces that binlogs are taking on my web server. Is it possible to purge binary ...
0
votes
1answer
27 views

Taking time to create Materialised view becuase of functions in the main view [on hold]

due to one of the function in their side, it taking long time to create a MV but later, they commented it and given to us, but after that, they inserted this function again and now the ...
0
votes
3answers
38 views

Problem to access the SQL Server

I have SQL Server 2005 which is installed on server machine. I was working fine on SQL server before I change the server machine IP. I changed server machine IP to host the Web Service on it. But ...
0
votes
2answers
29 views

How to select the largest value of the same column in multiple tables?

I have multiple tables which have some columns with the same meaning, eg., event_timestamp. The schemas are like following: Table A: ...
1
vote
2answers
28 views

Oracle RAC Failover functionality clarification

we are running two node active/active Oracle11g R2 RAC cluster i need to replace public network cables on each node. I am planning to do as given below: Setup: OS: oracle Solaris 11.1 Sparc ...
1
vote
1answer
18 views

#2014 - Commands out of sync. you can't run this command now. Query was working before. But now it is not working

My table structure is ... There is Counter which has many Box in it. Box has a one BoxType. and Collection stores Box datewise revenue and data. I need data of particular 1 COUNTER (Data of All the ...
0
votes
1answer
18 views

How to Audit 2 or more SQL Logins (server principals) using SQL Server Audit

I need to audit the few SQL Server Logins, I have used filters while creating Server Audit by using CREATE SERVER AUDIT [audit123] TO FILE ( FILEPATH = N'D:\' ,MAXSIZE = 2048 MB ...
0
votes
1answer
19 views

Alternative to RDBMS: Modeling Exam/Testing data

I'm a born and bred relational database guy and C# programmer dude. IBM DB2 & VB.Net in school. TSQL & C# at work. I'm planning a project for fun: Designing a Testing platform that goes from ...
0
votes
1answer
13 views

Transfer data from SQL Server to obiee

I need to transfer data on a daily basis from a SQL Server 2008 R2 database to Oracle Business intelligence. What's the best practice? Db link? External table? Odbc?
0
votes
2answers
27 views

import csv file into mysql with custom data change

I have a .csv file contains data like this: Username Password Email test123 123 test@foobar.com I'm currently using MySQL, and I have a table named user with some columns like this: ...
1
vote
0answers
19 views

Is there a way to call sp_spaceused in a WHILE loop?

A legacy Sybase script moves records from production to archive in 1000-row batches, but it does not check for space exhaustion on the archive. Is there a way, maybe by calling sp_spaceused, to ...
0
votes
0answers
24 views

Can I optimize a left join for a single match?

Consider a join A LEFT JOIN B ON A.id = B.a_id: B.a_id is nullable -- most but not all B records point to an A record. A can, at most, only have one matching B record (business logic). Not all A ...

15 30 50 per page