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...

Excellent, thank you!

(So my bucket analogy was close, except the buckets are also on an escalator getting emptied out eventually and recycled to the bottom... 😉 )

Once more, thanks!

Jason

OK, I might have a solution to this, if what I've heard is correct:

Lets say I have a DB with two log files, lets call them log A and B,...

OK, thanks.

Sounds like I won't be compressing this index / table any time soon then, as using the current size of the index as a guideline I don't believe we've...

flapjack

Up yer butt Jobu!

😀

wolfkillj (6/14/2013)

You got close, Rod, and we'll give you a pass since you're not American.

Here's the lineup:

1st base: Who

2nd base: What

3rd base: I Don't Know

Left field: Why

Center field: Because

Pitcher:...

Please 1gnore my pr3vious p0st

im not Sur3 wh4t came over mee

Brandie Tarvin (6/14/2013)

Weeeellll, it's more like...

Spoilsport...

😛