0
votes
0answers
3 views

Restore of database failed .bak File MS SQL SERVER 2008

I have faced following error during restoring database: ++++++++++++++++++++++++ TITLE: Microsoft SQL Server Management Studio Restore failed for Server (Microsoft.SqlServer.SmoExtended) For help,...
0
votes
0answers
4 views

Very slow merge replication synchronization

I had an unforeseen issue with a sub going down (generic error, was probably a connection issue) and now that I've reconnected the sub it is insanely slow re-syncing. It seems to download about 1000 ...
0
votes
0answers
17 views

How to Delete rows based on a combination of columns having a certain count

I'm having trouble writing a query for the table below. CREATE TABLE `c_example` ( `id` int(11) NOT NULL AUTO_INCREMENT, `c_id` int(11) DEFAULT NULL, `guid` varchar(32) DEFAULT NULL, `...
-1
votes
0answers
7 views

Tlog restore keeps failing, now states “restoring”, normally completes after restoring last file, this time no luck, any thoughts?

I am hoping you can help me out!! Our restore keeps failing with the error message: Message Executed as user: NT AUTHORITY\SYSTEM. ALTER DATABASE is not permitted while a database is in the Restoring ...
0
votes
0answers
9 views

Retain column statistics on paragraph-style columns?

Specific to Microsoft SQL Server... If a query has a search predicate against a paragraph-style text column, it will create a system-created statistic to answer the query. Got it. My question is if ...
0
votes
1answer
15 views

How to migrate windows login in from one sql server to another sql server on another domain

We have a SQL server that is located in domain 1(DMN1). We are migrating databases in domain 1 to our new SQL Server in domain 2(DMN2).Corporate states that there will be no trust established between ...
2
votes
2answers
40 views

Using TOP in INSERT INTO statement

I am reading a tutorial about TOP Keyword in T-SQL. But I don't really understand the examples given in the tutorial. Example1 INSERT TOP n INTO table_name1 (Col1, Col2) SELECT Col3, Col4 FROM ...
0
votes
0answers
7 views

Accept remote TCP/IP request from aLL IPs in SQL server

I have problem with access to SQL server with TCP/IP. I would like to SQL instance accept client from all network adapter that machine has. I go to configuration manager console and enable TCP/IP, ...
0
votes
0answers
3 views

MDX measure to DAX conversion

I needed a little help on working with MDX and DAX. Recently I have just started working with these two terms and am having a little trouble figuring out the differences and possible examples of how ...
0
votes
1answer
14 views

Securely manage and dynamically create multiple databases

Background I have inherited a system that has several hundred databases. The primary "Clients" Database represents all clients with several tables like: WebUsers = username | password | server_id ...
0
votes
2answers
22 views

Grant permissions to a user to grant select to specific tables in several schemas in Oracle

I administer a small datawarehouse in Oracle. My user dwhmanager was given the SELECT ANY TABLE privilege: GRANT SELECT ANY TABLE TO dwhmanager WITH ADMIN OPTION; The idea was to have the ability to ...
0
votes
1answer
16 views

Where clause returns null, but need to return 0

Need an SQL Statement for the following: Table a partID partNumber Table b partID purchased SELECT a.partNumber FROM a WHERE (SELECT SUM(b.purchased) WHERE b.partID=a.partID) > 0 If ...
0
votes
0answers
18 views

AOAGs status in HTML Format to Mail

Can you please help me formatting the script.I am using html format and trying to send to my mail but I am not getting output to mail but I can send output as attachment and can you please help me ...
0
votes
1answer
19 views

Extracting Company from Multi-tenant Shared Schema Database

We have a mutli-tenant shared schema database architecture. As a form of load distribution we have spread the tenants/companies across 6 SQL 2014 servers and 20 databases. All DBs are virtually the ...
1
vote
2answers
31 views

Why is table opened every time a query is executed against it?

I execute this SQL command twice and profile select * from sbtest.sbtest2 limit 100; The first time profile result is mysql> show profile for query 1; +----------------------+----------+ | ...
0
votes
1answer
24 views

What is effective way to delete duplicate records based on multiple columns in MySQL?

I have a table named users having approx 70 Million records, out of which I guess 10 Million is duplicate. How to remove those 10 Million records keeping one copy of that. Two records are said ...
0
votes
0answers
18 views

Oracle DB refresh on 11g using 10g Cold backup

