Yes we're using Ola - now. I'm in the process of tearing out MPs (for index maintenance anyway) from 200+...

No reason, it can be switched to simple mode; the people who set it up in the past did not have very stringent requirements for information when doing these things....

Cool.

We did find the cause if the issue. Log records were being marked inactive by the software doing the log reading, not by the log_truncate command.

"How? Why?"

It's Oracle...

Try this: http://blogs.msdn.com/b/powershell/archive/2008/09/02/speeding-up-powershell-startup-updating-update-gac-ps1.aspx

Don't forget to add it to the stairway list: http://www.sqlservercentral.com/stairway/110890/

Just wanted to point out I was looking at the result of a LINQ query last week that was causing a deadlock.

Update [Table] -- Ok

Set [Some Field] = @P1 --...

I'm not sure if the post is making fun of BitCoin, the programmers, the business people who signed off on the programmer's design decisions, the programming philosophy of eventual consistency,...

SQL Swerver (7/15/2014)

---

...is there any news on SQL Data Sync? I can find old postings on TechNet and MSDN but cannot see any sign of that functionality within the Portal....

That's weird but then again Visual Studio co-installs often have all kinds of stupid issues.

For the record I did have 2008 BIDS and SSDT 2012/BI installed on the same machine....

Jeff Moden (7/14/2014)

---

It's just such small-fry that used to choke the server I took over because there were many such small fish that got executed hundreds of millions of times...

I'm 7 years late but that last bit of sample code is referencing a non-existent field SomeVal instead of RowNum created in the table just prior 🙂

Haha. What's hilarious about this is that snapshots had crossed my mind but I had immediately dismissed it with, "Nobody would run then that frequently!" 😛

Isn't the cause something between the Sch-S and Sch-M locks? How does an update factor into that?

I would have done what you did; recognise that SQL is such a large product that even the smartest people have gaps in their knowledge and try to explain as...

Jeff Moden (7/10/2014)

---

There's actually been an MS CONNECT item open on that very subject. It almost has 800 vote-ups, has been open for years, and yet MS has done...