So, anyone else rather annoyed at MS for announcing that they're going to end the Technet Subscriptions?

For those of us who are either jack-of-all-trades or just geeks who like to...

Cool, thanks!

Funny thing is, I think I read that article back when it came out...

I'm getting old, my memory ain't what it used to be...

😀

Seriously though, sounds like if I...

Having used this script: When you first run the SQL provided by MS, it creates a Stored Procedure (or if you prefer, installs one)

As for mis-matches, what may be...

Well, this seems to back up what I found: http://www.pythian.com/blog/are-you-switching-to-bulk_logged-recovery-model-know-your-risks/%5B/url%5D although with the recommendation that you *HAVE* to take a TLog backup IMMEDIATELY after you finish the bulk operation and...

OK, where I work, it seems that when they were remodelling (before I started) they "fixed" the air conditioning...

As in, one of the old hands stated where I'm sitting used...

You know, reading the end result of this topic: http://www.sqlservercentral.com/Forums/Topic1468850-2799-1.aspx, I'm wondering why MS doesn't provide a pair of radio buttons in several different places...

Radio button 1 -> MB

Radio button...

Where I work, we're going to get double-whammied next week I think...

People have taken next week off, plus (being govm't) we've got people starting their mandatory furloughs because of sequestration...

Except...

Lynn: Stay safe!

Everyone else: Did everyone (in the US at least) start their July 4 weekend early? Sheesh...

Nothing in here since ~5:30am and that from someone I...

I believe that yes, you would need to run a full backup of the recently restored DB in order to "re-start" the log chain for it.

If you're going to restore...

Stefan Krzywicki (6/26/2013)

Fal (6/25/2013)

I put mine in the oven.

And sometimes I accidentally do one when I put it through the wash...

Brandie Tarvin (6/25/2013)

Blasphemy. Sheer Blasphemy.

Someone take away his golden SysAdmin key. Expel him from the ranks of the...

Uhh, with this:

DBCC SHRINKFILE('WBT', 150000)

😉

(Yes, I know everyone is kidding around, and it's not something I intend to do regularly...):-D

My thanks to Gail!

With her clarifying a few things for me (such as SQLs usage of multiple transaction log files) I was able to run a compression, shrink, clustered index...

Likely if you don't think you're using it, you're probably not (Filestream that is), but easy enough to check:

exec sp_configure 'filestream access level'

If the config value is 0, then Filestream...

OK, I don't know if this might help, but I found a similar issue elsewhere:

Link to topic

Yes, it's from 1999 and concerns Sybase, but it sure sounds like a similar...