0
votes
0answers
4 views

Activity Monitor % Processor Time grayed out on SQL Server

The % Processor Time graph at Activity Monitor for remote connections stopped working and it grayed out after the physical SQL Server restart (image below), but when I get in the server with the same ...
0
votes
0answers
4 views

Connection error while connecting to Oracle XE

This just started happening this morning, and I'm not sure what the cause is. IT just installed some sort of Windows update but I'm not sure if this is related to the issue. Basically, when I try to ...
0
votes
0answers
2 views

DB Configuration Advice

I need an advice circa databases' utilization. Which is the best configuration and why: 1) MySQL + CouchDB + ElasticSearch for CouchDB and MySQL indexing; 2) MySQL + Cloudant (previously ES + ...
0
votes
1answer
11 views

Create view to know missing records between two tables

I have two tables, Tab_A is a template that generate Tab_B. Tab_A: ID, ORDER, ASSEMBLY, DESCRIPTION. Tab_B: ID, ORDER, ASSEMBLY, DESCRIPTION. Tab_B in same situation might have less records then his ...
0
votes
3answers
28 views

Repository for organizing company SQL statements?

We have a few people here that use SQL and have quite a few queries we each individually use and share. I'm wondering if there's a solution to store all of these statements in a central repository ...
0
votes
0answers
3 views

postgre 9.5 import to MSSQL Server 2012 r2 verification issue

I have a postgresql table with 8 million rows. I need to copy it over to MSSQL. I do not have access to the console so I am unable to use PG_Dump. I have the ODBC driver, and have successfully linked ...
0
votes
1answer
17 views

Service Packs and CUs for SQL Server, do these patches make any changes to user database files? or just instance level binaries?

I am curious about patching on SQL Server. Does anyone know if SPs and CUs make any changes to user database files or is it just the database engine and instance level binaries that get modified/...
0
votes
0answers
12 views

Local Server Management

I just started a new software development company, We are using Windows Server, with Wamp installed on the machine. The machine is connected to a router and we have 10 employees. But only 5 of them ...
-3
votes
0answers
9 views

Mysql 5.7 database

I have a database in mysql, which yesterday didn’t open - Table is crashed and last repair failed. Which error popped up and after I opened database 2 times, and the same issue. How can I make mysql ...
0
votes
0answers
8 views

Change a tab's caption from the subform which sits on it

I have a form (frmCampaignDetails) with a TabControl on it. It's for a campaign scheduling tool for a marketing company. The tab control is called tabJobs and has 5 pages, pgeEmail, pgeDisplay, ...
0
votes
2answers
32 views

Multiple values in one table; need them to be in separate columns

I'm relatively new to SQL so thank you in advance for any help you can give me. I'm writing a query that needs to produce a table that shows all students' majors, minors, and the dept. I've created ...
0
votes
0answers
4 views

MongoDB unrecoverable replication error

