Can you post the execution plan please, not a picture of part of it?

Index and table definitions would also be useful.

Please note: 7 year old thread.

Labour law where I live mandates 30 day notice period for resignations, so it's more a case of notify management, find out whether they require you to work the notice...

I've gone partially kindle (well, kindle for the iPad), partially paper for books. If I've started a series in paper, I want the entire series that way. If I've started...

Since they're not automatically evil and are useful for a lot more than...

sgmunson (6/25/2015)

---

but we all use DATEADD() or DATEDIFF() or GETDATE() in WHERE clauses all the time, and no one raises their hand and says "not a good idea" about...

Excuse me?

No they're not. Rebuilding the clustered index doesn't affect nonclustered indexes in any way.

SQLBill (6/25/2015)

---

For me, he was building up this world/environment where the ruler was killed, a split happened, and fighting was going on to determine the 'rightful' ruler. I 'knew'...

Bookshelf 2

There's a lot of empty spaces because of the recent cleanup and trip to the 2nd hand bookshop. Still piles of books in my bedroom which need to be...

As promised, the bookshelves.

jralston88 (6/25/2015)

---

For example - if you had a vlf status 2 at the very of your answerset, would you be able to shrink the ldf at all -...

Firstly, repair_rebuild is not going to do a damn thing.

and that's the same for both DBs

Try repair_allow_data_loss...

Possibly because it couldn't grow fast enough, possibly because there isn't space on the disk,...

It'll be 2TB, not 2GB and that's the max size that a transaction log file can reach, so it's the same as unlimited.

btw, the error was telling you the data...