Available for download: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-vnext-ctp

And Mac, and in Docker containers.

Yes....

I was screaming at my monitor last night.

No. Not until the announcements are made.

Check Twitter later (Grant, Tom LaRock, Kendra, etc) they should be tweeting the highlights (I'm trying to...

For everyone here, if you can, watch the keynote of https://connectevent.microsoft.com/, starting in the next few minutes. There are reasons.

Possibly via the sys.dm_tran_active_transactions DMV, providing the transaction is still active, but in general...

You need an ORDER BY on the outer query. Without said ORDER BY, the optimiser is free to choose plans that return the data in any order at all, as...

That only works if the log records are still in the transaction log (which means you need to be doing the investigation very soon after the delete; minutes, not days),...

I love the Serious Eats site. Good recipes, good discussions.

Don't use sp_who (it dates back to pre-SQL 2000 and has not, afaik, been updated for the new DMVs and new information available)

Build your own query from the DMVs (sys.dm_exec_sessions...

Point your DBA at this: http://www.sqlservercentral.com/articles/books/94938/

Some concurrency matters to keep in mind: http://source.entelect.co.za/why-is-this-upsert-code-broken

farax_x (11/15/2016)

---

GilaMonster (11/15/2016)

---

You're going to have to investigate why that procedure is compiling frequently. There's nothing in the code that would cause compiles or recompiles, so start by tracking down...

Sorry, didn't notice you had SQL Server 2012

Go to this link rather https://msftdbprodsamples.codeplex.com/releases/view/55330, and download the second item there "AdventureWorksDW2012 Data File " and follow the instructions further down that...