Congrats, Roy

Gianluca Sartori (5/5/2010)

---

Today I ran across the strangest threads I've ever seen here on SSC:

Want to buy a Ford car?

A sad story from Colorado

They don't seem to be automatic spam,...

Yep, but the backup file won't be 130GB. It will be the data size (with some log records). You can copy 50GB there, restore, then shrink if you really need...

That's crazy. All over the news today on the radio. I think I am in favor of this, though I haven't thought it all the way through. No reason for...

I ought to run some numbers on them, but it seems the Random Word has more replies than this thread on some days.

Why use SSIS? Why not backup and restore?

Fast Track is only for data warehouses. OLTP loads vary so widely.

It's still hard to guess your load. Maybe Lynn is closed on memory, but 1GB a day/150 databases, isn't...

You can use a UNION to grab all results. Query with the FROM having database.schema.object

as in

...

FROM db1.dbo.Accounts

That's great. If only there were some way to get people to actually read...

Mirroring is not designed to hold up the clients.

In high safety mode, with no witness, if the mirror goes down, the principal continues to work. Clients can add data.

In...

The thing to compare is how long the shrink takes v the copy. If the copy is quicker, and it could be since that isn't a lot of downtime, why...

Yeah, that's it. I think I've been working with MS Server products too long.

It's an interesting question. Good to see there's a Connect item on it, and people should have learned things.

Not sure how I feel about the question. Definitely if the server...

webrunner (4/29/2010)

---

Minor spelling quibble. I believe the spelling is "shear forces," not "sheer forces."

Thanks for the editorial, though - it really got me thinking again about the construction metaphor for...

Baking. Made chocolate croissants this morning.