Miles Neale (8/7/2008)

---

GilaMonster (8/7/2008)

---

Peter Schott (8/7/2008)

---

From what I've heard, if you just install the DB engine and the basic management tools, you should be OK. Don't install the parts that...

And definitly not to be run when CheckDB says that repair_rebuild is sufficint.

Yup.

In object explorer, right click the database, tasks -> Take offline

To bring it online afterwards, right click the database, tasks -> Bring online

It's not the same as detaching

Make it coffee and you're on.

Files and filegroup backups will not be allowed if you only have one file or filegroup.

To enable log backups you'll have to switch to full recovery and take a...

timothyawiseman (8/8/2008)

---

Several people have mentioned martial arts, which is something I am interested in doing probably with my son when I have the time and money to do it. ...

Run the alter database, then take that database offline, go to the file system, rename the file, bring the DB online. You don't have to restart the entire SQL...

Steve Jones - Editor (8/8/2008)

---

I'd have thought that Gail and Grant would just sit a bow in the corner of their cube and eliminate all complaints in person. Hard to...

You forgot the archers.

If you create the procedure WITH EXECUTE AS, then you don't need to grant any impersonation permissions. Only the person creating the proc will need impersonation rights, not the person...

Check sys.dm_db_index_physical_stats, or run DBCC SHOWCONTIG

Depends whether or not you need or want any of the new...

How big is the table? It's not uncommon for very...

Look here - http://www.sqlservercentral.com/Forums/Topic540094-338-1.aspx

Haven't I helped you with this query before? It looks awfully familiar.