Something like this is likely to work

use master

kill 75 -- the connection to the database in single user mode

use [MyDatabase]

alter database [MyDatabase] set multi_user with rollback immediate

If that doesn't work,...

Page Life Expectancy is fairly low at 270 seconds, so you might consider adding more memory to reduce the IO. For example, up it to 64 GB.

The Average Page...

jeffrey yao (6/22/2009)

I think "no primary keys, no constraints of any kind, no indexes, all columns were nullable, and dates were stored in varchar(8) instead of datetime." really has little...

steveb (6/22/2009)

---

Jeff Moden (6/22/2009)

---

jeffrey yao (6/20/2009)

---

Michael Valentine Jones (6/18/2009)

---

Just say that “normalization” is theoretical nonsense that so-called gurus like Date and...

You need to investigate the queue length in more detail on a disk by disk basis. Are the the long queues for reads or writes? Are the long...

Just say that “normalization” is theoretical nonsense that so-called gurus like Date and Celko throw around to try to impress people,...

I attended a public speaking class where the first thing they did was give us five minutes to prepare to give a five minute talk on “How great you are...

We do mainly web based applications, and assign a different Windows account for each web site. The users authenticate to the web site, and the web site account connects...

You should check the growth size setting on your log file to make sure it is not set to a very large value or percent. If it is, set...

Jack Corbett (6/2/2009)

---

I'm not promising that this will scale, but it will give the results you require

DECLARE @table TABLE (date DATETIME)

INSERT INTO @table (

date

)

SELECT

'20090112'

UNION ALL...

select

Hours = datepart(hh,TimeEnd-TimeStart),

Minutes = datepart(mi,TimeEnd-TimeStart),

Seconds =...

Will Summers (5/28/2009)

---

Hmm. I will play around with the backup spanning option. This may help me out a bit. I would have to backup to multiple files...

I always add an index on a foreign key column. If you don't have an index on the foreign key, any join with the selection criteria on the parent...

See the responses posted to this same question on SQLTeam:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126467

If your problem is getting backups to fit on DVDs, you can backup to multiple backup files. SQL Server will split the data across multiple backup files that will...