One of member of my MongoDB replica set decided it would not restart, with the following error (reformatted for readability): Starting rollback due to OplogStartMissing: our last op time fetched: (...
0
votes
1answer
18 views

correlate subquery in hive

SELECT ndo.sku ParentSKU, visitsWhenSKUWasOnline.s FROM Temp.NumberOfDaysOnline ndo JOIN ( SELECT SUM(gasessiondata.sessions) as s FROM gasessiondata WHERE gasessiondata.date >= ...
0
votes
0answers
16 views

Structure a database for a Blog

I built a database for a blog. I am a student yet, so my knowledge is limited in this area. I post this question to get a briefly description of what I do wrong, why, and how I can fix it. I'm not a ...
0
votes
0answers
5 views

Match a column against a sub-string in natural language mode in MySQL

I need to search in a product's table for their names from a text input and show the data in a table using Ajax, the search results are almost perfect, execpt that we have to type all the word. I ...
0
votes
0answers
27 views

How to model complex fact table?

I work for a CableTV company and we are beginning to invest in a BI system. My initial problem is to track two related facts: installed equipments (cable decoders and active subscriptions. We are ...
0
votes
0answers
4 views

Incorrect information in file

[ERROR] mysqld: Incorrect information in file: '/mysql/#sql50f_eb5128_1.frm' Received this error while restoring old snapshot.how to confirm which table which is causing this error message. Im sure ...
0
votes
1answer
50 views

How to manage SQL Log File .ldf

My problem is having issue with SQL Server 2014 Database and its size growing and consuming Hard disk is almost full, Only 50GB space is left in 1TB Hard drive, and SQL database log (.ldf) file is ...
0
votes
0answers
10 views

Database design settings issue

I have a problem designing reminders for invoice database. Reminders should be pre set up to a number, and also varying upon consumer or business. For example #1 (B2C) a 10$, and #2 a 25$ etc. Draft: ...
0
votes
0answers
18 views

warning about conversion on sys.sysschobjs in the execution plan

I noticed a warning in my query plan and it came out to be these two (related to sys.sysschobjs): Type conversion in expression (CONVERT(char(2),[mydatabase].[sys].[sysschobjs].[type],0)<'U')...
0
votes
2answers
15 views

Find changes made in the table in sql server 2012

I am using a SQL Server.I have more 1000 tables in a database which i want to track for data changes.I have read about CDC(Change Data Capture) and will enable it on all the 1000 tables.It creates ...
0
votes
1answer
23 views

Query - Pivoting 2 columns into 2 rows

I am familiar with PIVOTS but have done only simple ones of one column into a row. I have this query: DECLARE @EndDate DATE SET @EndDate ='20160728' --{?EndDate} SELECT T1.ItemCode,SUM(T0.IssuedQty)...
0
votes
1answer
10 views

On Load sub which checks records causing problems

I have a checkbox called 'Added to Schedule' on a form (booking sheet) which is supposed to be ticked if the job appears on another table (schedule). It usually works but sometimes if the job is then ...
0
votes
2answers
28 views

warning sign on the select operator - what does it mean?

while comparing the execution plan of 2 stored procedures, on the second one I get a warning sign (marked by the red arrow). what does it mean?
0
votes
0answers
9 views

MongoDB design schema

Objective Get a good schema capable of making searches easy depending on the hierarchy. Background I am coding a database for a webervice that will return information about items for a game called ...
0
votes
0answers
20 views

How is the better way to manage the database change?

Scenario. I have a Production, Staging and Develop environment. In the development environment we develop code to fix a certain issue and maybe perform DB changes if necessary. Now we log the DB ...
0
votes
2answers
17 views

Database snapshot update

I m a new in SQL. I have one question where if we update, i mean add or delete data at source database, is that the data will be update in database snapshot also. Please enlighten me.
0
votes
0answers
4 views

empty Galera cluster with mysqldump backup - what does “WSREP: Provider paused at” and “WSREP: Provider resumed” mean?

We operate an empty Galera cluster (without customers): MariaDB [(none)]> SELECT table_schema "DB Name", -> Round(Sum(data_length + index_length) / ...
1
vote
1answer
43 views

Similar indices in MS SQL Server

I currently have a table which has 2 indices on the same table that are being used to speed up slightly different sets of queries. They both have 2 index columns and 1 included column and all 3 ...
0
votes
1answer
25 views

PostgreSQL: suggestions for speeding up string cleanup function?

I need to cleanup a string, so that certain ASCII code characters are left out of the string, and others are replaced. New to PG SQL. My function ufn_cie_easy performs way too slow. Grateful to anyone ...
-2
votes
1answer
31 views

Can not restore SQL Server 2008 database?

I have trouble to restore SQL Server 2008 database. I receive an error message when I try to restore that restore failed and database is already in use. I try to restore backup from my D drive. Why I ...
0
votes
0answers
8 views

where-object in powershell [migrated]

How can I club these two ? Get-ItemProperty HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\*|` Where-Object {$_.displayname -like "*Database Engine Services*" } | Select-Object ...
1
vote
1answer
25 views

Threads being blocked when trying to access SQL Server

I'm having a rather strange problem. For some time now, I've been developing a project on SQL server and everything has been going fine. Yesterday, I was given a new .bak file to restore, containing ...
0
votes
2answers
57 views

How to find the columns and tables used in a stored procedure (SQL Server)

I want to find all Tables alongside the columns used in a special Stored Procedure? Can anyone help me here? By the code below I found the tables but I want columns too SELECT DISTINCT o.id , o....
0
votes
0answers
17 views

MSP patch installation error

I am facing below issues.please help on these issue. =========== MSI (c) (14:08) [17:35:25:417]: Windows Installer installed an update. Product Name: Engagement Management System. Product Version: 4....
0
votes
0answers
5 views

master-master replication in mongodb

Did anyone tried master-master replication in mongodb. i have used replica set and master-slave replication. But we want to go with 2 data centers and need a master in each data center. i am using ...
-2
votes
0answers
15 views

Email having empty body [on hold]

I have a table named 'email_queue' that contains the details of the email. (recipient's email address, subject, bcc/cc, body) and there's a bug where it sends to the right recipient but the body is ...
1
vote
0answers
14 views

Hash Match inner join in simple query with in statement

I am running the execution plan for the following query: select m_uid from EmpTaxAudit where clientid = 91682 and empuid = 42100176452603 and newvalue in('Deleted','DB-Deleted','Added') Here is ...
0
votes
0answers
5 views

MongoDB connect strings with Primary and Replica Sets

https://docs.mongodb.com/manual/reference/connection-string/ mongodb://db1.example.net,db2.example.net:2500/?replicaSet=test What is best practice for connect strings, if in future, we need to add ...
2
votes
1answer
53 views

What are options for super volatile tables?

I've inherited a very volatile table which is a map of who holds what resource in the system. At any given moment, there could be a dozen inserts/deletes/reads going against that table. However, ...
1
vote
0answers
10 views

`t2.t1_id IN (select t1.id from t1 …)` is slower then `t2.t1_id IN (1,2,3,…,150)`

Query with subquery is much slower: SELECT COUNT(*) FROM `t2` WHERE `t2`.`t1_id` IN (SELECT `t1`.`id` FROM `t1` WHERE `t1`.`site_id` = 5978) AND (t2.created_at >= '2016-02-13 08:00:...
9
votes
7answers
1k views

Does anybody know what this tool is called? [on hold]

Productive work has crawled to a stop while we try and figure out what the red thing on the cover of Microsoft SQL Server 2012 Internals (2013, 0735658560) is. We think it's a surgical or electrical ...
1
vote
0answers
7 views

AG groups don't sync user DB collation change to replica servers?

We have 2012 AG group set up between server A and server B, where A is the primary, B is the replica 1) When we changed the user DB collation on server A, on server B, the user DB still shows the old ...
0
votes
1answer
14 views

How to query two values from the same table from different records combined with fields from other tables?

I have a query similar to the one below which is getting data from a couple of tables and works as expected. The table eventsink.RedEvent has another column called Finished. I want to add the Finished ...
0
votes
2answers
25 views

What is the best way to backup logs and shrink logs in SQL Server 2008 r2?

What is the best way to shrink and backup our db logs? I have seen many DBAs that do it : ALTER DATABASE [mydatabase] SET RECOVERY SIMPLE DBCC SHRINKFILE(<log_file_name_Log>) ALTER DATABASE [...
0
votes
1answer
37 views

Execution plan - Hash Match

SELECT dbo.Contracts.ContractID AS [Service Unit ID], dbo.Jobs.JobName, dbo.Customers.CustomerName, dbo.Contracts.ContractAutoID, dbo.Contracts.ContractType, dbo.Contracts.ContractStatus AS [...
0
votes
0answers
3 views

I am utilising phpMyAdmin for a server backup and need to know how to access stored data, such as backed up files

My server has a featured name phpMyAdmin implemented into it, it claims to feature data backup, however I do not know how to access the files.
0
votes
0answers
6 views

Diskspd and high latency

Hope someone can help here. I am trying to understand the high latency reported by Diskspd. Please help how to investigate this further. OS : Windows server 2008 Local disk, Not SAN or NAS RAID :...
0
votes
0answers
19 views

pgAdmin III hangs a lot!

I've just installed PostgreSQL 9.5.3 into my Windows 10 system(x86). While, it didn't show any errors while installing. But, after opening pgAdmin III, when I try to connect using my password, it ...
0
votes
0answers
13 views

Need to retain 30 days of database dump(.dmp ) files on disk before deleting the oldest one [on hold]

Need the best way to retain 30 days of database dump(.dmp ) files on disk before deleting the oldest one. Scope: Each day we will do an export to dir1. so one .dmp file will live in this dir1 ...

15 30 50 per page