Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic769122-5-1.aspx

No one named 'Grasshopper' here. That's his forum ranking, just as yours is 'Valued Member'

It's one of the ways of moving a database's data and log files to different locations, maybe different drives. Can also be used to move a database from one server...

One other piece of advice that may sound strange. If you get a job offer and find that you'll be the sole DBA, run away. Learning by trial and error...

Pretty much. I'm busy writing up a blog post that'll go into more detail.

And does that mean any...

http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/

Just realised (after checking wikipedia) that District 9 is a movie, not a TV show. According to local cinema site, it's opening here Aug 28.

I've heard of it, but nothing more. Doubt it's shown...

Chad Crawford (8/11/2009)

---

Gianluca Sartori (8/11/2009)

---

Some time ago there was a thread entitled "Should you use your real name as nickname?".

Maybe it's time to start the "Should you use your real...

You need the logical name of the file, not the physical name of the file. Run this in the...

Top recommendations for a clustered index - narrow, unique, non-changing (not an issue in a data warehouse), ever-increasing

Based on what you've said, I'd start with cluster on date_key (the partition...

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ok, couple things.

By truncating the log you have broken the log chain, will not be able to take log backups and will not be able to restore to a point...

sp_helptext

Lynn Pettis (8/10/2009)

---

mtassin (8/10/2009)

---

I'm sure she wasn't hinting at you. I am pretty sure I have an idea or two who she was thinking about as she wrote this...