My first candidate for a SQL Server 2016 migration will be our SQL Monitor database (currently running on a SQL Server 2012 server). I will probably migrate the database during...

Learned something today too!

info.sqldbamail (6/16/2016)

---

Thanks for answering,

Now i understood there will be a buffer pool with data, free pages with 8KB buffers and plan cache and data cache where SQL will load...

That's beyond my comprehesion.

Somehow it seems like the second commit "rolls back" the result of the first commit when READ_COMMITED_SNAPSHOT is set...

Yep, that's it! My test database has READ_COMMITED_SNAPSHOT set to OFF. I changed it to ON, ran...

Both tests should produce the same results, are you 100% sure you executed the statements in the same order as listed in your post?

Interesting article. It leads me to a phenomen I've often seen in the IT industry; people selling in skills they don't posess, calling themselves "experts" in areas they have mediocre...

Buffer cache is just another name for the buffer pool, both names means the same thing: 8k data pages stored in memory. Buffer cache hit ratio is the percentage of...

Stretch database gonna help Microsoft pay for LinkedIn? 😉

I think this is a sensible change to the algorithm.

Steve Jones - SSC Editor (6/14/2016)

---

If you stretch a sales database, say a 100GB database and want to move 60GB of that data away, you're going to pay at least...

The collate clause needs to be specified on every varchar column in the query, also in the JOIN if you're joining on varchar columns.

But the easiest solution is probably to...

tmmutsetse (6/14/2016)

---

I am combining two quries using " union all".when i run the query i get the following errror :

"Implicit conversion of varchar value to varchar cannot be...

I've yet to actually use the Resource Governor. But the question made me read up on it.

15 years back I spent only a fraction of my work time on security related tasks. I can at least count the time spent in percentages today. But to be...