0
votes
0answers
8 views

Does the transaction log grow during a full backup?

I've been tagged as the occasional DBA in the office. I have minimal experience and it would be great if someone could answer my simple question. I know the trans log grows during transactions, but ...
-4
votes
0answers
9 views

Do you know cool quotes about ER-Diagramms?

For example in case of maths "Pure mathematics is, in its way, the poetry of logical ideas." - Albert Einstein
0
votes
2answers
16 views

Encryption in SQL Server 2012/2014

We are hosting sharepoint DBs. My boss ask me for possibilities to do the encryption on content DB level, it backup. or on column level? I read about TDE? it is will slow the DBs? is it practical ? ...
1
vote
0answers
23 views

Should I delete disabled windows Active Directory accounts from SQL 2008?

Is there a risk of not deleting unused Windows logins that have been disabled in AD or is it simply a housekeeping issue? e.g. Windows authentication is used to provide database access. A user leaves ...
2
votes
1answer
26 views

How to monitor history of logins to database if login auditing is not enabled?

I have a number of databases on multiple servers that don't seem to be used any longer. Can't find their owners, there are no processes linked to them, nothing got written to the tables for a few ...
0
votes
0answers
22 views

SQL 2012 Standard Edition (on Azure VM) + Bitlocker. Good or Bad idea?

I will start this question with a few statements to negate any "Why" questions that are going to be asked. The Head of IT wants the data encrypted. Our profession is such that encrypted data is ...
-2
votes
0answers
21 views

What are some good puzzles to test my Advanced T-SQL skills? [on hold]

What are some good puzzles to test my Advanced T-SQL skills ?
-1
votes
0answers
18 views

How to convert voice data into text file in hadoop? [on hold]

suppose, I have .mp3 file or any type of voice/audio data, I need to convert into text file. the reason for this conversion is, I want to process the text file which was generated in hadoop ecosystem. ...
1
vote
0answers
12 views

AUTO_BACKUP not even trying to backup database

I've setup 2 identical linux servers with db2 10.5 . AUTO_BACKUP only works on one of them. Also, no health notifications come from that server at all, although postfix on localhost is running and a ...
2
votes
0answers
33 views

Warning for missing statistics in execution plan

I have a situation that I cant understand. My SQL SERVER execution plan tells me that I have missing statistics on the table, but the statistics is already created. Please see the screens. But if ...
0
votes
2answers
22 views

sql server transactional - replication - the internal procedures often deadlock with user processes

Very often I have deadlocks on my subscription server, involving the replication internal stored procedures and user processes either ad hoc or procedure queries. for example: Deadlock of the ...
4
votes
1answer
31 views

How often will a FOR EACH STATEMENT trigger execute if the operation is caused by an FK constraint with UPDATE CASCADE?

I understand that a trigger on table t defined with FOR EACH STATEMENT will run once when I execute an UPDATE t .... Now, when t is defined with FOREIGN KEY ... REFERENCES a ... ON UPDATE CASCADE, ...
0
votes
0answers
40 views

SQL server 2008 [on hold]

I am having a problem that I can't figure out. I have one live server and one test server. The (Live) and (Test) are very similar, but there are a lot of differences because of testing reasons. But ...
0
votes
0answers
10 views

AWS RDS Constant cpu (20%) utilisation

I have a RDS instance that has workload at specific time window, however, cpu utilisation is a constant 20% even outside this window. There is no replication configured. Can't find a solution for ...
3
votes
1answer
47 views

Prevent Inserts without Column List

We have a database running on SQL 2008 R2, in 2000 Compatibility mode. Is there a way to configure the database so that implicit insert statements (i.e. those without a column list) are invalid? I ...
1
vote
0answers
13 views

Spatialite: use of virtual spatial index for distances

I'm currently learning to use spatial access methods for query optimization. I'm going through the examples in spatialite cookbook and got stuck in here ...
2
votes
0answers
18 views

PostgreSQL bytea vs

I'm looking to import large (100Mb -- 1 GB) multi-channel time-series data into a PostgreSQL database. The data comes from EDF format files that chunks the data into "records" or "epochs" of typically ...
0
votes
1answer
21 views

Why have both a postmaster and postgres executable?

