3
votes
4answers
187 views

Complete list of possible database “objects”?

When I finished my degree in Programming and Database I remember there being a general list of database "objects" like this: data types (a list unto itself) fields records tables views (sort of like ...
10
votes
2answers
16k views

Suppress SQL Server Management Studio auto complete

Is there a way to temporarily suppress SQL Server Management Studio's auto-complete while typing a query? I don't want to disable auto-complete completely just say hold down some key while typing in a ...
1
vote
1answer
698 views

Rename primary key constraint in Teradata

Does Teradata have a way to rename a primary key constraint, rather than dropping it and recreating it? I'm using SP_RENAME for SQL Server and ALTER TABLE...RENAME CONSTRAINT for Oracle, but I don't ...
3
votes
1answer
708 views

EXECUTE AS does not appear to be changing security context

We have legacy code that still makes use of xp_cmdshell calls. When we migrated to SQL Server 2008, we created a stored procedure that used code after the following pattern: EXECUTE AS 'DOMAIN\ID2' ...
6
votes
2answers
2k views

Should a table have a clustered index even if it doesn't have appropriate fields for it?

If you have a table without a good candidate field or fields for a clustered index (stable, sequential), is it better to have a clustered index on a bad field or is it better to make all table indices ...
5
votes
2answers
3k views

What would cause an orphaned ##MS_PolicyEventProcessingLogin##?

This morning I noticed my SQL Log was filling with the following message. The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'msdb.dbo.syspolicy_event_queue' output the ...
0
votes
2answers
3k views

Is it possible to join derived tables to actual in Access 2007

Is it possible to join derived tables to actual tables in Access 2007 like in SQL Server 2008? I have an example below: SELECT * FROM --MyOtherTable is a "real" table MyOtherTable ...
2
votes
1answer
36 views

How to set the language of a doc to a DB field

Is there a way to set the language of a document body to a value fetch from the DB in SSRS? I tried with a simple expression and I got this error. I wonder what the best workaround is
1
vote
1answer
6k views

How do you load a data file into a specific field?

How can I load data in a text file into a specific field. It's a 30 line log file from some copy operations; nothing fancy. I just want to store it as large text or a blob. The examples I am able to ...
3
votes
2answers
5k views

Will a delete then insert within a transaction cascade?

I had a question about what the expected and actual behaviour for the following scenario is. The scenario is one where a database table ([table1]) is cleared and reloaded every day. The table has an ...
7
votes
3answers
19k views

Why can't this mysql user log in with password?

In phpmyadmin I created a user called "edward" with password and all privileges: Yet when I try to log in via phpmyadmin, it says "Cannot log in to the MySQL Server". When I try to log in on the ...
2
votes
0answers
199 views

MDX Block Calculation Optimisation

I have a query I'm trying to optimise. I have read an article here http://web.archive.org/web/20100823233821/http://www.biblogs.com/2008/03/30/optimizing-countfilter-expressions-in-mdx/ about ...
0
votes
1answer
379 views

Store a small log file as a blob in sqlite

I am utilizing a small sqlite database to keep track of some jobs that run on a linux box. Most of them have small (less than 50 lines) log files... I'd like to store those log files as a record in my ...
0
votes
1answer
5k views

How to Import Data to MySQL RDS Instance?

I have a huge database approx 200GB (Some tables are more than 25GB in size). We are willing to migrate to MySQL RDS Instance.but as it does not provide any ssh access so we can't copy file system ...
3
votes
1answer
277 views

Adding new key(s) to enable partitioning, INSERT performance?

I have a table to storage GPS coordinates with multiple (~30) inserts per second (from 50 different devices) during 12 hours per day, so the table is growing fast, to improve the SELECT speed I was ...
4
votes
2answers
12k views

A Script to insert dummy Data in all tables of Database

I wanted a Script that can loop through all tables and their columns in the database and insert dummy data based on column type and size, so that i can start using the database for testing, and ...
1
vote
2answers
8k views

How to configure postgresql to use multiple cores?

How can I configure postgresql to use multiple cores in a single machine , is it automatically uses it ?
2
votes
1answer
3k views

SQL admin Scripts - Enabling read only access to all databases

I would like a script that will allow our web developers read only access to all databases on our SQL server. Currently we are having to do this manually as we have no SQL expert / DB Admin. Would ...
2
votes
1answer
726 views

How do I connect to Oracle Server without installing Oracle Client on client machines?

I am using Microsoft VB.Net to create a Windows application, and would like some suggestions on how to connect to an Oracle database.
1
vote
2answers
563 views

Merge Replicate and Mirrors

I am preparing some scripts to setup merge replication in our production environment. After completing the export from UAT, I've come across something that doesn't appear like it would work in the ...
4
votes
3answers
7k views

How to compare two SQL Server 2008 configurations

I have a problem with my application that works on my dev SQL Server 2008 (Developer Edition), but not on a production SQL Server 2008. Is there an easy way to export the settings from the production ...
2
votes
2answers
1k views

Table orders regarding Nested loop join in DB2

First I would like to cite the existing post Table order in Join Query so the author is saying that the table order really doesn't make things(result, access plan)different. I have doubt on this ...
8
votes
2answers
4k views

mongodb: replica-set with load balancer

Is there an option for load balancing with mongodb replica sets? I am not asking for a HAProxy or similar, but for a built-in feature from mongodb. Could not find tips for this in the docs.
2
votes
1answer
1k views

Using pgsql_fdw in a function result “ERROR: cache lookup failed for type 0”

Now we want to use pgsql_fdw to select a table of remote postgresql database,When we select the table in a session it is okey ,but when we use the foreign table in a funciton it turns out "ERROR: ...
3
votes
2answers
3k views

Best practices to secure mysql

I don't have that much knowledge about mysql and i would like to secure a MySQL server. We have a few VPS running around the world (6 currently) and they all need to store information in our mySQL ...
2
votes
1answer
2k views

Looking for a Trigger to change inserting strings?

I have an MSSQL Server 2008 Database. There are some tables in my Database like below : table1, table2, table3, .... each table has a NVARCHAR(50) field (Name) Now, I wanna change the strings that ...
3
votes
2answers
734 views

Replicating a Table Structure With no Data Using Merge Replication

I am using merge replication with SQL 2012. I have a table, and it would be useful to propogate that table to the subscribers, but just the table structure, not the actual data. The data in the ...
15
votes
6answers
3k views

Is database normalization dead? [closed]

I've been brought up old school - where we learned to design the database schema BEFORE the application's business layer (or using OOAD for everything else). I've been pretty good with designing ...
2
votes
0answers
1k views

Index usage for database server

How can i fix the Index usage on one of our database server? It says from our Nagios control panel that: Service: DB Index Usage Host: MySQL Cluster Address: ( our IP ) State: CRITICAL Additional ...
3
votes
2answers
2k views

How would I run DELETE queries on a Master Without Executing Same DELETEs on a Slave?

If I want to run a query that will only execute on the master mysql server and not the slave. assuming we have an environment with replication through query logs. Could I and how? The idea is to have ...
4
votes
1answer
1k views

What's the fastest way to replicate a MySQL database from one machine to another?

What's the fastest way to replicate a MySQL database from one machine to another? The two machines are connected via LAN. How to do it without mysqldump? If using mysqldump, is the fastest way $ ...
7
votes
2answers
2k views

Is it safe to run antivirus software on my database servers?

Some implementations of antivirus software are known to Microsoft to cause a variety of problems for SQL Server, and Microsoft has a support article dedicated just to picking the right antivirus ...
1
vote
1answer
4k views

MySQL - SELECT INTO OUTFILE, with a UNION

Is it possible to issue multiple select queries whose resultsets are combined via union, into the same outfile? What I am trying to do, but not working: (SELECT email FROM table WHERE createdate >...
2
votes
1answer
96 views

Why does connecting to a database use tempspace?

Earlier today we had a problem logging into a database that had just been created automatically. When on the actual box (Linux) sqlplus schema/pw, i.e. a local connection, was fine, though, it was ...
6
votes
3answers
11k views

How to log error details when using using try/catch for dynamic SQL backup commands

When issuing a backup command within a stored procedure that uses a try catch and dynamic sql, the error messages are very general when compared to running the backup command directly. Try/Catch ...
2
votes
2answers
3k views

CREATE INDEX for long columns

I am looking for alternative to create index on long column: create table line ( field_key integer not null, value varchar(4000), ... ); create index key_value_idx on line (...
8
votes
3answers
11k views

When should indexes be dropped and recreated?

We are constructing a data warehouse that initially will be 1 TB and will grow around 20gigs every month. For certain tables we are doing daily ETL processes and others we are doing weekly/monthly. ...
2
votes
2answers
1k views

Specify Values for Template Parameters — command

When I create a stored procedure in SQL Server 2008 by using the template, the comments specify a hot-key combination that no longer works: -- Use the Specify Values for Template Parameters -- ...
1
vote
1answer
1k views

Is it possible to do an in-place upgrade of SQL Server 2005 Standard to SQL 2012 Enterprise?

At the moment, I have a SQL 2005 Standard box. I'd like to upgrade it to SQL 2012 Enterprise in-place. When I say in place, I mean an install similar to Office 2010, e.g. it removes the older (Office ...
4
votes
1answer
1k views

can I create an SSRS group without adding the group to the box itself and without using Active Directory?

I want to know if it is possible to create a group "internal" to SSRS without having to add the group to the ReportServer box itself. I do not have permissions to the box to create groups and/or add ...
7
votes
2answers
9k views

Easy Postgresql master/slave replication with automatic failover on Linux?

I need a reliable SQL DB for our application and have been looking at Postgresql's streaming replication support. It seems that it's not hard to setup master/slave replication and you can use the ...
1
vote
1answer
157 views

PostgreSQL Replication for small, low-usage database

I have PostgreSQL 8.4 installed on a headless Ubuntu 10.04 server. Sometimes the server is not available. I would like to continue working on the database, so I thought of installing PostgreSQL onto ...
1
vote
1answer
953 views

How can I trigger this stored procedure on insert?

I have a table of error messages to which errors will be inserted. I also have a table defining interactions between errors. For example, when a "Power Restored" error occurs, it clears any previous "...
6
votes
3answers
1k views

SQL Server parallelism for DML operations

I know SQL Server can use parallelism for certain DDL operation e.g. index rebuild or certain SELECT statements mostly likely in a data warehouse environments when query cost exceeds cost threshold ...
3
votes
2answers
923 views

MySQL insists on trying to use InnoDB even when told not to, please help

We're trying out MySQL 5.5, and have installed it on one of our slave servers as a test run. Our main server is 5.0, and we have zero optimization here for InnoDB, so I want everything to just be ...
37
votes
3answers
86k views

How to identify which query is filling up the tempdb transaction log?

I would like to know how to identify the exact query or stored proc which is actually filling up the transactional log of TEMPDB database.
2
votes
2answers
219 views

mySQL Relational Tables

Say I have 3 tables Products, Orders and Orders Product Products Table ID | StockNum | Description | Price 4 | 452SB | Black | 45.65 5 | 752SA | Green | 17.12 Orders Table ID ...
2
votes
1answer
3k views

MySql command line cyrillic Iinsert result is corrupted

Have putty connection. Putty config : window-->translation-->remote character set-->utf-8 Launch command line MySQL client. Perform insert with cyrillic like: CREATE TABLE `category` ( `catName` ...
2
votes
1answer
1k views

How to speed up mysql query?

I have query : SELECT `school`.`ARCO_name`, `student-`.`ClassSize_7`, `student-`.`ClassSize_8`, `degree_o`.`degree_code`, `accredit`.`full_faculty_3`, `accredit`.`...
0
votes
0answers
22 views

A spatial query return no result when obviously there is result [duplicate]

Possible Duplicate: Less restrictive query return less result due to simple removing one additional constraint SELECT DISTINCT TB.ID, TB.Latitude, TB.Longitude, 111151.29341326*SQRT(...

15 30 50 per page