0
votes
1answer
36 views

how to create invalid utf-8 characters in MySQL

I'm trying to test some application level ruby methods and how they handle invalid utf-8. I'm trying something like to get invalid utf-8: mysql> update items set header=UNHEX('4D2AFF') where ...
0
votes
4answers
44 views

Whether Logfile Shrinking is good or bad one for Performance in SQL? [duplicate]

I am using SQL Server 2008 R2 database and in that we have more than 70 databases. In a few databases I can see the log file size is more than 10GB. I am shrinking the log file size on a daily basis ...
1
vote
2answers
50 views

How to stop ROLLBACK in progress?

How do I stop a rollback in progress. I killed a very long running INSERT INTO table1 SELECT * FROM table2 statement. I want to commit what's already there but I can't since it's rolling back. This ...
0
votes
0answers
17 views

oracle emca refusing sys password

I want to reconfigure enterprise manager and change dbcontrol http port but emca is refusing the sys password yet am sure its the correct one am using with sqlplus and even logging onto em db web app. ...
0
votes
1answer
31 views

sql server Group by with calculated values

I have two tables: costumer table and invoice table. How to calculate sum(value) for each costumer (id) when I have calculated variables in group by statement - without puting code for calculated ...
0
votes
0answers
26 views

Automatically Transfer Files From server to Database [on hold]

How would I go about transferring files from a server to a database in another server automatically? People access my server, when they do various information gets sent to my server such as ...
-1
votes
1answer
28 views

mysql server is not starting

mysql server is not starting after modifying configurations key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 query_cache_size = 16M after ...
0
votes
3answers
26 views

Last mysql reboot

Is there a way to check the last restart of mysql server, in global variables or something else ? System : redhat Logging : not activated
0
votes
1answer
37 views

Page compression not working?

I have created a table where I have around 100 partitions (per month), all of them are configured to use page compression. After that I'm inserting data to this table month by month. I now would ...
0
votes
1answer
30 views

Risk of disabling page locking

In another question a user asks how to force row level locking. The answer that he receives tell them how to force row level locking by altering the table and the indexes. The user that answered the ...
0
votes
4answers
48 views

Index on 'GROUP BY' with functions

I have a log table. It logs visitor data (time of visit, browser, window size ...). I want to create reports. I use a query like this (MySQL): SELECT COUNT(*) as raw_views ... FROM logs WHERE ...
0
votes
0answers
11 views

SSRS 2012 and SharePoint 2010 Standard

Is it possible to use Report Builder Model, Report Builder Report, Report Data Sources with a Sharepoint Standard 2010 edition?
0
votes
0answers
9 views

How should I implement logs into a document store db?

I am somewhat unsure if I want to use document store(noSQL) for the sake of using it or because it could really help in my situation. Here is my problem, I have users, I can think about them as ...
0
votes
2answers
57 views

View with left joins are very slow

I have a view based on join of 3 tables and and query on view is taking 10 mins to fetch the results. Can anybody help me in reducing the time taken to fetch results? VIEW CREATE view ...
1
vote
2answers
37 views

Improving `GROUP BY` query performance in sqlite3

I have a little web-application that is using sqlite3 as it's DB (the db is fairly small). Right now, I am generating some content to display using the following query: SELECT dbId, dlState, ...
0
votes
0answers
20 views

PHP MySQL: Taking Long time to Insert Record in Table when using Mozilla Browser

Scenario : I am trying to Execute Page which has code to Insert a Record in My SQL Table. Issue : When I am calling this Page from IE/Safari it works well but when I do the same from Mozilla/Chrome ...
0
votes
1answer
20 views

Loading the databases from previous installation mysql

