3
votes
0answers
26 views
More CPU cores vs faster disks (SQL Server)
I'm part of a small company so as usual covering a number of different roles. The latest of which is procuring a dedicated SQL Server box for our .NET web app. We've been quoted on a dual Xeon E5-2620 ...
4
votes
1answer
30 views
When should tables NOT be compressed
We have two servers. One we just compressed, but I took over this little project and this guy says some tables are not good candidates. As with many others, performance is -critical-.
Is it accurate ...
1
vote
1answer
21 views
Combining data from two SQL Server databases with different data but same struture into one database on the same server
I have five SQL Server databases with the same schema in five different geographical locations. These locations send periodic backups to the central server which I restore in the five respective ...
0
votes
1answer
24 views
Migrating a database from SQL Server 2012 to the cloud
I have a sample SQL Server database which is running on my computer. I have a cloud database account on AWS (free account). I want to migrate the database, with all tables, to the cloud.
How can I do ...
0
votes
1answer
18 views
Label data according to percentile
I have a table name temp with column customer_id , sum and I need to add extra column customer_label (may be on view) which is 1 if customer lies in top 10% according to value of sum, 2 if lies within ...
1
vote
0answers
16 views
MySQL Partitioning Performance
I have a MyISAM table with billions of rows that is still causing me problems because the indexes, even after I shortened them as much as possible, do not fit in my 64GB of RAM.
I am unable to index ...
0
votes
0answers
11 views
MySQL CSV LOAD DATA INFILE … doesn't want to load more than 72 lines
I'm trying to load a .csv file into my database with many lines of input from a website I'm working on. For some reason I can load files multiple times (over and over) into the database but they have ...
0
votes
0answers
13 views
Will Partitions and Indexes on the same table help in performace of Inserts and Selects?
I have a table containing the list of visitors and this table has the following information.
Visitor Browser Information
Visitor Location Information
Visitor Time Information
No of Visits
I have a ...
-1
votes
0answers
37 views
which database suitable for huge inserts for analytics system [closed]
I want to develop a analytics system for very high traffic web sites, that records many behaviors of users. I want to choose a proper database for doing it well.
This database must suitable for huge ...
-2
votes
0answers
24 views
Creating a server on client machine [closed]
I'm trying to learn SQL and this post is regarding two questions.
I know that MySQL is already installed on my machine (OS X 10.8) and I've seen the command line, but I'm not quite sure how to set ...
0
votes
1answer
23 views
How often should MySQL (stock, Percona, etc.) be upgraded?
My organization runs several data-driven web applications backed by various flavors of MySQL on RHEL (i.e. we're just like everyone else!) Some of our web apps use the standard build of MySQL, and we ...
0
votes
0answers
10 views
Unable to restore cpanel database backup
I recently created a complete backup of my cpanel to move it into another server. Now the insert queries generated by cpanel for wp-posts table (corresponding to WordPress posts) are too big since ...
1
vote
1answer
32 views
Can you grant an “Active directory Group” rights to linked server in SQL server 2008 R2?
My company uses sql server 2008 R2. I am trying to grant rights to an Active directory Group rights to a Linked Server. I am unable to do it, it only allows me to grant rights to individual active ...
1
vote
1answer
21 views
Is shrink a safe online operation?
We are planning to run the following space management command:
alter table XXX shrink space cascade
on a production database (Oracle 10g). The XXX table is a transactional table heavily used for ...
2
votes
1answer
31 views
Backup on an empty SSAS database hangs
I created an SSIS package to iterate through all databases on an SSAS instance. It grabs the DatabaseId using AMO in a vbscript, then generates the XMLA to backup each database.
Most databases ...
2
votes
0answers
13 views
Debugging SSAS Timeouts
I have a drill-through problem apparently related to security. Users in one role are seeing timeout failures when trying to invoke a drill-through action. They have permission on the action through ...
0
votes
1answer
31 views
SQL Sever - Remove Duplicates in order
When removing duplicate rows, using the below stated query, how would I go about forcing which of the found duplicates to remove?
I am using this query, from this tutorial:
DELETE FROM ...
4
votes
1answer
24 views
How can I request a flush of the postgresql transaction logs?
I have the following problem: a "vertical" Linux distribution (Sophos UMT) comes with PostgreSQL 9.2 to store its configuration. Unfortunately, since the last update, it seems that the transaction ...
9
votes
3answers
286 views
Updating a table with millions of records, its been 4 days
I am currently updating a table with millions of records, its been 4 days and query is still executing.
I checked the activity monitor its shows that query is running.
In event log there is no ...
1
vote
0answers
35 views
Troubleshooting a SQL Server instance that won't start
I've had a problem with one instance of SQL Server 2008 (the free version) not starting automatically. I always have to right click on the icon in the task bar and start it manually. It is set to ...
3
votes
3answers
103 views
Are individual queries faster than joins?
Conceptual question: Are individual queries faster than joins, or: Should I try to squeeze every info I want on the client side into one SELECT statement or just use as many as seems convenient?
...
0
votes
0answers
14 views
Longest prefix search in Oracle
I have a list of phone number prefixes defined for large number of zones (in query defined by gvcode and cgi).
I need to efficiently find a longest prefix that matches given number PHONE_NR.
I use ...
0
votes
0answers
32 views
How do you take export dump files on Oracle 7.3 running on Windows NT 3.51?
How to take dump files on Oracle7.3 running on Windows NT 3.51?
Should you stand in the Orant/bin folder and run one of the programs there like>
exp73 SYSTEM@[hostname] FULL=Y LOG=EXPORT.LOG
Did ...
1
vote
1answer
18 views
Trigger not Working
I created trigger on table PENDING.
Pending table has 3 columns
uniqueId
duration
maxDuration
I have another table COUNT with 2 columns
req_id
total
Here is my trigger--
CREATE TRIGGER ...
0
votes
1answer
10 views
Mysql settings for query_cache_min_res_unit
What is the best setting for query_cache_min_res_unit for these results:
+-------------------------+-----------+
| Variable_name | Value |
+-------------------------+-----------+
| ...
-2
votes
0answers
26 views
SQLYzer experience [closed]
recently found and installed the 30 days free trial version of Precise SQLYzer (just google it and you'll find it easily). I tried it on my UAT env and so far I find it really great. I'm wondering ...
1
vote
2answers
18 views
Innodb table is taking randomly long time to execute the insert query and in show processlist showing as queryend/updating
Innodb table is taking randomly long time to execute the insert query and in show processlist showing as queryend/updating and it happens for the similar queries for the same table and the queries got ...
2
votes
1answer
40 views
SQL Windowing function to create a running total
I need some help with windowing functions.
I have been playing around with sql 2012 windowing functions recently. I know that you can calculate the sum within a window and the running total within a ...
2
votes
0answers
33 views
Which database could handle storage of billions/trillions of records? [duplicate]
We are looking at developing a tool to capture and analyze netflow data, of which we gather tremendous amounts of. Each day we capture about ~1.4 billion flow records which would look like this in ...
0
votes
2answers
31 views
Join on different types
In a database I have two tables:
The first has a field named taxonomy_id that is an integer
The latter has a field named ID that is a character varying
The two tables are related: if it exists a ...
1
vote
2answers
60 views
Remove scientific notation from an XML column
I have a XML column as shown below:
<Root>
<Row>
<Rowid>1</Rowid>
<date>2013-05-06</date>
<Balance>1.0002E7</Balance>
</Row>
...
0
votes
1answer
17 views
MySQL Err 1032 on only 1 Slave
I'm getting a very strange error on one of my MySQL servers and I'd appreciate some help.
The Setup
I have a separate environments.
* Environment 1 consists of the Master Server and 1 Slave.
* ...
0
votes
2answers
15 views
How can I add a column to multiple tables at once in MySQL Workbench?
I have a MySQL Workbench model (diagram) that belongs to a Ruby on Rails application. I now need to add the created_at and updated_at timestamp columns to each of the tables. What is a quick and easy ...
1
vote
1answer
24 views
Is it possible to define package procedure/function outsize of package body block (for Oracle)?
Is it possible to define package procedure/function outsize of package body block (for Oracle)?
Simplified syntax for defining package body is:
create or replace package body <package_name> IS
...
0
votes
2answers
17 views
Backup SQL Server To NAS
I have seen that there are similar questions like this but I tried all of them and my problem still exist. I want to backup a db.
I created a shared folder on NAS
I can reach this shared folder ...
2
votes
2answers
26 views
Trigger for updating a count of rows from a table into another table
I have these two tables:
mysql> select * from orders;
+-------------+---------+
| Customer_ID | Item |
+-------------+---------+
| A01 | CPU |
| A01 | Monitor |
| A02 ...
0
votes
1answer
29 views
Role audit in Oracle 10g
Is it possible with Oracle auditing to find out if the role can be revoked from particular user without loosing any privileges that he actually uses?
Something like AUDIT webadmin_role BY webapp_user ...
0
votes
1answer
30 views
Upload (someone else's data) to Postgres, SQL Server
I work for a company that does program evaluations for state agencies. Thus, I frequently work with someone else's data. They send me the data via sftp:/, mail, etc. and I load it into either SQL ...
3
votes
4answers
214 views
Query without having to specify table's schema
I imported a bunch of tables from SQL Server 2000 to my 2008 database. All the imported tables are prefixed with my username eg: erpadmin.tablename.
In the table properties it lists 'erpadmin' as the ...
1
vote
0answers
34 views
Record versioning and promotion
Let's say we have this hierarchy:
-World
--USA
---WA
----Seattle
-----Downtown
------1st Ave
-------945 1st ave
------3rd Ave
...
2
votes
2answers
43 views
Partial rollback doesn't decrement trancount
Suppose I have an open SQL Server session, and do the following:
begin tran
insert into People (Id) values (1)
select @@TRANCOUNT -- Prints 1
save transaction tt
begin tran
select @@TRANCOUNT ...
0
votes
0answers
27 views
SQL 2008R2 Trial [duplicate]
I currently have a small db running on SQL Server 2008R2 Express. I'm considering moving to SQL 2008R2 Small Business or Standard to use all the sever is capable of. I have a Dell T610 - 2xQuad Core ...
2
votes
2answers
22 views
Delete SQL Server logins on replicated server
We have a production database which is replicated on another server at a remote location. The local database users (not logins) are also replicated in this database. However, the SQL logins are not ...
0
votes
2answers
31 views
Where should I look for details about 'access denied' errors?
This question derives from Deploying a new database on a new server, an msbuild ssdt rookie issue.
Since I have a permission denied error, I expect to find which user is failing to access so I can ...
-1
votes
0answers
23 views
script to startup oracle database [closed]
I found out below script that helps me to start up a Oracle database:
set serveroutput on;
WHENEVER SQLERROR EXIT SQL.SQLCODE
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "MY_DB" NORESETLOGS ...
1
vote
0answers
18 views
BLOB storage in rows
I have a database that has several BLOB columns scattered across multiple tables. Since I am a developer and am looking at making application code writing easier, I wanted to turn these columns into ...
-1
votes
0answers
29 views
Bulk inserts in Oracle 11g SAN cluster environment
A Large Volume of Data from a table need to populated into another table this is taking a very long time Using SQL Developer on an Oracle 11g SCAN Cluster Environment. We experience Connection ...
0
votes
0answers
19 views
where is oracle session timezone set?
I have a logging table
CREATE TABLE EMAIL_LOGGING
(
ID NUMBER(9) NOT NULL,
SEND_DATE TIMESTAMP(6) DEFAULT LOCALTIMESTAMP NOT NULL,
...
0
votes
1answer
15 views
How to automate Oracle DB installation (like a 'hands-free' install)?
I installed the Oracle 11g2 'standard' edition using the following zip-files:
linux.x64_11gR2_database_1of2.zip
linux.x64_11gR2_database_2of2.zip
I used the installation guide by Oracle which I ...
-2
votes
0answers
31 views
How can I group sql rows by hours? [closed]
My table:
tbl_questions =>
qid
question
detail
mcid
cid
uid
answercount
dateposted
status
showname
emailnotify
question_type_id
I would like to get all rows group by hours. {dateposted = Y-m-d ...
