Tag Archives: currency

Lock, Latches, Waits and Deadlocks explained weirdly (like never before)!!!

By | August 27, 2015

When conducting MS SQL Server Trainings I often resort to weird examples to explain how certain things work. Over the years I have some favorites that I use over and over. The most disgusting by far would be the one I use to explain Locking, blocking and deadlocks. There are some definite advantages to doing… Read More »

SQL 2016 – Updatable Columnstore Index finally OLTP and DW workloads delivered

By | July 13, 2015

So SQL 2016 comes with updatable non clustered columnstore index. Are you wondering why this is a big deal. It is and here’s why In SQL 2012 the Non clustered Columnstore index was introduced but was severely handicapped by the fact that once implemented the table was read only. In SQL 2014 the Clustered Columnstore… Read More »

OStress.exe – use it if you aren’t already

By | July 5, 2015

I was recently trying to simulate the performance implications of hashing vs encryption and wanted to simulate hundreds of sessions and 1000’s of requested on a username/password table. Most time developers and testers use a test harness for automating this kind of activity or use a load testing tool. I however am not a tester… Read More »

Which is better Delayed Durability or Optimistic Concurrency

By | March 10, 2015

A brand new video covering the performance impact of delayed Durability vs Optimistic Concurrency. Which is better? While both have different behavior and purpose; when it comes down to the basic task at hand both essentially improve write (and in the latter’s case read) performance, so the question was can they be used together, do… Read More »

Single Partition online rebuild in SQL 2014

By | January 16, 2015

If you have a large database then you probably have table partitioning implemented. While I have already blogged a lot about partitioning one feature that is really useful in SQL 2014 is the ability to rebuild an individual partition online. Previously for VLDB that contain partitions you either had to rebuild the index on the… Read More »

Kyu and A?

By | August 15, 2014

Hi Jayanth, QUESTIONHope you are doing good.My question is :Is there a way 2 select from tables with no timeout when u r inserting data into them via BCP/bulk insert with tablock? does nolock work on select statement tables works?   ANSWER yes, it’s called optimistic concurrency. If you enabled the above feature you will… Read More »

FOREX Conversion in OLAP Cube

By | June 23, 2014

I was conducting training recently where the participants asked for a solution on how to convert data from many different currencies into a target currency using an exchange rate table. For those building enterprise cubes this might be a familiar problem since consolidations of amounts across reports is usually a challenge. I remember seeing an… Read More »

What’s next?

By | May 26, 2014

Here are lists of topics we are planning to include in the upcoming blogs. If you would like to see any topics added or covered sooner, please vote for it. Performance Resource Governor OLTP in Memory Tables Identifying IO Bottle necks Optimistic Concurrency Understanding execution plans Security Contained Databases SQL Injection Protecting against SQL Injection… Read More »