SQL Server Education (by the geeks, for the geeks)
Hi Friends, As a DBA, we know about various Instance level settings in SQL Server like MAXDOP, Cardinality Estimator related changes and various Trace Flags etc. There may be some scenarios …
SQL Server 2016 – Database Scoped Configurations Read MoreHello Friends, Getting back with you my new blog with DIE. 🙂 Sound interesting & crazy at same time. Yes, SQL Server 2016 is getting to us with a new T-SQL …
DIE (DROP IF EXISTS) in SQL 2016 Read MoreHi Friends, Today, I am going to show you an interesting thing about SQL Server 2016 – Instant File Initialization. We all knew about the Instant file Initialization feature. For those …
SQL Server 2016 – Instant File Initialization Read MoreHi Friends, Many improvements and new features are there in the SQL Server 2016. One of that change is about the model database default settings in SQL Server 2016. We know …
SQL Server 2016 – Model database default settings Read MoreHi Friends, I hope that most of us uses SERVERPROPERTY in SQL Server to collect various information about the Instance. I used SERVERPROPERTY most of the time when I got a …
SQL Server 2016 – New SERVERPROPERTY properties Read MoreHi Friends, Wait stats, I hope all of us who are working with SQL Server are aware about this thing. SQL Server DBA generally uses sys.dm_os_wait_stats DMV in SQL Server to …
DMV in SQL Server 2016 CTP – sys.dm_exec_session_wait_stats Read MoreIn SQL Server 2014 a new feature In-Memory OLTP was introduced which was referred as ‘Hekaton’. This feature was introduced to work with memory-optimized tables rather than working with disk based …
Changes in In-Memory OLTP in SQL Server 2016 Read MoreHi friends, in next few blogs we will explore another new feature named Query Store which gets introduced in SQL Server 2016 CTP 2.0. This is a very useful feature for …
Introduction To Query Store In SQL Server 2016 – Part 1 Read MoreHi friends, today we will learn another new feature Live Query Statistics which gets introduced in SQL Server 2016. It’s a common scenario in our day-to-day life that queries takes longer …
Live Query Statistics In SQL Server 2016 CTP 2.0 Read MoreHi Friends, There may be the situations when you got an email about a query which was running fine till yesterday but today it is running very slow. First question which …
SQL Server 2016 CTP2 Query Data Store Read More