-1
votes
0answers
16 views

PostgreSQL Index [on hold]

Im using PostgreSQL and have a question about creating an index. I know that I have approximately 1 million entries it a table called 'item', 400,000 items in a table called 'recordings' and 100,000 ...
2
votes
1answer
38 views

Search for X at the beginning of a line within a multi-line string

On SQL Server (2008), I have a column which is varchar(max). I want to query for all rows where the blurb contains a lettered list: Some sentence is here a. foo b. bar c. baz Some more text later ...
-1
votes
0answers
41 views

SQL Server Job does not execute when scheduled, but does execute manually [on hold]

I am running SQL Server 2014 SP 1 CU 5. The job did work in the past. The schedule is enabled. The account it is running under is an ADS account which has sysadmin rights and has delete rights to the ...
1
vote
1answer
35 views

InnoDB: secondary key that's 'parallel' to primary--do joins wherein the resulting primary keys are contiguous perform better?

Say I have a table ( person_id INT AUTO_INCREMENT, birthday_timestamp BIGINT, country, state, ..., PRIMARY KEY (person_id), KEY (birthday_timestamp) ) where people are added the instant ...
2
votes
1answer
24 views

msdb.dbo.sysjobs and last run date and time

I know that the last_run_date and last_run_time are stored as Int, but when coverted over to datetime (of which I have examples of), is the time GMT, or what? When converted it doesn't match the same ...
2
votes
1answer
78 views

TSQL Bulk Insert Syntax Error

I run the following code, received a syntax error. SQL Server 2012 Express (version 11) OS: Windows 7 home premium (x64 bit) The server complains that I have a syntax error near ...
0
votes
0answers
44 views

Query tables in a tablespace to find the physical location of extents?

Is there any way to query DBA_EXTENTS to find the actual, physical location on disk of each extent in a table?
1
vote
2answers
41 views

Dedicated SQL instance vs multiple database same server instance

Looking for best practice advice for a sprawling network. I inherited a bunch of SQL servers. The practice has been to just stand up a new VM instance any time a database was needed or add a new SQL ...
1
vote
1answer
27 views

What to do when the active log directory is full?

Here's my database configuration: Log file size (4KB) (LOGFILSIZ) = 125000 Number of primary log files (LOGPRIMARY) = 10 Number of secondary log files ...
0
votes
3answers
33 views

Mysql query larger than tmpfs (ramdisk)

I recently set up a ramdisk tmpfs on our mysql server and the performance improvement has been quite noticeable. I've allocated 24 out of 32 GB's of ram for the ramdisk. My only concern is what ...
2
votes
0answers
38 views

Can SSMS Object Explorer Details configurations be exported?

A number of employees make use of SQL Server Management Studio (SSMS). I have a configuration file for all new users for Environment (etc) configurations. I want to deliver a uniform view for each ...
0
votes
1answer
47 views

Very fast individual queries but when joined super slow

I've got query 1: select department_id from USER_ACCESS where USER_ACCESS.USER_ID = 13170 AND USER_ACCESS.MANAGEMENT = 1 Takes about 0.475 seconds, which is not a lot for the data set I m ...
3
votes
1answer
37 views

Is EXECUTE AS OWNER in msdb a security risk?

I've been tasked with creating a system that allows non-privileged users to start and stop SQL Server Agent jobs. I'm creating stored procedures in the dbo schema in the msdb database using the WITH ...
1
vote
1answer
37 views

Avoiding a full re-initialization when making changes to transactional replication

When I use the GUI to make any changes to transactional replication on SQL server, I live in fear of the "the changes you have made require a reinitialization of all articles" dialog. I have had ...
0
votes
0answers
22 views

InnoDB: why “non-locking” SELECT still gets locked?

This issue can be related to my first question: InnoDB: very slow random updates, hanging in “updating” state But i think it needs to be clarified in a separate thread. The Problem: a simple read ...
1
vote
2answers
24 views

Security of streaming replication?

If I want to use streaming replication between two Postgresql databases on different parts of the internet, is there a way to secure or encrypt the connection between the two? Or are there reasons ...
0
votes
1answer
14 views

PostgreSQL, display role members

