Has the job worked in the past?

Is there adequate disk space on your F: drive?

Please check your error log for messages and post here as Bru requested.

Lynn Pettis (12/11/2009)

---

GSquared (12/11/2009)

---

On the subject of beer, one of my favorite jokes is that the human body is the world's most efficient machine at turning European beer into American...

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall be mine (or anybody else's...

farax_x (12/9/2009)

---

I changed my search criteria (about wildcard ) and rebuild fts indexes every night. it works better but its not acceptable yet !

my sample query :

SELECT docId,DocSubject,docDate

FROM tblDocument...

Not to mention the other problems that NOLOCK can cause (double reads...

Here's an article about the very topic (table partitioning, reindexing, and VLDBs)

http://www.mssqltips.com/tip.asp?tip=1200

In addition to the why that Jeff posted, are you really sure you want to do this? 52 partitions for one table, have you considered the implications - what...

How about putting your query into a proc that requires an input parameter?

Then you could do something along the lines of

select LEFT(@string,@left)

Inside the proc.

Besides the system databases, don't forget any certificates, master keys or otherwise that need to be backed up separately.

The idea is to be able to get back up and running...

At least he retracted and clarified.

That makes much more sense

In SSMS you can use Database Diagrams. Expand your database, right click the Folder called Database Diagrams and select "New Database Diagram."

Erwin also has a good modeling tool. ...

To back up what Jonathan said, here is an article that talks about Lock Pages in Memory:

http://blogs.technet.com/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx

jwa082276 (12/11/2009)

---

partitions on raid array...

However, in the month I will be moving my data to our san system. I will create one volume for each lun I create; so...

The last 1000 posts have come much more rapidly than I would have thought with all the holidays.

Steve can have #10,000 if he beats everybody to it:-P

Or should the Thread...