At SQL Server Geeks 2015 - Pre Conference Session - Benjamin Nevarez

Attended SQL Server Geeks Annual Summit 2015 on last Wednesday (26/8) at Bangalore, India. Due to few urgent responsibilities at...

Query cost and Query Execution time - Difference

This post is my 100th post 🙂 Was inactive in blogging for few years in between. Now back in full flow....

Hekaton Part 4: Simple Performance comparison - In Memory vs Disk table

Continuing on the Hekaton Series, this post will attempt a very basic performance comparison of In Memory and disk based...

Hekaton Part 3: Table Creation and Parameters

Part of a Series on "Hekaton". Refer below for previous posts

Introduction to Hekaton - Part 1Creating a Hekaton Database - Part 2
Having...

Hekaton - Creating a Database :- 2

With a Gentle intro done on Hekaton - In Memory tables, let us continue exploring further. Today, we will quickly create a database...

Hekaton - In Memory OLTP - Getting Started / FAQ :- 1

SQL Server 2014 introduced a major feature called "In Memory - Hekaton" Tables, in which even the fundamental concepts of SQL...

Detach and Attach All User Databases

Sometimes you are in a scenario where you need to transfer a large number of databases from one server to...

DDL Auditing - Article on SQL Server Central

My article on SQL Server Auditing has been published on www.SQLServerCentral.Com. Article discusses how default trace can be used effectively...

How to Size the SQL Server Memory & Why is it important?

The following blog post has 2 objectives.

 1) How to size the memory correctly ( or atleast being close to correctly )
 2)...

Xp_readerrorlog in SQL Server 2012

I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog...