All Questions
96,332
questions
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 ...
- 3,512
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 ...
- 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"...
- 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?
- 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, ...
Eve
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 ...
r3d
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 ...
- 383
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 ...
Gary
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. ...
- 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 ...
- 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?
- 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 ...
George2
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 ...
iulianchira
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 ...
- 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 ...
- 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:
...
SyRenity
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 ...
- 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?
Emil
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(*)...
- 415
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 ...
Robert Kozak
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-...
- 151
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 ...
Vineet
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 ...
- 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 ...
- 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 ...
James
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 ...
gss
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 ...
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?
Kilhoffer
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 ...
- 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 ...
- 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?
David Collie
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....
Brad Richards