All Questions

Filter by
Sorted by
Tagged with
7
votes
2answers
3k views

Speed up INSERTs

I need to have a way to insert to a table, fast, synchronous, with minimal duration. What I've tried ("blind") is : Have no index on the table whatsoever Switch to simple logging (from full logging) ...
11
votes
3answers
2k views

Why shouldn't I have one table for multiple relationships?

Assuming I have multiple relations in my database, for example Store, Employee and Sale, and I want to connect pairs with a simple binary relationship. Personally I would create tables named ...
6
votes
1answer
2k views

Tuning dedicated Percona Server with XtraDB for OLTP

Hardware specs for an OLTP DB dual quad core xeon with hyperthreading 24GB ram Hardware RAID10 BBU Software specs Standard install of Ubuntu 10.04LTS with default LVM partitioning Installed ...
4
votes
2answers
299 views

Complex SQL query - need help

I have a really hard SQL question! I've inherited a system that allows people to enter dog shows. I have inherited the database with its present architecture, and since there are office systems that ...
7
votes
3answers
3k views

Where to start learning to understand SQL Server architecture and internals?

I have a basic knowledge of T-SQL and SQL Server components. My goal is to master my skills and learn everything about SQL Server to eventually become DBA in the future. I would like to understand ...
1
vote
1answer
445 views

sql server 2008 email notifications

I have set up a profile and operator within SQL Server 2008. I also have an operator that is a group in MS Outlook. When I use the single user address as the notification address when a job ...
4
votes
1answer
159 views

Should the host machine always be restarted after upgrading an SQL Server 2008 instance?

My organization recently upgraded all its production SQL Server 2008 instances to Service Pack 3, Cumulative Update 1. It's my responsibility to make sure that our development database environments ...
3
votes
2answers
157 views

Adding Security to a legacy DB with Schema

I am working on a DB where almost every technical user has full read / write permissions on all tables. We are working towards removing permissions, gradually, from certain users, and I had hoped that ...
9
votes
4answers
2k views

Are there any good reasons for keeping date and time in separate columns?

I'm trying to understand our software vendor's decision to keep date and time in separate columns. For example, when the row was created or updated. Both time and date are DateTime columns. We are ...
2
votes
2answers
420 views

Does the number of indexes effect the modification of table?

First of all Good morning ! Today I got one question regarding indexes and tables. Actually I am not facing problem regarding this but due to curiosity I want to post !! Now come to the point, ...
4
votes
2answers
5k views

Access denied for user 'myuser'@10.% to database 'mydb' - Mysql Import SQL Script

I have a database that I am trying to recreate at my web host. I used mysqldump to create a sql script. My web hosting company, IPage, has a hosted mysqladmin site where I am supposed to be able to ...
3
votes
3answers
803 views

Mysql 5.5 strange behavior with group by with limit based of INDEX vs INDEX FOR GROUP BY

* Update * This bug has been fixed in 5.5.27, 5.6.7 and 5.7.0 I feel like I've found a bug in mysql, but haven't been able to track it down. Any idea what's going on here? This was working just ...
1
vote
2answers
2k views

SSIS error Property BackupDirectory is not available for Settings

I am trying to edit the SSIS Back Up Database Task And it gives the folowing error Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This ...
2
votes
1answer
460 views

Can MySQL 5.1 read a MySQL 5.5 MyISAM file?

We're in the middle of an upgrade from mysql 5.1 to mysql 5.5. Our only remaining holdout is the master, at 5.1, while all the slaves are at 5.5. However, we have a stats process that runs on an ...
3
votes
2answers
540 views

Archive a single giant table from a SQL 2008 database - filegroup backup?

I have an extremely large table (400GB data size, inside a 2.5TB database) that is no longer needed. Before we drop it, however, our client contract says we need to archive it to tape in case in needs ...
5
votes
2answers
5k views

How to obtain SIDs of Sql Server installed NT Service Accounts

I am using WMI to obtain members of server local groups, as well as the SIDs of the members. The WQL queries work for members that are local users, local groups, AD domain users and AD domain groups. ...
0
votes
2answers
213 views

Concat issue has me perplexed

