0
votes
1answer
218 views

Access 2010 ODBC Connection to SQL Server 2005

I'm trying to code an ODBC connection to SQL Server in Access 2010 and hoping someone can help me, as I've lost the plot. This is my code, it simply accesses one SQL Server database/table and insert ...
0
votes
1answer
231 views

Analysis Services job step error: The specified file could not be decrypted

We have a daily SQL Server Agent Job that's failing intermittently. Between May 27th and Jun 16th, it has failed twice. The error message we receive (listed below) references "The file could not ...
2
votes
1answer
34 views

Handling Recovery of Disk Space in MySQL and MongoDB

So I have worked with MySQL all my life (not as a DBAdmin, but a programmer), and I have some limited knowledge about maintaining MySQL databases. Recently a portion of our database has been moved to ...
1
vote
2answers
127 views

MySQL server cannot be stopped

I am using Ubuntu release 14.04, MySQL 14.14 Distrib 5.5.43. To reset the MySQL root password, as described in the official MySQL doc How to reset the root password, I need to stop the MySQL server. ...
1
vote
1answer
174 views

How do I open an ERwin Naming Standards file (.nsm) in Excel?

I have a Naming Standards file in ERwin (.nsm format) that I want to be able to open up in Excel (for example, in order to compare 2 .nsm files). How would I be able to do that?
7
votes
1answer
67 views

Failover timeout problem

I'm looking for an additional bit of help with regard to some problems I'm looking at for one of my company's clients. Basically I have two related problems with regard to a 2-node active/active ...
3
votes
1answer
77 views

Automate DBs restore through TSQL by given folders

I searched in the internet but cannot find clear and direct way. I have a folder which include 100 databases as full backup, another folder contains all logs for these 100 DBs. I need a script to do ...
2
votes
0answers
53 views

Why does SQL Server 2005 only use an IS lock in this scenario?

I am attempting to examine the locking behind different queries but with the same output to avoid deadlocking situations. I have the following code: SELECT MIN(ID), TextData FROM PKKEYTESTER ...
3
votes
1answer
260 views

How to copy one table data to another on different server?

I have country wise Mysql servers and one master server. The master server has all country data. In that I want to copy data of particular country data from master mysql server. Example : if any ...
0
votes
1answer
63 views

DB_OWNER permissions for user [duplicate]

I would like to know if db_owner can change the recovery model of database. Using TSQL- alter database db set recovery simple
3
votes
2answers
217 views

Prevent logins loss when restoring a database

I'm backuping and restoring databases accross two sql server (v12.0.2000). But it looks like whenever I restore a .bak file, the login I created on the database that was backuped is no more existent ...
4
votes
3answers
159 views

PostgreSQL GRANT ALL on mutliple tables using LIKE

I have more than 100 tables named public.test_* How can I easily GRANT ALL access to the user test to all that tables at once? I tried with: GRANT ALL ON TABLE public.test_* TO test; But it is ...
2
votes
1answer
79 views

Database templates [duplicate]

Are there any site with database templates for specific purposes? (i.e. a database schema for users and authentication in a webpage) for different databases like Oracle, MySQL... I have been looking ...
10
votes
3answers
485 views

Configure RAM for SQL Server and NUMA

Accidental DB admin here. Question: Would you still manually limit max RAM for SQL Server even though the sole purpose of that server is to serve SQL Server database engine only? I have Microsoft ...
1
vote
1answer
34 views

An event has run for certain amount of time. How to find the time for how long this event has run in mysql? [closed]

I am using MySQL. I ran one event it took long time. How to find the time for how long this event has run?
2
votes
1answer
159 views

Efficient table structure for application logging

Am using SQL Server as my RDBMS and i want to maintain some transaction of an auto run tool which will log some info on a daily basis. I need some suggestions how an efficient structure to be. I mean ...
1
vote
1answer
153 views

Indexed view doesn't exist on the subscriber

I am configuring transactional replication in SQL Server. The subscription is configured as push from 2008R2 publisher (distributor is the same server) to 2012 subscriber. The object I want to ...
7
votes
1answer
2k views

“Manage” option vanished on portal for Azure SQL database

