Blog: Dmitri Korotkevitch


208 blogs updated: 62 min. ago
Locking in Microsoft SQL Server (Part 20) - Range lock (RangeS-U) deadlock due to IGNORE_DUP_KEY index option
As you know, SQL Server uses range locks to protect the range of the index keys. This usually happens in SERIALIZABLE isolation level. This ...
0
11-10-2016 10:21:12 Dmitri Korotkevitch SQL Server
LOB and Row-Overflow Storage in In-Memory OLTP in SQL Server 2016
I think many of us felt quite excited and the same time disappointed with In-Memory OLTP in SQL Server 2014. It was the great and promising ...
0
27-09-2016 10:04:27 Dmitri Korotkevitch SQL Server
How To Move Data and Log Files To Different Drives Keeping the Database Online in Non-Enterprise Editions of SQL Server
We, SQL Server professionals, like Enterprise Edition. It has many bells and whistles that make our life easier and less stressful. We wish ...
9
08-03-2016 09:11:06 Dmitri Korotkevitch SQL Server
Thinking Outside of In-Memory Box: Supporting Uniqueness and Referential Integrity in In-Memory OLTP
As with any new technology, adoption of In-Memory OLTP comes at a cost. You need to acquire and/or upgrade to SQL Server 2014, spend time le...
3
23-06-2015 03:00:39 Dmitri Korotkevitch SQL Server


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.