I am a sql dba, I am having only a little knowledge on Oracle. looking for help regarding oracle db restore. I am having an Oracle 10g cold backup, i need to restore this on Oracle 11g setup, can you ...
1
vote
1answer
32 views

Can SQL Server R Services be enabled on a readable secondary?

To avoid excess load on the primary SQL Server, I'd like to install and enable R Services on a secondary replica of the primary server. Is this possible? Also, can I push computations from a remote R ...
0
votes
0answers
20 views

Cannot delete Postgresql constraints that were former unique keys

I have modified unique constraints. I am adding a field to every unique constraint. To do that, I need to drop the existing unique constraints and create the new ones. I am trying to delete foreign ...
1
vote
1answer
28 views

Management Studio 2016

Its strange problem with my SSMS 2016. With in the query window backspace , del, up,down,left,right keys nothing works. But when I reset my environment settings with "Import and Export Settings" to ...
1
vote
1answer
18 views

Why does the scipt executes only once the sqlscript

the following script is pretty simple, but it works not as expected. I searched for an answer but I am stuck. #!/bin/bash db_con=user/pw@db bname='filename' for f in $(seq 1 10); do sqlplus -S ...
0
votes
0answers
22 views

SQL Server 2012 failover cluster node won't start cluster services

We have 2 node SQL server failover cluster setup in our environment. Node2 SQL server machine got shut down. I turned it back on and connect back to the failover cluster. It successfuly connected ...
-4
votes
0answers
29 views

How to calculate the difference in values between two tables

There are two tables T1 and T2, T1 contains the current values, in case the user Needs to update/correct the values. The concerned row from T1 moves to T2 and a new tuple is added to the T1 with ...
1
vote
0answers
14 views

Trying to restore SQL file from mysqldump, results in syntax error

I ran the following sqldump call in a MySQL 5.7 instance (Windows OS): mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob --master-data=1 --routines -A > ~/dump.sql I ...
1
vote
1answer
16 views

MYSQL TABLESPACE = innodb_file_per_table GIVING ERROR 1030 (HY000): Got error 168 from storage engine

I have tried this statement to place a tables in different disks. Operating system is Linux Oracle 7, I've changed permissions in the directory with chmod -vR 777, to have total access to the disk ...
0
votes
1answer
18 views

Postgresql log rotation

In postgresql, I'm using the following configuration to maintain my weekly logs: log_truncate_on_rotation = on log_rotation_age = 1d log_filename = 'postgresql-%a.log' log_rotation_size = 0 #just ...
0
votes
1answer
24 views

How to use a table when the user identifier can be one of two fields

Recently we've started developing Github like organisation system for our service. We have both free and payed plans. There are users. Also there should be the owner for organisation and the owner ...
0
votes
0answers
10 views

postgresql statement taking ages to cancel in pgAdmin III

I was running a query in pgAdmin III and it was taking a long time. After 9 minutes I decided to cancel it using the stop button. The UI stated that it was cancelling and stayed in that state for ...
0
votes
0answers
24 views

How keep overview about database permissions?

As DB-Administrator I need to keep overview about my servers and databases in general - and from a security context about logins, users, db-roles and permissions in particular. It is possible to ...
1
vote
1answer
23 views

Create an XML Schema collection in SQL Server 2012?

I want to create an XML schema collection to validate some XML in a column for the following XML: DECLARE @xml as xml SET @xml=' <R C="firstName" O="" N="Fred" /> <R C="lastName" O="" N=...
0
votes
0answers
4 views

help me to migrate single myslq5.6 server to mysql5.6 Cluster, follow this error!

I try to migrate a single myslq5.6 server to mysql5.6 Cluster. I do not understand why I get the follow this error: ERROR 1297 (HY000) at line 1 in file: 'load_dept_emp.dump': Got temporary error ...
0
votes
1answer
82 views

SQL Query error driving me crazy! [on hold]

