0
votes
0answers
6 views

Can MySQL log lock waits?

Is it possible to have MySQL log queries or transactions where lock waits occur? Once can debug specific application errors generated from lock wait timeout errors from the DB but without the ability ...
-2
votes
0answers
8 views

How to connect to Oracle Database using SQL Plus?

I need to connect to a oracle database on a remote host (I have no oracle installed locally) using SQL Plus, I've already installed SQL Plus and looking on the internet got those way to connect but no ...
0
votes
0answers
3 views

How to write a query which recursively returns all foreign key references to a column?

I need to obtain a list of foreign keys which refer to a given column, as well as all foreign keys which refer to those keys, and so on. Order does not matter. I have SELECT s.name, t.name, ...
0
votes
0answers
8 views

After applying SQL Server 2012 SP2, Full-Text Filter Daemon won't restart

Before applying SP2 to SQL Server 2012, I stopped the following four processes in Sql Server Configuration Manager under SQL Server Services: Sql Server SQL Full-Text Filter Daemon SQL Server ...
0
votes
0answers
10 views

Sql Server - Running a Job on Multiple servers

I am using SqlServer 2008. I have a Sql Server Job that checks Disk Space and emails admins if the space is less than 15% Instead of adding that Job to all servers is it Possible to run the Job on ...
0
votes
1answer
6 views

Sql Server Change Data - Insufficient Arguments [on hold]

I am trying to get Sql Server Change Data configured and am running into problems trying to query the tables. My setup: create table Person ( Id uniqueidentifier PRIMARY KEY DEFAULT ...
0
votes
1answer
8 views

Postgres - Inject 0 values when rows do not exist

I have 3 tables that I need for reporting: *dates* date_sk | full_date | day_number_of_month 1 | 2013-01-01 | 1 2 | 2013-02-01 | 1 3 | ...
0
votes
1answer
18 views

How to get best mark for each Student

I can't find a solution although it should be easy one. I have some students and all I need is to get the highest mark of each one in Math. TableName: Students. Columns: Name Mark John 90 John 84 ...
0
votes
0answers
8 views

Return List of Database Users and Server Logins

How can I return a complete listing of all server logins and all database users across my enterprise? Need to include the remote server name, database name, AD account and SQL users.
1
vote
1answer
14 views

Count of 3 consecutive unsynced dates

I have a table set out like so: user_id the_date minutes_asleep ---------------------------- 1 2015-01-01 480 1 2015-01-02 0 1 2015-01-03 0 1 2015-01-04 0 ...
0
votes
0answers
3 views

Using MongoDB with circular object references

Please forgive me from the beginning. I am brand new to document oriented databases and I am sure that I will need guidance to reform the question in order to get answers. I am looking to use MongoDB ...
0
votes
0answers
15 views

Does my MSDN License allow me to use SQL Server Dev on a dev machine? [on hold]

Complete new guy question. Can I install SQL Server Dev version on a machine I use for development? The Dev Machine is a virtual box that I am building and testing an intranet site for my office. I ...
0
votes
1answer
15 views

PostgreSQL Primary key disappears from test table

I have a somewhat convoluted scenario where a test table I had created with a primary key won't return the primary key. pgAdmin III reports there are no constraints. I have the entire PostgreSQL query ...
0
votes
1answer
26 views

MDF file full - cannot find the source of its giant size

All, I am completely at a loss here and I'm hoping you guys can help me out on this one. I am experiencing the following situation on an SQL Server 2008 R2 database. MDF-file: Allocated space: ...
0
votes
2answers
13 views

MySQL always writes simple temporary/memory tables to disk (both tmp_table_size and max_heap_table_size are set to 8GB)

I'm struggling with this issue and just can't figure out why this is happening. CREATE TABLE sitecache._test ENGINE=MEMORY SELECT * FROM website.gallery_likes WHERE 1=0; Every time I execute this ...
0
votes
0answers
13 views

Are there limits to SSRS 2014 RDL files going over to SSRS 2008 (or 2012)?

Is there any incompatibility with reports developed in SQL Server SSRS 2014, and then exported to .RDL files that will be imported into SQL Server 2008?
-3
votes
0answers
18 views

Import Data from SQL Server 2000 to SQL Server 2014

Can I import data from a SQL Server 2000 database to a SQL Server 2014 database? I need this to execute every night. It's only about 10-15 tables/views. If not, can I do with 2012, 2008 R2, or 2008? ...
0
votes
0answers
6 views

new subscriber on existing publication Error number: 20598)