MSSQL 2005 Server Workgroup. I have a database that is serving as a "Warehouse" for another, older, slower cobol database/application. I've recently moved the warehouse from one SQL Server instance ...
3
votes
3answers
2k views

What is the simplest way of excluding the current row from the result of an analytic?

I want to do something like the following: with w as ( select level as foo, decode(level,8,1,mod(level,4))*100 as bar from dual connect by level<9 ) select foo, ...
2
votes
1answer
1k views

Why is my maintenance plan save overwriting job ownership?

I'm slowly untying all the system dependencies to the previous DBA's system account and moving them to a service account. The old DBA had ownership of all the jobs in our maintenance plan. In SSMS I ...
3
votes
2answers
5k views

Oracle 11gR2 expdp table converted to CSV from Linux

With Oracle expdp, I can export the tables I want with expdp INCLUDE=TABLE:table1,table2,table3 I need a way to convert this into CSV on a linux machine. I've seen Windows tools but don't know how ...
2
votes
0answers
623 views

Why is the next scheduled run date for my SQL Server job NULL? [duplicate]

I've been dealing with the Microsoft SQL Server Agent with regards to scheduling jobs. I'm trying to find out what the next scheduled run date for a bunch of jobs that were created where the job ids ...
2
votes
1answer
2k views

MySql: Change from latin1 to utf8

Today my database character set and collation is set to latin1. All of the tables in the database are however already set to DEFAULT CHARSET=utf8 and all data is utf8. Is if it is safe to change ...
2
votes
1answer
438 views

Slow enumeration of schemas and tables in a largish database

We have a Postgresql 8.4.8 database server on a Debian system with a database that has 500+ schemas with roughly 300+ tables each. The schemas and tables are created by scripts, we cannot influence ...
32
votes
3answers
55k views

Table-Valued Parameter as Output parameter for stored procedure

