All Questions

5
votes
0answers
16 views

MongoDB Replica Set SECONDARY Stuck in `ROLLBACK` State

During a recent automated update of our mongodb PRIMARY, when the PRIMARY stepped down it permanently went into a ROLLBACK state. After several hours in the ROLLBACK state, there was still no ...
1
vote
1answer
11 views

How to Create Snapshot Backups in MySQL

I've seen a lot of people talking about snapshots backup, even I'm reading a book about mysql but nobody explain the code how to make a snapshots backup. This is what the book says: flush tables ...
2
votes
0answers
12 views

Use multiple columns for location or supertype/subtype?

Given an Equipment entity, it has a location, generically called Whereabouts. This could be a reference to: a User entity (the employee who will use and be responsible for the eqipment for the next ...
0
votes
0answers
25 views

What is the purpose of schemas in PostgreSQL? [closed]

Possible Duplicate: Concept of Schema in Postgresql When I open a database with pgAdmin there is a node called schemas. Until now, I stored all my data in the default schema "public". ...
2
votes
2answers
37 views

Group by minute and two minute intervals

I have a datetime colum and I can easily run queries with a group by on my datetime column. However, I would like to run group queries for minute intervals, two minute intervals, 5 minute intervals, ...
2
votes
1answer
28 views

How do I resolve Postgresql error, “PL/Perl function must return reference to hash or array”?

The follow code used to work in Postgresql 8.4.11 with perl v5.10.1: =# select * From testfunction(); testfunction ------------------------ http://www.google.com/ However, after doing ...
2
votes
0answers
28 views

823 errors on tempdb

Have a couple Fiber channel SAN-attached cluster servers which have been intermittently reporting errors like: 2012-05-09 16:31:54.13 spid74 Error: 823, Severity: 24, State: 2. 2012-05-09 ...
2
votes
0answers
16 views

Query to find optimal filegroups for objects

I have been assigned a task to create four file groups (one per volume) locate tables so that they are located in a manner that during an ETL process no filegroup is being read and written to at the ...
2
votes
5answers
103 views

How to copy complete structure of a table without BACK-UP

How can someone copy a table structure without using backup? jcho360> show create table actor\G *************************** 1. row *************************** Table: ...
3
votes
1answer
13 views

How can I automatically trigger a script when my DB fails over?

I have some Windows services that I'd like to restart after a database failover but I can't find any details on triggering external actions after a failover.
1
vote
1answer
14 views

DML operation against synonym oracle

I have been reading the GoldenGate 11g R2 installation guide and it states: Non-supported objects and operations in Oracle DML: [...] Synonyms [...] But I see in the next section that ...
2
votes
1answer
19 views

Is it possible to estabilish Dedicated Administrator Connection (DAC) using SSMS?

Is it possible to connect to the DAC using SSMS? If I understand correctly, it should be possible by using "admin:" prefix before the server name, but I receive the following message: Dedicated ...
5
votes
5answers
52 views

SSIS ETL Question/Option

In our current prod environment, when the ETL launches, it first checks an environmental variable at the OS level which tells it where the "config" database and table is for it to get the necessary ...
0
votes
1answer
26 views

Can you search using an index while indexes are being updated in oracle11g?

I am using oracle 11g. I noticed some performance problems that causes hanging on some search operations. Can I still search based on an index while that index is being updated in the database?
3
votes
2answers
49 views

Where clause for aliased column

I have a query which parses a string values from a column: SELECT left(DateTimeSent, 17) AS timesent FROM allog_07_11_e query1 When I do: SELECT left(DateTimeSent, 17) AS timesent FROM ...
4
votes
1answer
35 views

How do I find out *why* a user has certain effective permissions?

I know that I can query effective permissions by using sys.fn_my_permissions: USE myDatabase; SELECT * FROM fn_my_permissions('dbo.myTable', 'OBJECT') entity_name | subentity_name | ...
1
vote
2answers
14 views

Is there any significant difference between Month(date) and DatePart(month, date)?

MSDN states that both Month(date) and DatePart(month, date) return the exact same value, however is there any difference between the two methods, performance or otherwise? I'm building some queries ...
2
votes
2answers
31 views

Copying distinct rows from one table to another

In SQL Server, I can copy one table into another by doing: Select * into desttable from sourcetable However, there are duplicate rows in sourcetable and I would like to just copy distinct rows. How ...
2
votes
1answer
15 views

encryption of SSRS subscription emails and attachments

Is it possible to set up an SSRS e-mail subscription, with an attachment, that is encrypted?
2
votes
1answer
38 views

Poor MySQL for Drupal on Shared Hosting

My Drupal site is on a shared host where I cannot modify the my.cnf configurations but the database seems to be performing poorly. Here are some of the flagged issues that I can see... In ...
1
vote
0answers
38 views

performance issues when concurrent requests

We are using SQL Server 2008 R2 on a Windows Server 2008 server. We have some main functions which uses some Stored Procedures which has a lot of sub-queries inside of it. I'll take one SP as an ...
0
votes
1answer
21 views

Group By part of a strings

I have a various date times stored as strings in my sqlserver database. 07/May/2012:00:01:49 07/May/2012:00:02:14 07/May/2012:00:02:26 This column is called datetimesent and it is quite easy to ...
2
votes
1answer
22 views

Rewriting a query to be more efficient

Currently I'm using: SELECT t.CustomerLastName FROM ( SELECT SUM(OrderLine.Amount * Product.Price) AS OrderLinePrice, Orders.Id, Customer.Lastname AS CustomerLastName FROM OrderLine, Product, ...
6
votes
3answers
101 views

Why doesn't InnoDB store the row count?

Everyone knows that, in tables that use InnoDB as engine, queries like SELECT COUNT(*) FROM mytable are very inexact and very slow, especially when the table gets bigger and there are constant row ...
2
votes
1answer
26 views

SET QUOTED_IDENTIFIER issue

I have created a Database Project in Visual Studio 2010 for a database which is in 2008. I am having issues in deploying the database as I don't know why, but at the time of deployment in some ...
1
vote
3answers
17 views

Exporting\Importing a large MySQL data without mysqldump

I'm attempting to export about 150GB of data from a database with hundreds of tables, and have found mysqldump to be very buggy. After running a simple --all-databases dump succeeds, but the import ...
3
votes
1answer
62 views

Combine column from multiple rows into single row

I've got some customer_comments split out into multiple rows due to database design, and for a report I need to combine the comments from each unique id into one row. I previously tried something ...
1
vote
1answer
39 views

InnoDB missing from MySQL

I have no idea of what I have done here, but my InnoDB engine seems to have gone from my MySQL server. I recently upgraded it from the dotdeb repository, then installed mysql-server. There is no ...
1
vote
1answer
18 views

Verification that my SSRS subscription was emailed to a valid address

I would like to know if it is possible to verify that an SSRS subscription that was set up to send an email sent it to a real address. That is, if I put in an email address that is not valid, can I ...
4
votes
1answer
17 views

SSAS Cube in Excel - Show only applicable rows with KPI?

I have a cube built in SSAS 2008r2. I'm exposing it for the moment through an excel PivotTable. I recently added a KPI to the cube, and when I show the KPI in my PivotTable interface it causes ...
3
votes
5answers
82 views

Convert varchar column to datetime

In SqlServer, I have a var char colum with value such as: 07/May/2012:00:06:22 07/May/2012:00:06:22 07/May/2012:00:06:22 07/May/2012:00:06:22 07/May/2012:00:06:22 How do I convert this column ...
1
vote
0answers
22 views

Import CSV file into SQLServer [closed]

Possible Duplicate: Convert varchar column to datetime Hi I am using the SQL server Import wizard to import a CSV file into what will be a new table in my database. An example of the CSV ...
-1
votes
0answers
22 views

xampp lampp unistall and error

Today I installed xampp from their website and just downloaded and extracted on my linux os (using tar xvfz) command and I started it using /lampp start. Everything started perfectly and I wanted it ...
1
vote
1answer
28 views

Filter On Indexed, Formatted DATE

How do I write my calling query (without modifying V_SPECIAL_SAMPLES) to use the index on sample.sample_date (filtering by date first)? I believe it's the TO_CHAR and TO_DATE conversions that prevent ...
0
votes
0answers
18 views

What is an appropriate lightweight data mart strategy for a single source system?

In an attempt to expand my knowledge, I was hoping to begin learning about data warehousing, data marts, and how to leverage them. Based on some previous experience, I remember seeing an architecture ...
1
vote
1answer
13 views

--local-infile=1 using MySQL Workbench?

When I start the MySQL bash client, I have been starting it with --local-infile=1 so that I can import data from a .csv file. Is there any way of doing this within MySQL Workbench?
2
votes
2answers
42 views

How to get all non deleted messages from one user

I have two tables one for messages called default_messages and the other for recipients called default_recipient. This is how SQL for those table looks like: CREATE TABLE IF NOT EXISTS ...
2
votes
1answer
33 views

SQL Server Partitioning - Parent / Child tables

I'm currently investigating implementing partitioning for a fairly hefty (800GB and growing) SQL Server database. All of the data in the tables is relatable to a date/time, however this date/time is ...
3
votes
1answer
24 views

Oracle 11, incremental backup goes wrong

Got a pretty big instance on a one-week backup cycle with an incremental (differential) strategy .. or rather, that's what it was supposed to be. Somehow the daily differentials seem to come out as ...
0
votes
1answer
38 views

NULL values on MDX query (Total Column has Values)

I'm a novice with MDX, so sorry if I've missed something. (and sorry about my english too!) The following query: WITH SET [ROWMEMBERS] AS '{([BIN_SCH_INV_GRO].&[1]) , ...
4
votes
1answer
20 views

Is it possible to give the optimizer more or all time it needs?

Given that the optimizer cannot take al the time it needs (it has to minimize the execution time and not contribute to it) to explore all possible execution plans it sometimes get cut off. I was ...
2
votes
0answers
14 views

Pgpool, Postgresql and Apache tuning (1000 concurrent spatial queries)

I'm trying to configure a load balancing system. I've a python script, invoked through mod_wsgi on Apache, that generates a query and executes it on pgpool: request-> wsgi python -> pgpool -> ...
1
vote
2answers
27 views

How can we add BOOLEAN datatype in mysql query browser?

I am trying to add a BOOLEAN column using EDIT TABLE in mysql workbench, but it automatically changes to TINYINT on applying changes. How can I get the column to be BOOLEAN?
3
votes
4answers
42 views

SQL Server 2005 maximizing performance

Our customer has a Microsoft SQL Server 2005 on Windows 2003 Server Enterprise, R2, SP2, 32bit. Running on Intel Xeon X5560 @2.80GHz, with 8 GB of RAM. Occasionally, the users complained that the ...
2
votes
1answer
23 views

Difference between idx_tup_read and idx_tup_fetch on Postgres

On Postgres 8.4 when you do: select * from pg_stat_all_indexes where relname = 'table_name'; It returns the fields idx_tup_read and idx_tup_fetch, what is the difference?
2
votes
2answers
40 views

Saving SQL Server backup file in multiple parts

I am taking daily backups of a SQL Server database. Right now the .bak file is about 2GB and it is growing day by day. There is a scheduled job is running which moves this .bak file from one location ...
3
votes
1answer
44 views

Single AND operator and multiple OR operators

I wanted to select a record_id with a user_id of 1 and category_id can be 1, 2, or 3. Every SELECT statement should return 1 record. View my sample table here: http://i49.tinypic.com/2ezjtk8.png How ...
1
vote
2answers
42 views

Does Sql Server 2008 support Database Sharding

Does Microsoft support implementing Database Sharding using Sql Server 2008 R2 (any edition). From my limited understanding of it, I think, we could probably implement it using Sql Server Express. But ...
1
vote
1answer
25 views

Clients timing out with no apparent reason

I have a SQL Server 2005 server that's been running fine most of the time. Today the users started to get time outs when opening new connections, including myself when I tried to open another tab on ...
7
votes
4answers
103 views

Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?

Inspired by a Django modeling question: Database Modeling with multiple many-to-many relations in Django. The db-design is something like: CREATE TABLE Book ( BookID INT NOT NULL , BookTitle ...

15 30 50 per page
1 2 3 4 5 … 118