I had a database which I deleted and it used to have a "Manage" option which would open the online sql management portal. I created a new database, now I don't have the "Manage" option anymore. I ...
0
votes
1answer
1k views

SQLcmd error 'Failed to initialize sqlcmd library with error number -2147467259'

I'm trying to update some maintenance plans to make use of the Ola Hallengrens IndexOptimize, but also mail the result of the operation using sp_send_dbmail. Old T-SQL: declare @indexQuery nvarchar(...
1
vote
0answers
313 views

Why my sql query run faster than my stored procedure?

I am trying to write a script in MYSQL Workbench to update my database every day using stored procedure but I find it too slow compared normal query or temporary tables. If i use temporary table the ...
3
votes
1answer
1k views

Mongodb high lock percentage / slow queries

I'm working with an application using MongoDB that is getting a fairly large number of incoming requests and I've noticed that the responses are getting slower as the number of requests get higher. ...
1
vote
1answer
201 views

Table size unaffected after deleting 400k rows

When I ran the below query select bytes/1024/1024,segment_name,owner from dba_segments where tablespace_name='DATA_L1' and segment_name='Step_Status'; I got the below result for a segment which is a ...
21
votes
2answers
822 views

Optimization issue with user defined function

I have a problem understanding why SQL server decides to call user defined function for every value in the table even though only one row should be fetched. The actual SQL is a lot more complex, but I ...
1
vote
2answers
84 views

Is there's another function to optimize this query in MySQL?

I want to use a function that returns for me the same result in one line is that's possible?? MIN( CASE WHEN (data.pro LIKE '1 %' ) THEN 1 WHEN (data.pro LIKE '2 %' ) THEN 2 ...
1
vote
0answers
37 views

Schedule data from instance to instance have I maxed out tableDiff

We have a process which uses tableDiff. From one SQL Server 2008 R2 instance to another identical instance. It has worked very well for a long time! I have a situation where one table now has ...
0
votes
0answers
59 views

Retrieving a record for the last date received and returning the value of another column in that row

I have the following query which is returning me total number of expected records : select a.New_FirstName + ' ' + a.New_LastName as 'Account Name', a.New_MPRNNumber,MAX(b.New_readdate) as 'Last SC ...
0
votes
1answer
214 views

SELECT w/ INNER JOIN Query on Optional Columns

I have five tables: File2, Branches_of_Study, Schools, Education_Establishments, and Certificates. File2 is the transaction table with all the other tables as reference tables. File2 is all about the ...
0
votes
0answers
250 views

Should innodb_buffer_pool_size be much larger than the innodb_buffer_pool_bytes_data?

Our old server had 32GB total RAM, 18GB allocated to innodb_buffer_pool_size. It also had 10GB for the php_memory_limit. The new one had 16GB RAM, 9GB for innodb, 5GB for php. The same application ...
0
votes
1answer
51 views

Postgres INNER JOIN same table failing on CartoDB

I have a table with data which looks like this +----+------+-------+ | cp | year | count | +----+------+-------+ | 1 | 2000 | 10000 | | 1 | 2001 | 9000 | | 1 | 2002 | 9500 | | 2 | 2000 | 8000 |...
3
votes
0answers
897 views

Unable to open/connect to Oracle 12c Enterprise Manager Express

I have a just installed a new single instance installation of Oracle 12c (12.1.0.2.0 on Windows x64) with ASM. The database itself is working OK (can be accessed locally and remotely via port 1521), ...
8
votes
1answer
586 views

SSDT Schema Compare fails when comparing my DB Project to my Azure Server

I have a SQL Database project that I have built our enterprise DB on. It has deployed several times on internal and AWS hosted SQL servers using SSDT's Schema Compare tool. The problem when I post ...
1
vote
1answer
27 views

Comparing the contents of 2 .nsm (naming standards) files

I have 2 naming standards files from ERwin (.nsm extension), and I want to compare them to see if they contain the same rules. Is there some sort of automated way to check this? If there isn't a way ...
0
votes
1answer
85 views

Unable to delete a SQL Server 2012 publication

I've set up a transactional replication for two databases, let's call them A & B. Replication for the database A worked just fine and I was able to delete it afterwards without any issues. ...
2
votes
1answer
1k views

How to create an Oracle Database Link when the password has special characters

