I have just recently started having performance issues on my
biggest Sql Server.  Jobs that had been taking 10 minutes are now
taking 90 minutes to complete.  At first I thought it might be a CPU
issue but when I monitor the usage on the server it rarely goes above

I am using SQL Server 2005
I have a full backup from midnight and a differential backup from 8 am.
I restored the full backup from midnight to a new database, say called
NewDB.

I am VERY new at SQL and trying to fix code to get something to work.
I keep getting this message?  Does anyone know what I need to do to
problem solve?
Thanks -

.. on making a DB map?
Hopefully someone knows of a tool/util.
Here's where I'm coming from:
We have a list of changes to make to our DB and the PHP interface.

Someone else asked this and got referred to a Discussion that didn't
address the question so I'm going to ask again.
If you have a column that typically is going to be less than 12
characters in length, the obvious choice would be to use a

I have a database on a SQL Server 2005 Express. I want to copy this
database along with all its data into another server which is a SQL
Server 2005 (full edition). I can't seem to figure out an easy way to
do this. I tried backing up and restoring database but it told me that

We have problem with SQL Server 2000 : there something in the
application that cause the server out of memory. I suspect this is
because an inefficient and heavy query.
In Oracle we have TOP SQL from Enterprise Manager to see what query

I have a sql script that I use to reorganize indexes with more than 5%
fragmentation and rebuild indexes (ONLINE OFF) with more than 30%
fragmentation. On running this, I found that, the script was working fine but
every iteration updated about 550 indexes. After a run, if I ...

how frequent you guy verify database backup from tape ?
What is the procedure? do you restore from tape and attach to database
Cheers,

Hi, I am going to start as the only DBA in a company, very nervous, since
there is no peer at the company and no transition from the job, could someone
told me when I start, what would be the initial steps to take for starting? I
read some article about daily activities on the ...

Is it possible to specify a server in a backup script & likewise specify a
restore to a different server e.g.
BACKUP DATABASE 'LIVESERVER..' + @DBName
    TO DISK = @Path

My SQL Server Log shows a ton of records starting up two different
databases.  One of them was an old test database of mine, so I deleted it.
However, the other is a production database, recovery mode set to simple.
Can someone tell me why these particular databases were / are ...

I recently took responsibility for a sharepoint 2003 server & corresponding
SQL 2000 server.  The backups are working through a maintenance plan, but
I'd like to implement a richer plan and am having difficulties developing
the best approach.  understand I've not done much care & ...

I have tons of short SPs being called all the time.  The # of milliseconds
on each matters and I'm at a point where pulling data from the hard drive
slows down the operation more than anything.   I've done tuning, etc.    So
if I get more RAM on a SQL Server 2005 than the size of ...

Using SQL2k EE SP3
There's a spid in the activity monitor that has a Last Batch date of
1/1/1900 12:00AM however, the logged In date is recent.  What could cause
this to happen?