1
vote
2answers
441 views

Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync

I need to synchronize an Sql Server 2005 database in an SQL Azure database. In other posts I've read that I can do this using Sql Data Sync but I don't know if SQL Data Sync can make the ...
0
votes
1answer
23k views

How to move csv file into oracle database using sql developer? [closed]

How to move csv file into oracle database without creating table firstly using sql developer rather than sql loader?
0
votes
1answer
169 views

Which string variables in mysql support utf-8?

I have a table that stores string from a user and is displayed in a web form. But as I see when the user inputs e.g. in a language of cyrilic alphabet (I assume is UTF-8) garbage are displayed back. I ...
1
vote
2answers
148 views

Two possibilities of primary key

I have a table: all_info, where it holds the users identification. This id can be of two types (just one or another, never both), suppose: int and varchar, but one table can't have two primary keys, ...
0
votes
1answer
3k views

Oracle: how to set only some roles as not default for a user (no GUI)

Scenario: I have instanceA I have instanceB I have USER1 in instanceA I have USER1 in instanceB USER1 in instancA has four roles grante to it: ROLE1 default yes admin_option no ROLE2 default false ...
1
vote
2answers
294 views

Curious About SQL Server Registry Entries

I'm working on building some documentation across my systems and planned on simply using Powershell to script out the legwork of what I wanted to do. While that's going all well and good, I ran into ...
7
votes
0answers
289 views

Dropped index from view still referenced in execution plans [closed]

On a SQL Server 2005 Enterprise edition server, an index has been dropped from a view. When running a select * query that includes this view, no results are shown. In addition, the execution plan ...
0
votes
1answer
175 views

Review my simple database tables

Hey trying to create a simple database table for a small beer review project, it been awhile since i have created db's so could anyone just tell me if i am totally wrong here? Especially my use of ...
1
vote
1answer
2k views

UPDATE SET REPLACE() matches but does not change

I've seen another post about this exact thing but it's 1-1/2 years old so I thought I'd make my own...besides, the other post did not help me. What I am trying to do is pretty straight-forward. To ...
13
votes
2answers
64k views

Max Connection Pool capped at 100

I'm running SQL Server 2008 R2 SP1, on a Windows Server 2008 box. I have a .NET script running from Visual Studio 2010 that does the following: Reaches into the database Makes a change Iterates ...
5
votes
2answers
17k views

How to script all permissions on a schema

SQL management studio allows to create scripts for all db objects, however I so far couldn't find a way to correctly script a schema or user. The permissions of a user on a schema are not included in ...
2
votes
1answer
362 views

Data Model: Parent, Child, Grandchild with Child Being Optional

I posted the question in another forum and I was suggested to re-post it here which may be more appropriate. Thank you in advance. My organization structure:    Department -- has ...
2
votes
2answers
3k views

Importing Multipe Trace Files To A SQL Server Table

I am in the process of importing 200+ trace files (which are massive), and my current approach is to perform a loop and insert the trace data (see the below script). I looked around to see if there ...
2
votes
2answers
1k views

How to restrict users to select only query through application textbox field?

Say that I have a web application that lets users to type in a SQL query (SQL Server 2008+). I want users to be able to run any SELECT query and read whatever is in the database, but I do not want ...
2
votes
2answers
3k views

SQL Server 2008 upgrade to SQL Server 2012 on a cluster

I have a Windows 2008R2 2 node cluster with SQL Server 2008 clustered. How do I prevent the cluster from failing over while I am applying the SQL Server 2012 to the alternate node first? Any pointers ...
1
vote
1answer
2k views

Mysql Performance tuning for myisam tables.