It's a little confusing how you have several executables to start postgresql, e.g. postmaster, postgres, pg_ctl. postmaster -D /usr/local/pgsql/data postgres -D /usr/local/pgsql/data pg_ctl -D ...
2
votes
1answer
37 views

Index fragementation ? is it unavoidable

This is follow up question to @martin smith excellent answer http://stackoverflow.com/questions/1251636/what-do-clustered-and-non-clustered-index-actually-mean After that i have watched MCM video of ...
0
votes
1answer
13 views

Generate Schema Only Script from SQL Server 2012 to SQL Server 2008R2

Hi this is the first time that I've encounter this error in generating script for my database, what do you think causes this error? Thanks. Please see image.
0
votes
1answer
18 views

How should I index a UUID in Postgres?

I'm new to PostgreSQL and somewhat new to databases in general. Is there an established way of how we should index UUIDs in Postgres? I'm split between using hashing and using a trie, unless there's ...
1
vote
1answer
20 views

Can you enforce uniqueness in MySQL based on column in foreign table?

I am refactoring one of my database tables and I've come up with an issue. Specifically, I have a table with four columns. We'll call the first three my.a, my.b and my.c. I have a uniqueness ...
1
vote
1answer
138 views

Do I need a database license for my application? [on hold]

I am developing an application for cemetery management. It is my first "big" project, so I'm not familiar with the "corporative" side of this. First, some info about the app: Has 3 local database ...
0
votes
0answers
15 views

MYSQL - number of rows returned equals number of connections?

Does my query get sent to the database once and I get a list of all the results in one shot which I then loop through, or do I have to request the next row from the DB each time? Essentially, does ...
-1
votes
0answers
29 views

Why did windows “repair” delete my database tables?

When I ran windows "repair" it deleted some database tables. Is it possible to quickly restore the tables when I don't have a backup as it's my testing server as windows deleted them? It is now only ...
0
votes
0answers
32 views

sys.sp_reset_connection. Why theres a lot of them ?

