'twas a pleasure serving with you guys.

That's enough kids.

Not 100% on point but definitely useful for your developement.

https://www.simple-talk.com/sql/t-sql-programming/rbar--row-by-agonizing-row/

Yes,the body can come down, leaving the rest mostly in place.

That being said, you're...

SQLRNNR (5/5/2013)

---

GilaMonster (5/5/2013)

---

Ninja's_RGR'us (5/4/2013)

---

How many situations have you NEVER...

SQLRNNR (5/4/2013)

---

I have seen those demos as well. What I think the takeaway from them is

1. Logging should be stored on a different system

2. Monitors should be in place...

How many situations have you NEVER encountered?

A...

Can you deny access to the windows account linked to sql server? That's how folders / files access works. .cmd is just an exe file AFAIK.

If the file...

MyDoggieJessie (1/11/2013)

---

Agreed. But wouldn't you agree that it would be more helpful (especially since Google is one of the best resources for finding solutions) that if you knew upfront that...

Wouldn't ever be a good idea....

Never done that and I don't think this script is the way to go for that.

If you start a new thread you'll get a tone more help.

Good search.

I get them just fine.

Only 1 daily use and only 37 secs I wouldn't bother much with it.

Truncate reporting table, reload the data. With good indexing in place just reuse that loaded table...

There's only 1 valid test.

FULL restore, including diffs and logs.

THEN run checkDB.

Now you know you're good.

Once that's done you can't move the files because they could get corrupted in the...

Still works for me

http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/