Folks I have a 4-core MySQL server with 4 GB of RAM, holding 19 MyISAM tables (total: ~164GB of data) and 32 innodb tables ( 5mb ) and we use it to process CDR files( basically call detail records ...
0
votes
1answer
3k views

SQL Server 2008 R2 Drops Connections when Anti-Virus Scan is running

I have a SQL Server 2008 R2 Enterprise (SP2) cluster (2 nodes Windows Server 2008 R2 SP1, NetApp Shared storage). There are 5 instances all running on this cluster in an active passive configuration ...
-3
votes
1answer
383 views

I am trying to import a file but it gives me exception : ORA-20001: Invalid Operation. while calling a stored procedure, how can i solve this [closed]

I am trying to import a file , but while calling the procedure i get an exception ORA-20001: Invalid Operation. Stored Procedure: begin -- Call the procedure imp_pkg.isinmstimp(cpath => ...
0
votes
1answer
74 views

How to treat a row as a table

I have two tables with the following structures: CREATE TABLE USERS ( USERID VARCHAR2, USERNAME VARCHAR2 ); CREATE TABLE CONFIRMATIONS ( PERSONELID NUMBER, ACCOUNTING VARCHAR2, FINANCE ...
1
vote
1answer
454 views

MySQL select by primary key against 100M of records within 30ms

I have no expirience with MySQL and database performance tuning in general. Wondering whether it is possible to perform a large number of selects against 100 millions of records by primary key within ...
1
vote
1answer
92 views

Mysql, sql server, oracle tables get too large [closed]

I hear a lot about things that, it is a lot cheaper to buy new harddisk than pay staff to come up with genius ideas how to save resources. But what I don't understand, is how these databases handle a ...
0
votes
0answers
431 views

MySQL stops responding (at almost regular intervals)

Using mysqld (latest xampp version). My.ini port= 3306 socket = "D:/xampp/mysql/mysql.sock" basedir = "D:/xampp/mysql" tmpdir = "D:/xampp/tmp" datadir = "D:/xampp/mysql/data" pid_file = "mysql.pid" ...
3
votes
4answers
6k views

How can I recover my tables in sql server database [duplicate]

I deleted 3 tables from my database with data and I have no backup. How can I restore tables with data in my database ? How can I restore tables and data with database log file?(Database recovery ...
0
votes
1answer
117 views

mysql's query cache behaviour on LIMIT

Is it accurate to assume that MySQL's query cache gets checked on subsequent execution of queries in the form SELECT ... WHERE ... LIMIT x, y where the the only varying paramaters in the query are x ...
1
vote
1answer
857 views

Run a program on a remote computer after a SQL job has completed

We have a SQL Agent Job that performs a few tasks every night (schedulled to run using SQL Agent). The database server is SQL 2012 if that makes a difference. We have another process (a .net program) ...
0
votes
0answers
48 views

Seeing recompiles when changed AUTO_UPDATE_STATISTICS to OFF

The reasons why proc cache is flushed are listed here http://msdn.microsoft.com/en-us/library/bb522682.aspx, and AUTO_UPDATE_STATISTICS is not this list. So I changed this option to OFF on production ...
2
votes
1answer
356 views

Help designing tables for storing lab test results: values include numbers, <number, >number

We're using MySQL 5.5 and attempting to design tables to store the results from tests run in a lab. The results of some of the tests can be either a plain number, e.g. "5", or a range such as "< 5" ...
2
votes
1answer
1k views

How to optimize a query that includes counts of rows in multiple tables?

My query looks like this: EXPLAIN SELECT ... FROM USER u LEFT OUTER JOIN (SELECT COUNT(*) notified_count, user_id FROM user_email_tracking ON u.id = email_tracking WHERE email_type_id = 4 ...
2
votes
1answer
1k views

TempDB on Solid State Drives on SQL Server Cluster

Can solid state drives be used for the TempDB on a SQL Server failover cluster if they are local drive on both machines? It is supported in 2012 but our cluster is a SQL 2005. The application that it ...
8
votes
2answers
3k views

Create new database with large initial size

I want to create a new database with a 200GB data file (.mdf) and 50GB log file (.ldf). But it is very slow (it's about 15 minutes and still hasn't created). and it is very time consuming. Is that ...
0
votes
0answers
48 views

Is DBCA in Oracle for a single database or the entire system?

I ask this because I was going to create a simple phone list database for learning. But when I used dbca, I was asked did I want to install the sample databases, HR, etc. It also had the default ...
1
vote
1answer
4k views

How to completely remove EnterpriseDB Installation of Postgresql on Ubuntu?

All, I'm trying to install/run PostgreSQL 9.3, but am receiving a multitude of errors which seem to point to a failed installation of postgresql from the enterpriseDB package. For example, trying to ...
3
votes
0answers
177 views

SQL Server 2012 Resource Governor and memory used by CLR

In SQL 2012 memory used by CLR is now part of what is controlled by "MAX Server Memory" a) Does Resource Governor in SQL 2012 Enterprise (MAX_MEMORY_PERCENT for resource pool) governs CLR memory? ...
0
votes
1answer
43 views

How to determine which `Foos` have no associated `Bars` [duplicate]

I want to find all Foos that do not have any associated Bars. Here's the query I'm using. It's returning no records: select * from foos f where f.id not in(select b.foo_id from bars b); However, ...
1
vote
1answer
4k views

mysql match against boolean mode

I'm using MATCH AGAINST in boolean mode to add a simple search functionality to my site. The column to be searched is varchar, with no full text index. The column value can be alphanumeric, all ...
1
vote
0answers
53 views

Optimizing a query using derived tables [duplicate]

As part of a daily cron job, I need to run a query that processes a whole lot of data. This data is related to the visitors coming to a website, and updating the data with what we have captured ...
0
votes
1answer
867 views

Oracle GoldenGate add trandata errors

I am trying to add trandata to GoldenGate from SQL Server 2008 r2. I am getting an error stating . ODBC error: SQLSTATE 01000 native database error 16954. [Microsoft][SQL Server Native Client ...
1
vote
2answers
475 views

Error deleting FileTable - HRESULT = '0x80070490'

When trying to delete a FileTable, the following error occurs: Message 33405, Level 16, State 7, Line 1 Error during operation on an object table Discard FileTable. (HRESULT = '0 x80070490 ').
0
votes
0answers
90 views

Database design: Modifying an open source database without a lot of changes

I am adding more functionality/features to an open source project. The project is about a forum where each post can be given a specific list of tags. The tags are homogeneous. I.e they are of similar ...
0
votes
0answers
170 views

Lock timeouts on a table with two keys, where only one connection writes for a given value of the first key at a time

I have a table user_rollup_message_list that is keyed by (user_id, message_reference). It is a write-heavy table, and gets enough writes that I get many lock timeouts, with a timeout of 50 seconds, ...
0
votes
1answer
207 views

Altering a parent table in Postgresql 8.4 breaks child table defaults

The problem: In Postgresql, if table temp_person_two inherits fromtemp_person, default column values on the child table are ignored if the parent table is altered. How to replicate: First, create ...
1
vote
1answer
17k views

DB2: The transaction log for the database is full, But there is no 'First active log file'

First, I wish to say that I have very little experience with DB2. However, I've been tasked with tracking down the problem and solution to this problem. This is a DB2 database, and our testers are ...
-1
votes
1answer
49 views

One or two tables (for two things: cancellations and moves)?

A lesson may be canceled, moved to an other time, and possibly switched to an other teacher. In other words, we have lessonid INT UNSIGNED canceled BIT(1) time TIME teacherid INT UNSIGNED Should ...
3
votes
1answer
895 views

Script out XMLA for all databases

I have several SSAS databases. I only want to script out the XMLA for them on a nightly basis. This will be a second tier backup in addition to the regular backups we have. How do I auto-generate ...
0
votes
0answers
132 views

unexpected null returned from calculated columns

I'm working on a program that will calculate journey times based on bluetooth MAC addresses and i'm trying to nail down the mySQL commands I need before I get cracking on the software part of it. i ...
1
vote
2answers
689 views

Get a number nth bit value in oracle

How can I get nth bit value in oracle database? I am currently using this query: WITH a AS (SELECT 7 val FROM DUAL) SELECT CASE BITAND (a.val, POWER (2, n-1)) WHEN 0 ...
4
votes
3answers
746 views

Improve Query Performance over Large Dataset

As part of a daily cron job, I need to run a query that processes a whole lot of data. This data is related to the visitors coming to a website, and updating the data with what we have captured ...
2
votes
1answer
4k views

Connecting to sql azure from ssms throw exception 'sys.configurations'

Connecting to Sql Server Azure from MSSQL Server MGMT Studio, following exception occures : Cannot connect to xxxxxxxxx.database.windows.net An exception occured while executing a Transact-SQL ...
3
votes
1answer
378 views

find total money of parent node of tree according to a particular pattern

actually i am working on a project in which members are added in a tree pattern, and get the payment accordingly. My tbltestingtree structure is ass follow: Id ParentId IsLeft ...
2
votes
1answer
12k views

Cannot set MEMORY_TARGET for Oracle 11.2

I'm trying to configure an Oracle installation on a developer machine (Windows 7 Professional 64bit). The machine has 16GB of RAM and I'd like to configure MEMORY_MAX_TARGET to 8g but have ...

15 30 50 per page