All Questions

Filter by
Sorted by
Tagged with
91 votes
6 answers
83k views

Why would SET ARITHABORT ON dramatically speed up a query?

The query is a single select containing a lot of grouping levels and aggragate operations. With SET ARITHABORT ON is takes less than a second, otherwise it takes several minutes. We have seen this ...
user avatar
5 votes
3 answers
1k views

Which databases support parallel processing across multiple servers? [closed]

I need a database engine that can utilize multiple servers for processing a single SQL query in parallel. So far I know that this is possible with the some engines, though none of them are feasible ...
user avatar
  • 1,145
23 votes
2 answers
40k views

How to change the instance name of SQL Server Express 2008?

On my development machine I've installed SQL Server Express 2008, but it has the instance name .\SQLEXPRESS. I want it to be the default instance. I'm pretty sure that I selected the "Default Instance"...
user avatar
  • 654
4 votes
2 answers
111 views

query plan caching (sql server)

Is there a measure of time frame as to which the execution plan of inline queries will cached?
user avatar
  • 153
3 votes
3 answers
5k views

3NF Vs 2NF, which is more strict?

Which of these is true: If a table is in 2nd normal-form then it must be in 3rd normal-form. If a table is in 3rd normal-form then it must be in 2nd normal-form. I know only one of them is correct, ...
user avatar
5 votes
2 answers
2k views

Oracle - Need help with RMAN Active Duplication on Windows 32 bit to a 64 bit

I need to have an Oracle 11g R1 on a Windows 32-bit duplicated to a Windows 64-bit using RMAN Active Duplication. 32-bit setup: Windows Server 2003 R2 Standard Ed. SP2 Database - Oracle 11g ...
user avatar
23 votes
4 answers
95k views

Grant permissions to run an SQL server job

I have a job on my MSSQL server 2005, that I want to allow any database user to run. I'm not worried about security, since the input to the job's actual work comes from a database table. Just running ...
user avatar
0 votes
1 answer
2k views

Sql Server merge replication primary key violations

Using Sql Server 2008. Pretend I have a publisher and 2 subscribers A and B. The replicated table has a guid on it and also a primary key that is not the guid. Frequently, updates happen at both ...
user avatar
3 votes
4 answers
547 views

Help improving SQL Server 2005 query execution time

One of my stored procedure has long execution time (average around 4 to 7 minutes). I want to make it run faster. I am looking at the execution plan and two things are contributing most of the cost. ...
user avatar
  • 2,323
8 votes
8 answers
2k views

Granting SA privileges for Developers on the development box

In spite of our vehement protests, our management has decided that the development team must be granted 'sa' rights on the development server. The catch is that we, the DB support group are still ...
user avatar
  • 710
5 votes
4 answers
1k views

SQL Server restore from transaction log

In SQL Server 2005, if you have a database with no backup - but it is running in full recovery mode - is it possible to "roll back" some deletes? If yes - how?
user avatar
  • 181
15 votes
5 answers
11k views

Attach/detach vs. backup/restore

I need to transfer the database (as a whole) to another server, to make a duplicate database to setup another test environment. I have two choices: Make a full backup at source server/restore at ...
user avatar
0 votes
1 answer
1k views

SQL Server 2008 - Restore Database With RESTART

I am trying to restore a database from a backup file on a SQL Server 2008 instance using the following SQL command: BEGIN RESTORE DATABASE [MyDataBase] FROM DISK=@db_location WITH ...
user avatar
6 votes
1 answer
4k views

SQL Server Migration restore backup vs copy data and log files

I'm tasked with doing a SQL Server 2000 to 2005 migration. I will be doing a side-by-side migration. I've read from a few different sources that I can either: Perform a backup of the database on SQL ...
user avatar
  • 61
7 votes
3 answers
79 views

What is not persisted in a database backup / restore? (SQL Server 2005)