Is there a way to visualize which users are mebers of a role in PostgreSQL / pgAdminIII, like role: council_stuff members: Harry Ben Steve Melinda
-1
votes
1answer
38 views

Server settings with 36GB handling app+data

I'm setting up a server to handle a multi-site configuration on a beta application for a partner in a new business venture. Trying to assess sane values for MySQL. Currently I have set: ...
0
votes
0answers
13 views

Would snapshot replication avoid the “repl table shuffle” when making schema changes?

I support an application that sits upon a SQL 2008 database and has an admin tool that allows app admins to do some field customization. This issues an ALTER TABLE command when saved, and since the ...
0
votes
1answer
19 views

Dumping and restoring tables in PostgreSQL - ERROR: extra data after last expected column

I am trying to dump and restore multiple tables from a database on one server, to a different database on another server. Both are running Postgres 9.4 on linux. The command for the backup was: $ ...
0
votes
0answers
4 views

How would I script standing up a MySQL instance with certain specs?

Context: I seem to be unable to find in MySQL Workbench schema creation process where I can adjust server specs like max memory (2 GB); CPU usage, 1x 4 core; 20 GB SSD/Flash storage; OLTP; OS (RHEL ...
0
votes
0answers
36 views

Drop Datafile and Reuse the Tablespace - Oracle

Oracle 12C is my database. I was moving the datafile from one directory to another directory by making the tablespace Offline. ALTER TABLESPACE TABLESPACE_NAME OFFLINE NORMAL; But accidently, while ...
1
vote
1answer
29 views

MongoDB start ID and end ID

I want to insert bulk data into a MongoDB. Later on I want to find exactly the bulk I inserted. In MySQL I would have done: SELECT * FROM data WHERE id >= start_id AND id <= end_id How can ...
1
vote
0answers
26 views

Access denied when trying to use Mysqlimport Utility (using Root Credentials)

We are trying to import large CSV files through Mysqlimport as described in This & This article. But even though I am using root credentials I keep getting the following error: mysqlimport: ...
0
votes
1answer
15 views

VMware vFabric Data Director [closed]

https://www.brentozar.com/archive/2013/04/cloud-alternatives-to-microsoft-sql-server/ I liked the idea of VMware vFabric Data Director so I can host data in own cloud / data centre. It seems this ...
0
votes
0answers
18 views

What does this do: sys.dbms_logrep_imp.instantiate_schema

When running impdp .... sqlfile=some_file.sql I get a sql file containing this command sys.dbms_logrep_imp.instantiate_schema(...) what does this do? Google seems unable to find reference to ...
0
votes
0answers
22 views

Any table type that persists across connections

Probably not possible,but I'm going to ask this anyway: I don't have OPENROWSET privileges on server B. I would like to import data while connected to server A (where I do have that privilege) and ...
0
votes
0answers
9 views

which database to use with FileNet [closed]

hello to all database individuals. I would like to try file-net from IBM company. i am in database option choice!! I am wondering, which database is better for file-net SQL or oracle?! Please help;,
0
votes
1answer
20 views

Make a (copy of a) postgis database available to customer?

Our application uses a PostgreSQL database (with the PostGIS spatial extension). Now one of our customers has requested direct access to the database; because, as they claim, it’s their data. We’d ...
3
votes
1answer
60 views

Amazing improvement of script execution speed when split - not understood

I have an ETL job that merges data into about 20 columns of a fact table, all integer non-null (default 0) columns. There are 8 merge statements to completely update all the columns and they involve ...
0
votes
1answer
41 views

Deny user to see any database through DB_NAME()

I've already prevented user to see any database (deny view any database to [login]) and it works. But how to prevent user to list any other database using DB_NAME()?
0
votes
0answers
28 views

Normalized college database desgin

I try to create a college database College offer UG and PG courses in various departments. Department like MCA,MBA,Engineering Courses offered by MCA is lateral and regular , Courses offered by MBA ...
0
votes
0answers
7 views

PostgreSQL 8.2 giving inconsistant exexcution times

We are using PostgreSQL 8.2 and we are seeing a very strange behavior when we run queries in multiple threads. We are running the same query with 5 simultaneous threads for a period of 1 hour. When ...
0
votes
0answers
25 views

MySQL Return average for every unique id per day

I have a table: Unique ID, DeviceID, Temperature, Epoch And 3 sensors (DeviceID's) sending temperature every minute to the database. I would like to select to return AVG(Temperature) for every ...
0
votes
2answers
14 views

Oracle Exadata datafile distribution

I'm new to Oracle and are curies of how Oracle Exadata handles database files. Do you have to assign disk to a database file as you do with Microsoft or is this handled by Exadata?
3
votes
1answer
61 views

Execution time with warm up cache

I have a query that takes around 1 second on first execution and 15-50 ms after running the same query again. The only difference between EXPLAIN outputs is that the second execution contains a lot of ...
0
votes
0answers
13 views

Silent install of Maria DB on Ubuntu 14.04 is not working

I am using the following commands for the silent installation of Maria DB on ubuntu 14.04. export DEBIAN_FRONTEND=noninteractive sudo debconf-set-selections <<< 'mariadb-server-10.0 ...
2
votes
2answers
37 views
+200

Best way to capture historical changes between levels in a dimensional hierarchy

What is the cleanest way to capture changes between levels in a dimensional hierarchy? I have the dimensional hierarchy [Area] > [Region] > [Location], where Area is the parent to Region and Region ...
0
votes
0answers
20 views

RMAN Duplicate internal operation [closed]

How RMAN Duplicate works internally?Please explain in detail how RMAN picks the latest backup and duplicate works
3
votes
2answers
74 views

Need help improving sql query performance

I have this table: CREATE TABLE `property_ads_history` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `property_ad_id` int(10) unsigned NOT NULL, `advertiser_type` varchar(255) COLLATE ...
0
votes
1answer
19 views

Result consisted of more than one row in procedure

i confused with this i try not using cursor and same get error so i back using cursor but before this day my query success and can generate but this get error please help me i already look other ...
1
vote
0answers
46 views

Deadlock in SQL SERVER 2014

I am experiencing sporadic deadlock behaviour when my application tries to execute any DROP TABLE statement against my database. I tried capturing the deadlock graph and this is the output from ...
1
vote
1answer
42 views

Is the SQL syntax for InnoDB gauranteed to be the same between MySQL, MariaDB and Percona?

I develop an application that uses MySQL and explicitly uses InnoDB table engine. In a few cases we have clients using this application with MariaDB or Percona. I understand that MariaDB and Percona ...
1
vote
1answer
44 views

When to disable MySQL Query Cache

I have a high volume MariaDB 10 server thousands of databases of with over a million tables. Currently we are only hitting around 20% query cache hits. We are already employing Memcache and other ...
0
votes
0answers
22 views

Permissions required to add user to fixed server role

We want to take a group out of sysadmin but grant them a role so they can do the following add, change, remove database access on prod servers for users, groups and service accounts. create and ...
1
vote
0answers
13 views

How to time SPARQL queries on an Oracle12c database?

I have an Oracle 12c instance setup with an Apache Fuseki endpoint sitting on top of it. I am able to query the database using the Fuseki endpoint. I want to be able to get the execution time of some ...
1
vote
2answers
21 views

Postgres: set client encoding default

When querying from certain tables, I'll often receive the error: character with byte sequence 0xef 0xbf 0xbd in encoding "UTF8" has no equivalent in encoding "WIN1252" Varying bytes, but you get ...
1
vote
1answer
33 views

SPID Change for a process?

On SQL Server 2012 can a process SPID change mid-operation? We have a very unique query that we've been monitoring (production, but controlled testing) and have seen it at different intervals with ...
1
vote
0answers
21 views

full-text search 7608 (0x80004005) error message debug

Someone tries to run the following line : exec sp_fulltext_column 'tbElementFullTextMvCustomProperty5', 'EMVCP_E_NAME', 'add', 0, NULL and then receives the following error : (1 row(s) affected) ...
5
votes
2answers
79 views

What sort of exec requests don't have a sql handle? (sys.dm_exec_requests)

I have crafted a query against SQL Server 2012 that looks like the following: SELECT r.session_id, r.sql_handle, t.text -- more details excluded for brevity FROM sys.dm_exec_requests r CROSS APPLY ...

15 30 50 per page