I'm wondering if anyone can find the mistake in my SQL-Query which I can't seem to find.. Been starring at the same lines of code for like 2 hours and it's driving me nuts! So, here's the query... (...
0
votes
0answers
17 views

All queries are so slow on mysql cluster

Here is my situation: I got over 10G of web logs (around 30 million rows) and I mainly search it with various conditions. e.g.: select * from tbl where ip = '123.123.12.3' and agent = '...
0
votes
1answer
16 views

Changing number of rows when importing table [duplicate]

I'm currently importing a table with about 17 million rows in MySQL. What catches my attention is, the number of row seems to be fluctuate. I used the command show table status while my importing ...
1
vote
1answer
27 views

Restrict access to Edition- or instance-specific databases

I have the following issue with SQL Server. On my Windows Sever, SQL Server 2008 Express Edition is running. Now I have installed SQL Server 2008 Web Edition on the same server. My problem is, when ...
-3
votes
0answers
8 views

ignore some values using awk in shell script [on hold]

I'm writing a script which should sum of a columns entered by user.In the columns there is one row which is date(dd/mm/yy). Now awk doing sum of all values including value of dd.How to ignore date ...
0
votes
0answers
13 views

localhost:port_number/em (what is my port number)?

I am new to SQL databases. I have started learning SQL databases from SQLZOO, where they told me to use Oracle. I have installed Oracle Database 11g on Windows 10 with the help of this video. I have ...
1
vote
1answer
37 views

How to sort the data fetched from horizontal partitioned tables

I have a telco billing software system. In it there are daily logs of users' calls. The logs are horizontally partitioned by date (month). Each partition is stored in a separate database and may be ...
0
votes
0answers
9 views

Windows Domain User with Admin privileges cannot access a drive with full permissions in psql

I have installed the standard PostgreSQL 9.5 from Enterprise DB with a domain-level postgres user who has domain-level admin group membership. I have explicitly added full permissions for this user to ...
4
votes
1answer
68 views

Optimizing “WHERE x BETWEEN a AND b GROUP BY y” query

CREATE TABLE test_table ( id uuid NOT NULL, "RefId" uuid NOT NULL, "timestampCol" timestamp without time zone NOT NULL, "bigint1" bigint NOT NULL, "bigint2" bigint NOT NULL, "int1" integer ...
0
votes
0answers
13 views

Create custom JSON response from PostgreSQL table

Consider the following table: CREATE TABLE IF NOT EXISTS trips ( trip_id SERIAL PRIMARY KEY, start_location TEXT REFERENCES locations(label), end_location TEXT REFERENCES locations(label), ...
0
votes
0answers
18 views

OraOLEDB.Oracle not showing up in Providers in Linked Server

Im trying to link the Oracle database to our SQL Server database. However OraOLEDB.Oracle is not in the Providers list on the Linked Servers. I have installed Oracle Database Client (12.1.0.2.0) for ...
0
votes
0answers
23 views

In Oracle how do I put certain tables or partitions in a different group so the rest of the db can be brought up with OR without them?

I've done this with MS SQL Server in the past where data that is not required for disaster recovery for instance is in a separate file group and file and not cloned to save significant space and ...
0
votes
0answers
23 views

Determining whether a MySQL column is ever used

How can I determine whether a particular column in a MySQL table is ever SELECTed or explicitly UPDATEd or INSERTed or referenced in a WHERE clause? It'd be nice if I could determine the db user who ...
0
votes
1answer
12 views

Mysql will no longer start after DB import and password change

I'm running Mysql5.6 on RHEL 7. I had managed to get the mysql service up and running, and imported a database into it with no issues. However, after attempting to reset a user's password, the ...
4
votes
2answers
66 views

SQL Server- Limit to Concurrent table queries?

In SQL Server, or RDBMS systems in general, is there a limit to the number of concurrent queries that can be made against a table? How is it that N number of users can access the same physical data ...
0
votes
0answers
32 views

SQL 2016 Installation Error

I am trying to install sql 2016 standard on a windows server 2012 standard edition, and I am running into an odd error, hopefully someone can point me in the right direction. I am getting account ...
1
vote
2answers
24 views

How can one identify if FK's needed to be indexed apart from the NC indexes already residing

I was going through many articles, which said indexing the FK's is beneficial for good performance, specially for the environment where most of the reporting is done. I have a similar env where there ...
0
votes
0answers
25 views

Top Recommended Books/Courses For Learning Mid-Advanced Database Programming Beyond Basic CRUD Operations [on hold]

I have been a SQL DBA for the past two years and am looking to learn more indepth database programming to up my skill set and make me more attractive to potential employers. Currently with my day to ...
0
votes
0answers
7 views

error After upgrade datastax to version 5

After upgrade datastax to version 5 i get this error in log (Insufficient permissions on directory /hints) and node is down where the location for this directory?

15 30 50 per page