If I take a backup of a database on a SQL 2005 Server, and then restore that backup to a different (new) database on the same database server instance, what things will not be persisted (things like ...
user avatar
  • 910
11 votes
9 answers
12k views

Load-balanced MySQL cluster without load balancer

I'm looking to create a load-balanced MySQL cluster, but without the actual load-balancer, in order not to add another point of failure or complexity. What I was thinking was to have the following: ...
user avatar
5 votes
1 answer
697 views

SSAS - Inferred Dimension Attributes - are they necessary?

I have a cube with fact tables that have a parent-child relationship: Person-Case. Some dimensions are inferred from the parent, e.g. State in the example below. Person does not have a foreign key to ...
user avatar
  • 151
5 votes
4 answers
7k views

Can I restore a database to a point of time without backup?

I have an SQL 2005 database with logging set to FULL but without any backups. Is it possible to restore it to a point of time?
user avatar
13 votes
4 answers
252 views

SQL Server 2005/8 Query Optimisation Hints

I'm looking at educating a team on writing better SQL Server queries and was wondering what people's best hints were for improving performance. For instance I once had a DBA who insisted that count(*)...
user avatar
34 votes
6 answers
70k views

Load Balancing with SQL Server

What exists today to do Microsoft SQL Server Load Balancing on Windows Server and being transparent to any programmatic access. Is this built in or does a solution have to be purchased? I'm trying to ...
user avatar
5 votes
4 answers
80 views

How do I guarantee data is the same after upgrading SQL Server?

I have to upgrade a database from SQL Server 7 and SQL Server 2000 to SQL Server 2008. Additionally I have to be able to prove in a court of law that the data pre-migration is exactly the same post-...
user avatar
6 votes
3 answers
10k views

Problem Connecting Report Server to Report Server Database in SSRS

I have configured Reporting Services on one Server and have the ReportServerDb and ReportServerTempDb on other server (Future requirement of scale out deployment). I am connecting to these servers ...
user avatar
16 votes
7 answers
17k views

How can I learn to become a DBA?

Question for you DBAs and such: How do you go about learning the skills to become a DBA without having the 'on hands' or on-the-job training? My experience in DB work has been messing with MySQL via ...
user avatar
  • 715
6 votes
1 answer
593 views

SQL Server 2005 Express in VMware causing very high CPU load

I'm having the problems described in KB937745 - very high CPU usage and the Application Log is reporting something like this: The client was unable to reuse a session with SPID SPID, which had been ...
user avatar
  • 161
33 votes
7 answers
203k views

Import a Oracle DMP file into a Fresh install of oracle

A client sent us an Oracle database we need to test against. We don't use Oracle or have any in-house Oracle expertise. We need to setup the database so we can connect to it and debug a problem. I ...
user avatar
5 votes
1 answer
233 views

Change SQL Server 2005 from Standard Edition to Workgroup

I have been tasked with performing an edition change from SQL Server 2005 Standard Edition to SQL Server 2005 Workgroup Edition, on Windows Server 2003 Standard Edition. Due to a previous failed ...
user avatar
41 votes
3 answers
60k views

N prefix before string in Transact-SQL query

Would you tell me, please, when should I use N prefix before string in Transact-SQL query? I have started to work with a database where I don't get any results using query like this SELECT * FROM ...
user avatar
55 votes
4 answers
52k views

What is lock escalation?

I was asked this question at an interview and had no answer. Can anyone here explain?
user avatar
20 votes
5 answers
12k views

SQL Server - separate database for reports?

On our SQL Server, we have a database for each of our web apps. For reports, we use Reporting Services and all report data (including report parameters) come from stored procedures. The stored ...
user avatar
  • 501
48 votes
9 answers
30k views

Is there a tool like Microsoft's "SQL Server Profiler" for MySQL? [closed]

While developing on MySQL I really miss being able to fire up a profiler. I find SQLyog is a good enough replacement for Query Analyzer but have not found a tool that works like SQL profiler. For ...
user avatar
  • 1,084
79 votes
7 answers
167k views

How do I completely disable MySQL replication

I am running dual master MySQL replication and now want to move to a single database with no replication. How do I completely disable replication on both databases?
user avatar
7 votes
5 answers
851 views

Improving SQL Server performance on VMware under Linux

I have a Linux server in a small company (3 users) acting as a domain server and running two VMs under VMware: one has SQL Server 2000 on it and one has SQL Server 2005, in each case running on Win2k....
user avatar

15 30 50 per page
1
1923 1924 1925 1926
1927