Theres a lot of questions here on DBA EXCHANGE. But none of them can help me. I have 2 problems: 1) Using sp_whoisactive, I found lots of sys.sp_reset_connection;1( I know they are ...
0
votes
0answers
34 views

DBA vs DB Engineer vs DB Programmer [on hold]

What are the specific differences between a Database Administrator, Database Engineer, and a Database Programmer. I'm trying to determine which title is truly most fitting for my day to day duties, ...
0
votes
1answer
49 views

Can we create indexes on views in SQL Server? [on hold]

Can we create Indexes on a view in SQL Server 2008? I have heard about indexed view, which can give performance improvement, but the problem is data refresh on those views: Can it be auto updated, ...
0
votes
1answer
31 views

MySQL command “SHOW DATABASES” returns invalid databases

I have a MySQL server with a number of databases on it - 16 if I'm not mistaken. When I run the SHOW DATABASES command I get 30 rows. I would have expected 17 rows: The 16 databases and ...
1
vote
2answers
59 views

How to order by alphanumeric codes in SQL Server [on hold]

I have a table with some project codes. These codes are e.g.: B001, B002, Z15001, Z14001, P003,... I need this result table: Z15001 Z15002 ... B001 B002 ... C001 C002 ... Z14099 Z14098 Z14097 ... ...
0
votes
1answer
11 views

SQL Server Mirroring (with Witness) and Client Timeouts

Can you explain what happens in this situation. Imagine I have a Sql Server Mirroring set-up with 2 databases and 1 witness. Database clients have in their ConnectionStrings the Principal= and ...
0
votes
0answers
20 views

Data Mock up for my table

I want to mock up data for a table. So I need to generate a million sample records for the table? Table structure is like this: CREATE TABLE Employees( EmployeeID int NOT NULL, FirstName ...
0
votes
0answers
26 views

Ongoing Administration comparison PostgreSQL vs Firebird [on hold]

I am trying to decide between these 2 database systems for a project. I have frequently read that Firebird requires practically no ongoing administration once it's set up. Does PostgreSQL require ...
-2
votes
0answers
25 views

Creating Mview in Oracle is throwing error

I keep on getting error when I try to create a fast refresh materialized view. Not sure what is the cause of getting the error. ---PREBUILT TABLE--- Create table k_dim_mvw( id NUMBER(10), time ...
0
votes
0answers
14 views

Excel connecting to SQL Server Database and editing tables [on hold]

I would need to connect from within Excel to a SQl Server table and to be able to edit and update the table rows using that excel. Is there a simple way of doing this without having to write ...
1
vote
1answer
42 views

MySQL Index Creation Internals

Right now there are two ways to build an index of a table in MySQL: Create the table structure first, then import the data and add indexes later. Create the table structure with indexes and then ...
0
votes
1answer
20 views

How to remove data from multiple tables with different foreign keys without using ON DELETE CASCADE?

I have the following SELECT statement: SELECT * FROM "Users" u INNER JOIN "Calendars" c ON (u."UserId" = c."UserId") INNER JOIN "Actions" a ON (c."CalendarId" = a."Calendar_CalendarId") WHERE ...
1
vote
0answers
35 views

MySQL bulk deletions

I am currently looking at how to most efficiently delete rows from a table in bulk. The database I'm using is MySQL with innodb. The table I want to delete from can be any size, but will usually be ...
0
votes
0answers
6 views

Cassandra - save file

I'm new with Cassandra, and even more - I never have such task for habitual RDMS systems, like MariaDB or Oracle. So, how can I store file in to Cassandra's table? Preferably using Python-driver, but ...
7
votes
1answer
337 views

Why is SELECT * much faster than selecting all columns (in a different column order) by name?

On a table with columns a,b,c,d,e,f,g,h,i,j,k I get: select * from misty order by a limit 25; Time: 302.068 ms And: select c,b,j,k,a,d,i,g,f,e,h from misty order by a limit 25; Time: 1258.451 ms ...
0
votes
1answer
14 views

Cannot overwrite file: /var/lib/mysql/ibdata1 when using Percona xtrabackup

I am receiving an error when I am trying to restore from a percona backup to my local mysql server. Cannot overwrite file: /var/lib/mysql/ibdata1 at /usr/bin/innobackupex line 2128. sudo ...
-3
votes
0answers
20 views

best software to run Oracle code [on hold]

what kind of software is best to download on PC with Windows OS to practice in writing and running code in Oracle (let's say at school or for preparing for certification)?
1
vote
0answers
16 views

Certification Test 70-461 [on hold]

I am a student at University of Houston-Downtown and looking to take the Database Administrator certification test sometime in October. I am hoping that someone has been recently been certified or ...
2
votes
1answer
13 views

'sp_releaseschemalock' causing me a blocking issue?

why 'sp_releaseschemalock' causing me a blocking issue? what proccess that must execute sp_releaseschemalock or what function of sp_releaseschemalock? I have searched various forums or blogs about ...
1
vote
0answers
26 views

Postgres not using the index even when rows returned is 5% of the table

I have a postgres table with the following structure: +---------+-------------+-------------+----------+---------+---------+ | id | timestamp | numvalues | text1 | text2 | text3 | ...
0
votes
0answers
17 views

Got an error from unknown thread, /pb2/build/sb_0-13157587-1410170252.03/rpm/BUILD/mysql-5.5.40/mysql-5.5.40/storage/myisam/mi_write.c:226

I am using mysql 5.5.40-log and my default storage engine is Innodb, I found this error in my error log "[ERROR] Got an error from unknown thread, ...
1
vote
1answer
45 views

Why does MS SQL Server return a result for empty string check when Unicode string is not empty

select * from (select N'ግዜ ' as t) as t2 where t= '' the string 'ግዜ ' matches the above check, why is this?
0
votes
0answers
9 views

Database design question for sorta rookies [on hold]

Are there any books or Github examples of how to design a database for use with an android app. Specifically the user will be logging into the app via mobile device or Web browser. I imagine aside ...
0
votes
0answers
11 views

how to do a backup and restore for a single database with mysql enterprise backup

I am Chinese, the documentation of mysql enterprise backup is hard to understand for me, and now I need to finish my job quickly, I wonder is that possible to backup a single database and restore it ...
-1
votes
2answers
15 views

psql: could not connect to server and socket /var/run/postgresql/.s.PGSQL.5432

I have installed postgresql 9.4 and I removed postgresql 9.3 from my computer. Now when I try to run: foo@bar:~$ psql I get the error psql: could not connect to server: No such file or directory ...

15 30 50 per page