1
vote
0answers
48 views

Default Trace activity object not in database listed

I've been collecting information on the default trace however i've noticed something strange. Below is a what i'm running , DECLARE @trc_path VARCHAR (500) SELECT @trc_path = CONVERT(VARCHAR ...
0
votes
1answer
196 views

Approximation of table size for MySQL cluster

I want to make some approximation of table size for MySQL cluster. Please read my reasoning and tell me, if I am right or am I making mistake somewhere. I have simple table with PK (int) and ...
2
votes
3answers
1k views

How to DROP multiple tables from databases?

I have situation where someone mistakenly execute script for creating tables under wrong database. Let's say we have database DB1 which is some test database, and we have to create other database ...
2
votes
3answers
2k views

How can I get a list of tables contained in a database diagram?

I need to get a list of the tables contained in a diagram in SQL Server. How can I do it using an SQL script? I don't need a list of tables in the database, but the list of tables contained in a ...
5
votes
2answers
2k views

How to specify a SQL Server maintenance plan subtask to run unconditionally on success or failure of preceding tasks?

I am having a (rather standard) daily maintenance plan created with SQL Server Management Studio Maintenance Plan Wizard. AFAIU, the penultimate task "Back Up Database Task" will be executed ...
0
votes
2answers
140 views

Does ROLLBACK TRAN honor LOCK_TIMEOUT value?

I have a following stored procedure on my system. BEGIN TRY BEGIN TRAN SET LOCK_TIMEOUT 10000 UPDATE tbl COMMIT TRAN END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK TRAN END CATCH ...
3
votes
1answer
4k views

Oracle 10g: Optimizing an update query that uses a subquery

I have the following query within a stored procedure, and I've been trying to improve its performance to no avail. UPDATE TBL_REPORTING REP SET (REP.ISSUER_ID, REP.ISSUER_NAME ) = ( ...
0
votes
1answer
205 views

SQLite: updating string values

I couldn't find any answer for my question so I'm writing. Are there any restrictions for updating strings in SQLite database ? I'm wondering if any new value is written into database file there ...
9
votes
2answers
10k views

Why does MySQL allow HAVING to use SELECT aliases?

In SQL, as far as I know, the logical query processing order, which is the conceptual interpretation order, starts with FROM in the following way: FROM WHERE GROUP BY HAVING SELECT ORDER BY ...
2
votes
2answers
453 views

Storing revisions in SQL Server (simply much like TFS)

So, what I've got so far: Table: ChangeSets Columns: Id | Comment | Committer Table: Customers Columns: Id | Name Table: CustomerChangeSets Columns: Id | CustomerId (FK) | ChangeSetId (FK) So ...
1
vote
2answers
516 views

Understanding disk requirement to make fail over cluster

Please take a look at the following screenshot. I am trying to make SQL Server 2012 Fail Over Cluster using two nodes. As you know we need to have a shared SAN which will be used by both nodes to ...
0
votes
2answers
2k views

Mysql Server Login and Permission Deny Error

I have a problem with MySQL server. After upgrading MySQL server from 5.3 to 5.4, I am not able to log-in using my MySQL root password (Yes, I am able to log-in without password!). Also not able to ...
1
vote
7answers
2k views

Do SQL Server or MYSQL contain JSON supporting functions?

Do SQL Server or MYSQL contain JSON supporting functions? If so, then please tell me the name of the functions or where else I can find it? I am new in this stuff and I want to implement JSON with ...
1
vote
1answer
109 views

How and where do I upload a mysql database?

I am new to Ubuntu (server edition) and mysql. How do I upload (import) an existing database with a MYSQL or (mysql.zip) extension that was downloaded from a web host (cPanel?) I do not have any of ...
3
votes
2answers
1k views

MySQL memory usage issues?

I have a MySQL instance running on my Ubuntu server that is eating up most of the memory on the machine. I currently have 2 GB of ram installed on the machine, and MySQL is using 1983 MB. Most of my ...
1
vote
2answers
997 views

SSMS command to disconnect after query has finished

In SQL Server Management Studio, is there any way (for example a SQLCMD command or something) to get the SQL script window to automatically disconnect as soon as the query has finished executing?
0
votes
2answers
82 views

moving database from old disk to new disk

