In this post I am quickly going show how to convert the existing tables into temporal tables. This is a common requirement I expect we will all encounter […]
SQL 2016 – TempDB Optimizations are enabled by default Woot!!
Last year I had spent a decent amount of time writing about tempdb. With SQL 2016 a lot of those point are validated and enabled by default going […]
SQL 2016 – sys.dm_exec_query_stats upgraded version
This is one the most frequently used DMVs for DBA when troubleshooting performance issues and MS has been adding more columns to the DMV with every release. In […]
Sample Script for Partitioning
First we create the database Then we create the file and partition schema and function Then we bind the table with the Schema
SQL 2016 – Updatable Non Clustered Column store indexes
This might some as a big relief for those who use ODS for Reporting. Previously we have the following limitations with the below types of indexes Clustered Index […]
administration / Azure / MSSQL
SQL 2016 – Basic Availability Groups
With database mirroring out of the picture a question on most SMEs mind was how can we get HA on our SQL machines now? Database mirroring was a […]
Deploying changes to In-memory OLTP tables almost seamlessly
If you’re looking to implement the in memory OLTP tables in SQL Server 2014, one of the biggest drawbacks for the same is the fact that tables need […]
In Memory OLTP Decision Tree
A Very Simplified diagram explaining some key decision points and important aspect of using in memory OLTP in SQL 2014
Attaching a database mdf file when the ldf file is missing – with a catch!!
A few days back I got a call close to midnight where a client’s client was facing an issue. They had recently suffered a power failure and the […]
Proof that tempdb mdf and ldf files are **NOT** dropped at the OS level when SQL Server is restarted
A quick video showing that the mdf and ldf files are actually ** NOT ** dropped during server restart. Thanks to Mike for bringing up this topic. https://www.youtube.com/watch?v=N4eB-uY5MYI […]