Is it possibile to Table-Valued parameter be used as output param for stored procedure ? Here is, what I want to do in code /*First I create MY type */ CREATE TYPE typ_test AS TABLE ( id int ...
1
vote
1answer
1k views

Create Index with a WHERE clause

I've read the documentation on the MSDN, but it doesn't answer what I'm after. If I create an index on specified columns using a WHERE clause for certain IDs, this will limit the index to those IDs ...
5
votes
1answer
3k views

WAL backups with pg_dump not possible?

I am hoping to move to WAL backup from pg_dump. But I am confused by this note in 4.3 documentation: Perform the backup, using any convenient file-system-backup tool such as tar or cpio. And in ...
6
votes
6answers
12k views

User Windows login name has been changed in AD yet session in SQL 2008 Profiler shows the old Windows login name

Background: a user had her name changed in Active Directory from Domain\oldname to Domain\newname and successfully logged into the network with Domain\newname and yet Domain\oldname appears in ...
5
votes
2answers
1k views

Getting recovered db files to work on rebuilt server

I've had to rebuild my server and have tried to copy the database files from the old drive to /var/lib/mysql/. I have restarted apache and run 'show databases', this list all the databases. I have ...
-2
votes
6answers
31k views

Safely deleting a SQL Server log file (.LDF)

I can make sure my app is in a consistent state. I can rollback all the uncompleted transactions if any (just in case) it's ok I can DETACH the database What do I need the log file for after that? I'...
1
vote
1answer
2k views

Using Apache/ mod_proxy_ajp/ APEX Listener together

Our application is developed with APEX, and it is accessed through APEX listener through HTTP on default port 8080. Now, we want to switch to Apache with mod_proxy_ajp and reconfigure APEX listener to ...
5
votes
1answer
2k views

How can dm_db_index_usage_stats show 0 for user_seeks and user scans but a large number for user_lookups?

I'm probably not understanding something but here is the question. I have done a query on dm_db_index_usage_stats. I've noticed that a couple of my indexes have large numbers (6.5 million and 20 ...
0
votes
3answers
422 views

Is it possible to check a date in SQL?

I'm trying to write a Microsoft SQL Server stored procedure which takes an account ID, and returns an authentication ticket and whether the ticket is expired. Something like this: SELECT ...
1
vote
1answer
145 views

Printing \G on shell using mysql client..?

It is really a a headache for me from some hours i am struggling on the problem.I have also asked it on stack-overflow but not got any answer yet so i am asking here.Sorry for Not a good question. I ...
2
votes
1answer
586 views

Mirroring multiple source databases to a single destination in SQL Server 2008

How can we maintain multiple source databases data in a single destination server database in SQL Server 2008? They all are at different networks, if that makes any difference.
12
votes
3answers
10k views

Database suggestion for a social network/ knowledge base community?

I am looking into various database types and DBMS's for a new project I am wanting to start in the summer. I have built systems in MySQL and postgreSQL , now I am wanting to expand my knowledge and ...
37
votes
4answers
24k views

Does running pg_dump on live db produce consistent backups?

I have a 3GB database that is constantly modified and I need to make backups without stopping the server (Postgres 8.3). My pg_dump runs for 5 minutes. What if the data is modified during the process?...
-2
votes
3answers
81 views

email a database made by My SQL [closed]

I want to email a MYSQL database I created with all tables and queries to other person to check do I use the Import and Export Wizard or there are other ways?
5
votes
2answers
4k views

How to design a schema to store search keywords

I am doing a database design that stores search keywords of a search form, used to generate the most popular search keyword reports by date, month and year. I have made a simple schema: CREATE TABLE ...
41
votes
8answers
22k views

Plural vs Singular Table Name

How should I name my Tables when creating a new database? Singular: Client or Plural: Clients?
0
votes
0answers
40 views

Fix missing performance counters [duplicate]

Possible Duplicate: How to revive SQL Server 2008R2 performance counters? On one machine, I have an instance of SQL Server 2008R2 Enterprise, Visual Studio 2010 and VS 11 Developer Preview. I ...
0
votes
1answer
167 views

Regular expression problem

SELECT FIRSTNAME,LASTNAME, EMAIL FROM CUSTOMERS WHERE REGEXP_LIKE(EMAIL,'[A-Z0-9._%-]{1,10}@[a-z0-9._%-]{1,5}\.[net|com]','i'); I know this is not practical or make a ton of sense, but its a ...
2
votes
1answer
834 views

How to prevent high memory, CPU and time consumption by MySQL restore?

I have a local test machine with 2 GB RAM and a dual core processor. I imported a dump on that using mysql -uuser -psecret < script.sql script.sql is a 700 MB file which contains a single ...
4
votes
2answers
3k views

How could one monitor MySQL replication?

I am not a DBA, but I am interested in knowing how replication monitoring is done on MySQL severs. In order to know if a slave is in sync with its master, one would typically check ...
2
votes
1answer
213 views

Profiler: Only want to see Provider Errors

I'm replaying a trace in Profiler, and I'd like to only see the Provider Errors. Granted, there are ~30,000 of them but I'm not concerned at the moment about row update conflicts, foreign key or ...
4
votes
2answers
713 views

Remove nulls from TSQL connection string

I have a bunch of queries, against a couple different databases, that I use to generate delimited reports. I'm trying to create some new reports against a MSSQL database and I'm having trouble ...
2
votes
1answer
2k views

export data from oracle 10g

I installed Oracle 11g on my computer. When I export data from Oracle 10g, I get the following error code. I have translated the error in parenthesis. EXP-00008: 遇到 ORACLE 错误 904 (encouter oracle ...
2
votes
1answer
3k views

PostgreSQL dump/restore from 8.4 to 8.1 in a shell script

I have to restore a DB table every day from a postgresql 8.4 to 8.1. For the backup, I use this code (windows server): D:\PostgreSQL\8.4\bin\pg_dump -U postgres -p 5433 -t my_table myDB > D:\...
4
votes
1answer
2k views

Migrating Sql Cluster Installation To New Drive

We are migrating from an old SAN to a new SAN and need to migrate our SQL Server instance to new LUNs. We are able to migrate the data without any problem, but the SQL Server instance itself is ...
1
vote
1answer
488 views

Table Statistics Affect Index Only Query?

We have a query that was getting poor performance. The root of the problem could be reproduced using a simple query accessing only one index to retrieve one column (the indexed column) from eight ...
30
votes
8answers
119k views

Get the rank of a user in a score table

I have a very simple MySQL table where I save highscores. It looks like that: Id Name Score So far so good. The question is: How do I get what's a users rank? For example, I have a users ...

15 30 50 per page