krypto69 (6/27/2011)

---

if the can be reconsiled at the end of the day..then you could compress the bak file and restore on the other server at the end of the day.

this...

Yep. Liked it. My review is here: http://my-incompletethoughts.blogspot.com/2011/06/movie-review-green-lantern.html

toddasd (6/22/2011)

---

Ya, major PITA. Screw everything about that. :pinch:

On both my 2005 and 2008 servers, I get

Msg 4104,...

It will ignore any that have a match in that sub-query, so...

Craig Farrell (6/22/2011)

---

So, Bob, What the hell? That's all you got on here? I thought you were a...

Just keep in mind, everyone who uses it, all it tests for is "does it compile". It doesn't make sure it works right, it just tests compilation.

My lawyer says I shouldn't answer those questions any more...

Chad Crawford (6/22/2011)

---

Make sure you...

Before you do anything oddball with the files, can you post the actual backup command being issued?

Ah! Now that's a question I can answer.

The left outer join finds rows that have a match in the second query, AND keeps rows in the first query that...

Craig Farrell (6/21/2011)

---

opc.three (6/21/2011)

---

Whether supplying an explicit column list or a * SELECT...INTO generates a table with no clustered index, i.e. a HEAP. If you're managing large quantities of data...

On the "give them a database with known problems and see what they say and do", that's my prefered interview/screening method.

I actually posted a couple of such database in a...

You're welcome.

Brandie Tarvin (6/20/2011)

---

GSquared (6/20/2011)

---

There are ways around the storage limit, but they're technically a violation of the license agreement, and that's a legal violation that can get your business in...

Check the "Write for us" link on the left side of the site.