i have Publisher server with one transactional replication on it, one publication with two articles( Microsoft Navision tables), there are 4 servers connected like subscribers and the replication is ...
-1
votes
0answers
3 views

Install mysql udf sys_exec to call php file on trigger

Can anyone explains complete details of installing sys_exec function to call php file on mysql trigger over the SSH. I tried solution given by various links but not luck. please suggest if anyone has ...
0
votes
0answers
7 views

SSAS firewall / restricted direct database use

We want to open ports 2382 / 2384 for users in AD group A (they are supposed to read SSAS data via a sharepoint frontend only). That can be easily done with the windows server firewall, I guess. ...
1
vote
0answers
27 views

Had to force loop join and don't understand why

Hello SQL Server Experts. I have a table (table_A) with about 2 million rows and a table_B with about 10 million rows. SELECT b.title FROM table_A A JOIN table_B B ON A.id = B.A_id WHERE ...
0
votes
0answers
13 views

Unable to start SQL Safe service :Error 1053: Could Not Start or Stop the Service in a Timely Fashion

We are facing quite a tedious issue for past couple of months and we are out of ideas now: We are using IDERA SQL safe to backup the databases for our many server: IDERA was installed earlier by the ...
3
votes
0answers
39 views

SQL Server 2012 Installation Has No Option To Uninstall

I've recently inherited a laptop for testing from a client, unfortunately it wasn't a fresh image so it has some software already installed that's causing me some grief. The short version is their IT ...
0
votes
0answers
12 views

Best practices for selecting partition boundary ranges to maintain empty partitions at both end?

I have partitioned the table based on a date datatype partitioning column. The data for the column starts at "2014-01-01" and ends at "2015-01-01". I know that, the partitions should have empty ...
0
votes
1answer
13 views

How to stop Firebird SuperClassic (run as application) in Win 7?

I run Firebird 2.5.3 SuperClassic as application in Windows 7 64-bit with this command: fb_inet_server -a -m Now, how can I stop/shutdown it from command prompt? I know that I could right-click its ...
0
votes
2answers
20 views

How to change ibdata1 path in mysql?

My ibdata1 file is keep on increasing in size and for a temporary solution, we want to move the file to a separate location with more hard disk space. But, when I change the my.cnf file parameters ...
0
votes
1answer
20 views

How to upgrade MYSQL from 5.6.12 to 5.6.21?

I have been a MSSQL DBA and dont have much knowledge about MYSQL. Does MYSQL also have patches just like MSSQL? I need to do MySQL version upgrade from 5.6.12 to 5.6.21 but i do not have much ...
0
votes
0answers
5 views

Report Server Subscription Configuration ISSUE

I Have Created A Subscription in our Development Server With below Steps. 1)Opened Report Configuration Manager and Configure Email Settings. 2) Opened Report Manager and configured a Report Data ...
0
votes
1answer
37 views

Cannot create MySQL database with name '5e370227_db'

Why am I getting error when I try to create database with name '5e370227_db'? I am getting the following error: mysql> create database 5e370227_db; ERROR 1064 (42000): You have an error in your ...
0
votes
0answers
10 views

Use join to aggregate data from various normalized tables

I have a database as follows: tbl_clients (Primary Key: client_id, Foreign Keys:place_id,district_id,zone_id,country_id) tbl_places (Primary Key: place_id) tbl_districts (Primary key: district_id) ...
0
votes
0answers
24 views

find tables present in a query [on hold]

I have a table with 1 column (varchar(max)) that holds a list of distinct queries. Does anyone have a query that could go through that list and select all table names (not just the first one) from the ...
0
votes
0answers
4 views

why my data is not being sharded?

I am using mongo 2.6.7 I deploy a sharding cluster follow the guide: http://docs.mongodb.org/manual/tutorial/deploy-shard-cluster/ My sharding cluster include: - two replica sets (one primary + one ...
0
votes
0answers
11 views

Single Transaction across multiple Sql Database