I need to move a database from an old disk which is no longer bootable to a new bootable disk. I have been able to mount the old disk. Now I need to move the database from there to a new disk. Can ...
2
votes
0answers
585 views

Using Mirroring to upgrade SQL Server 2008 R2 to SQL Server 2012

I am attempting to mirror a SQL Server 2008 R2 database currently in a fail over with the purpose of doing an in place upgrade. I have installed SQL Server 2012 on another machine to serve as my ...
1
vote
1answer
865 views

SQL Server 2012 - Full Text Search [Break word - Underscore]

Let's say I want to search for a list containing 'PS3': SELECT * FROM [TABLE] WHERE CONTAINS(Title, 'PS3') When the Title is proceeded by an underscore it will not return it. Oblivion-PS3 -> Good ...
0
votes
1answer
3k views

Installing Oracle 11gR2 on Oracle Linux 6 - error possibly related to database (unique) name

Installing 11gR2 on Oracle Linux 6.4. System is a desktop used by one developer. It's on DHCP. Hostname is similar to ip-t3400-1547.mydomain.local Please note I have no issues installing this ...
0
votes
1answer
739 views

connection pooling, transactions, nested transaction and rollback

I've got strange behavior on production. First user request thru application failed, I've got SQLServerException with "Lock request time out period exceeded." After that following requests are ...
0
votes
2answers
490 views

how to create backup for update tables structures in existing DB?

I have Sql Server DB, I know I can Create thru "Generate Scripts" backup for SP and Functions then I just replace inside the script the "CREATE" with "ALTER", that will update the target DB with the ...
1
vote
1answer
441 views

MySQL: Access denied messages

I have just installed Ubuntu on my server and MySQL. I can't make any change in MySQL (seeting password, creating database, etc.) as I ALWAYS get an Access denied error message. I have followed the ...
2
votes
2answers
15k views

Options for Data Encryption in SQL Server 2008 R2 Standard Edition?

I'm helping a friend with setting up encryption of data on SQL Server 2008 R2 Standard edition. Upon original research I thought I could use TDE but did not realize that it was only available for ...
6
votes
2answers
1k views

Increase all primary key values by 1

How do I increase all of my EmployeeID values by one if it is the primary key?
0
votes
1answer
2k views

Why is MySQL database data-files deployed under /var/lib/mysql?

I was wondering why do we deploy data files under /var/lib/mysql/. Is there a logical reason for that, or is that just a "traditional" place for the data? I will value more answers based on standards ...
3
votes
1answer
121 views

Migrating database live while being severely handicapped

I "inherited" a web application which is designed and implemented horribly (both the application and the database). For example, the main data is stored using a sort of emulated key-value storage in a ...
4
votes
4answers
3k views

Sql server full text search performance with additional conditions

We have a performance problem with SQL Server (2008 R2) Full text search. When we have additional where conditions to full-text search condition, it gets too slow. Here is my simplified query: ...
1
vote
1answer
297 views

After successfully execute this query How do i back in previous stage in MySQL

+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ | 1 | Ramesh | 32 | Ahmedabad | 2000.00 | | 2 | ...
0
votes
0answers
921 views

Cannot recover the master database. SQL Server is unable to run

Right, I powered off development server because it was hanged, when restarted directory services database was corrupted, so fixed it, then figured out that IIS Manager's metadata.xml is messed up, so ...
1
vote
2answers
7k views

SQL Insert error Column name or number of supplied values [closed]

I have one of the stored procedures for my replication giving this error Insert Error: Column name or number of supplied value does not match table definition". The stored procedure is ...
0
votes
1answer
215 views

Why is column default value not portable through different RDBMS?

Some ORMs (doctrine) do not support default values in database schema definition, because they states it is not portable. But SQL92 supports the DEFAULT value clause, and all the databases supported ...
3
votes
1answer
336 views

Problem with PostgreSQL and the geqo optimizer

I'm trying to compare the two execution plans (exhaustive search and geqo) from the optimizer, but I always get the same plan from both types. These are the variables I use for geqo: SET geqo = true; ...
1
vote
1answer
749 views

Easy replication for SQL Server: Can it be set up like mongodb or Oracle?

