Tara Kizer posted a stored proc on her blog for REORGANIZE (INDEXDEFRAG) or REBUILD (DBREINDEX) in SQL 2005. She has put a lot of work into working with the...

This code will work the same no matter what the setting of DATEFIRST is.

create table #t (

order_id int ...

Paul White (5/2/2009)

---

Michael Valentine Jones (5/2/2009)

---

You can restore files or filegroups independently, but as a final step, you need to apply transaction logs to bring the database forward to a...

Paul White (5/1/2009)

---

Michael Valentine Jones (5/1/2009)

---

You should use separate databases if you want to be able to restore data independently.

Backup and restore by filegroup is just a way to spread...

troy.hodge (5/1/2009)

---

I am fairly new to SQL Server, and an IBM DB2 DBA by training. We are implementing a new project here at work and I am curious about this.

Our...

Since most of your tables are heaps (no clustered indexes) you may run into severe performance issues with you application that you cannot fix without either reloading the table completely...

He posted the code for a lot of these functions in the Script Library forum on SQLTeam as user Igor2004

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

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

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

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

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

You can search the Forum at this URL to see if...

I saw it in the theater at an afternoon showing on opening day.

I remember setting close to a stew bum who kept getting woken up by the movie. It...

The problem with shrinking in large chucks is that everything is all or nothing. If you have to interrupt it, the file ends up the same size.

I have never...

Tell the auditors that they will have to supply their own server(s) because Access will cause problems on the production server

They can restore the prod DB onto their server and...

Being interested in about 30 people out of 1,000 resumes sounds about right. I got about 100 resumes from headhunters the last time we were hiring, and I actually...

usman.tanveer (4/24/2009)

---

Thanks Gail i appreciate your suggestions.

Here is the script for the problematic table, 2 indexes on the table, and 2 queries that are coming for this table, and these...

You can alter the way the default read_committed isolation level works by setting the database option read_committed_snapshot on. The result would be that snapshot isolation would be used by...

Greg Charles (4/23/2009)

---

VG (4/23/2009)

---

Are sure you have added logging to the SSIS package. By deafult there is no logging, you have to define it , with connection string to msdb,...

You have to restore into STANDBY mode, instead of RECOVERY or NORECOVERY. Check the syntax of the RESTORE command in SQL Server 2005 Books Online.

There are limitations:

1. You have...