I have a 3 sql Databases.I have inserted a same record in 3 databases at the same time. if transaction is not success in one Database ,i should rollback other 2 also...can you help me...
0
votes
1answer
26 views

Facing SQL Error 3403

Recently I was working in SQL Server and I faced an error called SQL Error 3403 which was stating: "Error 3403, Severity 22 During recovery initialization, page %ld was encountered. This page ...
-2
votes
1answer
15 views

Query in mysql is not solving [on hold]

I have two tables as pet details & owner details. In that many, no. of columns like Name,pets_id,Owners_id & Name,Owners_id,Mobile No. respectively. I need a query is to display owner ...
1
vote
1answer
16 views

Select from two tables with not direct relationship

OK i found myself in a dead end, and i know must be a way but my brain is just about to explode. This is the case: I have two tables with tons of rows, one for works done (lets call it works table), ...
3
votes
1answer
160 views

Execution Plans Differ for the Same SQL Statement

As a background to this question the details can be found at this link. In a nutshell: I have 2 SQL statements that are almost identical except for the RIGHT table. The LEFT JOIN is the same and the ...
0
votes
0answers
20 views

Accidental DBA: why we need group permission vs open for the company as a whole

I am an accidental DBA here in the company. I am not a DBA, but I am very protective with my Data. Now we have the company financial information and Inventory database. We created this SQL view to ...
1
vote
0answers
28 views

How to optimize inefficient query in PostGIS

I'm doing some queries on a PostGIS, and some of them take a really long time ( > 60 secs). My queries are like this, except querying different tables (like osm_placesbelow). This query takes about ...
0
votes
0answers
15 views

Can user defined roles cause problems with colliding permissions?

I recently ran into a problem with an application crashing accessing a SQL Server 2008 database. An "APPCRASH" was recorded in the Event Viewer, but I have little else to go on. The tables are owned ...
0
votes
0answers
19 views

Adding a second database to the same instance of a server

I already have a multi user software program running on Windows 7 work stations and the server is running Windows Server 2008r2. I am trying to setup another program using the same server. The code is ...
0
votes
1answer
34 views

Find out beforehand how many records a query has

I develop reports in ExtJS resulting of queries in SQL Server 2012. I use Ext.Grid with paging, therefore I can use offset to limit the amount of records a query will return. But for this ExtJS ...
0
votes
0answers
12 views

Extract timestamp from UUIDv1

Is it possible to extract timestamp from uuid version 1 in PostgreSQL? I am also curious is it possible to order by uuid's timestamp value like it's done in Cassandra's TimeUUID datatype?
0
votes
1answer
15 views

Soccer league ER diagram

I am planning on creating a database to track teams and players in a soccer league. The stats I wish to track are as follows... goals scored/conceeded(gk), assists, minutes played, cards received and ...
0
votes
0answers
15 views

How to determine is a value exists in a column within a partition

I have a set of data where I need to look at partitioned data and determine if a value exists within that partition. Example data: AccountNumber Code Status Credited ...
0
votes
2answers
40 views

Quickly clone a database in SQL Server Management Studio

For testing purposes, I often have to clone databases (onto the same server). Currently I do this by creating a backup and restoring it as a new database. I would love to have such a functionality ...
0
votes
1answer
31 views

Best practices for generating a tnsnames.ora entry

I need to integrate some scripts that export and import data from Oracle databases. They are shell scripts that rely on the TNS name being set up (e.g., scott/tiger@tns). The application owners are ...
0
votes
0answers
4 views

Decision Tree English Rules and Dependency Network in MS SSAS

I created a Decision Tree model in Microsoft Analysis Services (SSAS, Visual Studio 2010). There are two tabs in the Mining Model Viewer tab: (1) Decision Tree that shows a tree itself, and (2) ...
0
votes
1answer
16 views

Can't cast a SPROC parameter?

I have several sprocs that take a date/time input, one of which takes a date only in the form of an nvarchar because it utilizes dynamic SQL. When I try to cast the variable going into the sproc I'm ...
0
votes
0answers
17 views

IMPDP twice with same Oracle EXPDP dumpfile with different results?

At my work, we receive data in the form of an Oracle dumpfile generated by an EXPDP command using Oracle DB 11.2.0.4.0. We import it using IMPDP into an Oracle DB (same version) set up with roles, ...

15 30 50 per page