This might look like a noob question... but it isn't. (I have 18 years of SQL Server experience, and three years of MongoDB experience.) The basic scenario is: -- Data Center has big, primary SQL ...
1
vote
1answer
4k views

Can I delete SQL Server 2008 R2 “audittrace” (.trc) files

This is precaution question :) When I was configuring SQL Server 2008 R2 database engine, I checked "Enable C2 audits" which I don't really need. From that time it created a lot of files like ...
0
votes
1answer
55 views

Mapping and Inserting Values into a Specialized table

For a system i'm designing,i have one parent entity,Computer Computer(computer_id,computer_processor,computer_hddrive,computer_memory); A computer can be of two types,Desktop and Laptop,each having ...
1
vote
2answers
854 views

How can I return column names in dot notation in MySQL?

I want to return column names into a table. But I also want to avoid redundancies like 'id' and 'id'. I did: INSERT INTO columns(name) SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE ...
1
vote
2answers
634 views

How to create root user after running mysql_install_db?

I'm installing MySQL on ubuntu and I changed the data directory. I created new data files using mysql_install_db command. So now I need to access my database using root but it won't let me in. I ...
16
votes
1answer
22k views

Upgrade SQL Server 2000 database to 2008 R2 and enable new features

I have recently upgraded SQL Server 2000 database to 2008 R2. What I did was: Shutdown SQL Server 2000 (express) service on old machine, Move datafiles (mydatabase.mdf and mydatabase.ldf) to new ...
0
votes
1answer
592 views

Column 'Comments.Text' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause

They have explained the root of the problem very well and even advised to use max aggregate as a solution. But, lets take the example group_id item_id comment -------------------------------- ...
1
vote
1answer
5k views

Nested with - Incorrect syntax near the keyword 'WITH'

With inside with This is ok WITH CS AS ( SELECT 'ab' as a ) SELECT * from cs http://data.stackexchange.com/mathematics/revision/138658/170321/comment-partition-by-question ...
0
votes
1answer
2k views

AdventureWorks2012: “The FILE SIZE property is incorrect” error while trying to attach sample database “Adventure Works for SQL Server 2012”

I am trying to attach the sample databases, for example, AdventureWorks2012_Data.mdf from codeplex "Adventure Works for SQL Server 2012" into a MS SQL Server 2012 (default) instances on a a virtual ...
0
votes
1answer
178 views

Multiple filters with joins

I just read this qestion: SQL Multiple Filter - Optimal Way I tried this with Northwind. I filter like this: declare @supplier int = 1 declare @category int = 1 select * from products p WHERE ...
2
votes
0answers
174 views

How to give permissions to 90+ SQL Servers without tweaking in each of them?

There are over 90+ MS SQL Servers (SQL Server 2005, 2008 and 2012). All in the same Windows domain (but physically all over the world). How to give a domain user (administrative, or other) ...
0
votes
1answer
127 views

How to reduce table duplication, while ensuring integrity of the database?

For example, in my app I have some class called Contact: case class Contact(name: String, email: String, phone: String) And several other classes have one-to-many relation to that contact (for ...
3
votes
1answer
4k views

How can I find and clean up unused database files?

How can I find and clean up unused (i.e. not used by any attached database) SQL Server database files (.mdf, .ldf, .ndf) that take up extra space on my server?
3
votes
1answer
2k views

query cache hit value is not changing in my database

The query cache hit value is not changing in my database only for some queries.If I write select * from drugs_info limit 1000; the query cache hit has changed, but if I execute the following ...
0
votes
2answers
4k views

Custom Auto-Generated Sequences with SQL Server [closed]

I have Employee table with Empolyee ID column EmpID (nvarchar(5)) , and I want to make EmpID's value to 00001 00002 00003 00004 .... .... How can I make Custom Auto-Generated ...
-1
votes
1answer
161 views

How to Recover corrupt SQL Sever database? [duplicate]

I am running Windows 2000 OS and while using my SQL application a message popped-up, can anyone figure it out, the message is like that. Msg 5172, Level 16, State 15, Line 1
2
votes
1answer
2k views

postgresql replication - pg_stat_replication is showing empty columns

I've a postgresql 9.2 streaming replication setup. It appears that the slave is getting the updates from master and is in sync. I've verified it by looking at pg_xlog dir and process list. $ ps aux ...

15 30 50 per page