My Windows OS crashed today. Now I have recovered all the files in Program files/MySQL folder.(I don't have the exported .sql file) With the new installation of MySQL 5.6(same as before), can I get ...
0
votes
1answer
31 views

Get complete value of varchar(max) field - SQL Server 2005

I have searched for a couple of hours but cannot find the exact solution for this. In my SQL Server 2005 database table (tableA) there is a varchar(max) column. I want to get complete value of that ...
2
votes
1answer
16 views

Purge mysql and it's configuration completely from MAC.

I, by mistake messed up with mysql's only user and the situation is I can't create new user or give more privileges to existing one. Access denied is the error. Only visible db is info Schema So I ...
2
votes
1answer
29 views

Why is my composite index not used for this table?

I am working with a fairly complicated schema, but I've simplified it for the purposes of this question. Table "public.scheduler_appointment" Column | Type ...
0
votes
0answers
13 views

Failure dialing host after a time, skipping all tasks. Err: `no reachable servers`

I have been using MMS and there're 3 hosts based on Windows for monitoring. They're replica set with 1 primary and 2 secondary. Everything is OK for a long time. Recently, MMS has sent me too many ...
0
votes
1answer
26 views

different outcome based on function execution method

I am mainlining a legacy system and realize that the answer to this may take a deeper explanation of the code but before I go that far I wanted to make sure the solution wasn't something more simple. ...
0
votes
1answer
46 views

Need Advice on Normalizing Database

I have a group of database tables that lack normalization. They all have a similar primary key called 'doc_index', which is either a PK by itself or part a composite PK. As you can see below, there ...
1
vote
3answers
203 views

Using Timestamp plus Integer as Primary Key

In Sql Server, what would the drawbacks and disadvantages be of using a primary key that is: Two Character Table Identifier + YEAR + MONTH + DAY + HOUR + MINUTE + MILLISECOND + random integer between ...
0
votes
1answer
16 views

How can I tell when InnoDB recovery is complete/check its progress?

I'm writing a process to bring up a new instance from our nightly database snapshots, and I want to watch its progress and perform some actions once the database is up. When mysql first comes up, it ...
1
vote
0answers
25 views

Column Data Type for Bitwise Comparison?

I have a table where I have an int32 column storing values for bitwise comparison. I've ran out int space with a int32. I can convert to int64 but that will just prolong the inevitable. Is there an ...
1
vote
0answers
32 views

What could cause waiting for table metadata lock?

I am using a MySQL 5.6 DB with MyISAM tables under FreeBSD 8.3. The main part of code is in PHP, but the problem arises, when I launch the self-written on C++ chat-server. I use the mysql.h for DB ...
3
votes
1answer
49 views

Is support for Parallel Scalar UDF a reasonable feature request?

It is fairly well documented that scalar UDF's force an overall serial plan. Running functions in parallel Given a large number of rows coming into a point in the pipeline where a UDF must be ...
0
votes
0answers
38 views
2
votes
1answer
17 views

Performance impact of Extended Events filter [like_i_sql_unicode_string]

I have created an extended events session in which I wanted to see all queries using nolock hint. I have decided to use it instead of sql trace in order to minimaze possible performance impact. ...
0
votes
1answer
13 views

PostgreSQL - If I run multiple queries concurrently, under what circumstances would I see a speedup? Under what circumstances would I see a slowdown?

I approach you all humbly as one who is NOT a DBA, and I'm sure that my question is fraught with conceptual shortcomings and "it depends on" land mines. I'm also pretty sure that all of you who ...
6
votes
6answers
696 views

Estimate projected database growth

I recently started working with SQL Server 2008 as a DBA trainee. I need calculate the size of the database but also estimate its growth over recent months and the predicted growth for the next 12 ...
1
vote
1answer
33 views

On reboot listeners don't start but restarting the service after will start them

when I reboot ubuntu the listener service comes up but it doesn't seem to have any listeners lsnrctl status LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 24-JUL-2014 15:34:43 Copyright (c) ...
0
votes
0answers
19 views

Derive daily delta from total daily counts? Tsql

I have a table with columns: ID, tableName, totalRowCount, Date Each day I'm appending the number of rows in the relevant table. What I want to do is create a table which has the number of new ...
2
votes
3answers
69 views

Should I shrink my database?

I have a 1.2Tb SQL Server 2008 R2 database which is more than 50% empty, because I migrated a lot of functionality to PostgreSql. The database is still in use, and still somewhat growing, but I do not ...
0
votes
1answer
21 views

Nested cursors, multiple result sets

I'm using a SQL Server stored procedure to generate an Excel report. Basically each "entry" in the report has three parts: Object, Observation, and Points. The observations have a reference to the ...
0
votes
2answers
49 views

How to change schema so that account_id reference is unique among 3 tables

Original image: Updated to have more-correct terminology and an 'is_debit' column: I am designing a (PostgreSQL) schema for a lottery website that uses double-entry accounting. 'jackpots', ...
3
votes
4answers
130 views

Are we a good fit for SQL Server Enterprise and table partitioning?

We currently have a production database that contains millions of records (14 million in the largest table). One function of the database is to provide time sheet information so a single table could ...
0
votes
0answers
29 views

Wrapper function with SECURITY DEFINER is slow

I have a strange behavior of wrapper function with SECURITY DEFINER option. Function 1 - Queries data what is not directly accessible by user. Function 2 - Is a wrapper that calls function 1 with no ...
0
votes
0answers
28 views

How can I decrease FULLTEXT initialization time?

I'm trying to decrease execution time of the a query. Using SHOW PROFILE, FULLTEXT initialization takes about 0.3, which is too high. Other values are at normal level. How can I decrease FULLTEXT ...
0
votes
2answers
19 views

Database design for tracking referral dollars and referred dollars

Dropbox has a great referral incentive program that gives a storage bonus based on whether a person is referred to Dropbox or refers others to Dropbox. What data base design is good for managing ...
1
vote
1answer
22 views

How to handle multiple hierarchies in a data model?

In Sql Server, there is a datatype called HIERARCHYID which helps with hierarchies. In our environment, we have patient data that needs to be classified under multiple hierarchies. Example 1: ...
1
vote
1answer
30 views

How to verify that a certain commit has been transmitted to standby

Scenario: Oracle Data guard 12c with 1 primary and 1 standby, Max. Av. protection mode Primary open, standby mounted (all green in OEM) Perform a dummy CTAS in primary Question: Without opening ...
4
votes
1answer
62 views

Splitting a csv column from select query into multiple columns

I have a stored procedure SELECT [ShipWorks].[dbo].[OrderItem].[Code] AS Code, CASE WHEN (LEN(ISNULL(MAX([ShipWorks].[dbo].[OrderItem].[Location]),'')) = 1) THEN ...
1
vote
0answers
6 views

Can I automate data pulling from VistA databases using MUMPS?

I apologize if this is on the wrong StackExchange website. This seemed to make the most sense because it's a database question and there's no longer a Healthcare IT site. I'm an intern at the VA ...
0
votes
0answers
6 views

Error in 'Master Database Restore' in SQL Server 2012 (Because of difference in SQL Server Build)

I have a backup of a master database that was taken from SQL Server 2012 11.00.2218 build. Now I have a new SQL Server installation with build 11.00.2100. I tried restoring the master database after ...
2
votes
1answer
21 views

Sql Server data files in Windows Azure

excuse me for my bad english I just created a database using the new functionality "SQL Server 2014 data files on Windows Azure" and works quite well, however, I have a table with a Billion records, ...
0
votes
0answers
13 views

Export sql server table connections schema

i am using RazorSQL to connect to a Microsoft SQL Server database. I am looking for a way to visualize the tables connections schema. Do you have any idea how I can export such a view?
1
vote
2answers
20 views

best way to deal with imperfect xls source file that needs to be imported into SQL via SSIS

The data is formatted like this: Date Type Account 1/1/14 AAA 111 112 113 BBB 114 115 ...
2
votes
1answer
34 views

Can SQL Server stop me from running an UPDATE statement without a WHERE clause?

Whenever I have to run an update statement, I always get nervous that I might forget the WHERE clause and overwrite the entire column in the database. Is there any setting or plugin or addon I can ...

15 30 50 per page