I'm trying to create a DBLink. SQL Developer is the client I'm using. The password to my remote user has *'s in it. I'm having trouble figuring this out. This syntax isn't working: CREATE DATABASE ...
1
vote
1answer
265 views

What connection string to use to connect to network server?

I have a database on my computer running on SQL Server Express 2014, and I'd like other computers connected to my network to be able to connect to it using a C# program I wrote. I've done the ...
8
votes
3answers
2k views

How to insert a large amount of records to the database in a short time?

I have to insert a bunch of records(500,000) to the database at once, using the fastest way. I've tried inserting 1,700 records at once but it took twenty minutes!! I am using SQL-SERVER, and C#. ...
2
votes
1answer
44 views

reading content of master database at a different server

I have a query for example select * from sys.databases select * from sys.configurations I believe this information is stored at master database. I would like to have a look at configuration ...
0
votes
3answers
119 views

Query for total downtime of site using datestamps and status columns

what want to find the total downtime for a site. I'm thinking I can subtract the 'down' DateStamp from the following 'up' DateStamp. then add the totals together for all downtime. I want to get a ...
0
votes
0answers
129 views

Query EXPLAINed differently on MySQL 5.6 (or Amazon RDS) and is very slow

I have the following query: SELECT ld.idDataAttribute AS idDataAttribute, ld.instance AS instance FROM logs l INNER JOIN logData ld ON l.idLog = ld.idLog INNER JOIN dataAttributes da ON ld....
0
votes
1answer
323 views

SQL Server job runs forever after server restart

One of our ETL servers had to be restarted and a job was in the middle of execution. It was on the 2nd of 6 steps and now the job agent shows that it has been running for 15 hours back on step 1. ...
0
votes
1answer
89 views

Optimal SQL Server 2012 Disk Configuration

I will be installing SQL Server 2012 on a new Dell T430 server containing four (4) physical 15K SAS 6Gbps disk drives using a PERC H730P RAID Controller and RAID 1. Since this will be the first time I'...
0
votes
1answer
145 views

Sync two SQL Server databases

So I've got a hosting package from hostgator with an MS SQL database and a local SQL Express 2012 database running. I'm trying to investigate syncing the two together, two-way syncing, and I'm unable ...
3
votes
1answer
92 views

What impact does UseMicrosoftUpdate have on the UpdateSource option when installing SQL Server 2014?

The ConfigurationFile.ini generated for SQL Server 2014 contains a new parameter that I cannot find documented anywhere - UseMicrosoftUpdate. What impact does this parameter have on the ...
0
votes
0answers
48 views

Why does my Crystal Report no longer populate data?

Using Crystal Reports to create a custom report for use in TrackIt. The report has many subreports, each of which contains an individual SQL query tailored to get a small amount of data from our ...
6
votes
3answers
451 views

Sql Server Service Pack Update Notifications

Is there any option in Sql Server to enable notifications from Microsoft in a way that it sends us emails every time a new service pack is released? I have multiple servers with different versions of ...
1
vote
0answers
34 views

Processing data while keeping frozen frontend database online

What is the best approach at having a "frontend" database online and working, while processing and generating new data in the back? I have an scenario that some tables and even whole databases data ...
0
votes
1answer
358 views

Tracking the update or changes in mysql table

I need to stream the changes to elasticsearch to keep in sync with my database(mysql). What will be best way to do this ? I have thought for below approaches Using trigger( but my table will have ...
0
votes
1answer
41 views

Read only access to Slaves from Server A

Here's a little scenario: Server A which is a Dev server needs READ access to the Mysql databases which are on slaves B and C. No WRITE access is allowed from server A to the slaves. How do i ...
0
votes
2answers
180 views

Does the MongoDB background flush (MMAP) update the entire document even if only a small portion has changed? i.e. set on an array position

We are currently trying to get to the bottom of some high background flush times on our MongoDB installation. As part of this investigation we have been looking at the $set operation we perform on an ...
5
votes
2answers
193 views

Blocked Process Report -two updates causing a long block

I have a .NET application which is getting SQL update timeouts and I believe that some sort of blocking/locking is taking place which is causing this. I have ran a blocking process report on the ...

15 30 50 per page