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 […]
A ton of MS E-books to download
I am not sure how many other users have visited this blog but it’s been one of my go to places when I wanted to read up on […]
Renaming all columns in a table quickly
Recently imported a table where the column names where quoted using double quotes which then became the table names , So a column name would be “Airline” instead […]
The hazards of data types when deleting data
Recently in one of the forums a question was posted where the developer had run a delete statement similar to the one below delete from #tmp where data […]
Does Partitioning Improve Performance?
Partitioning is a great feature for improving the way we manage our data. However we can also improve performance of select statements from the table as well. This […]
Measuring Uptime in SQL Server – Why nines don’t work
A key part of every DBAs jobs is maintaining uptime. A DBAs capability is measured by the amount of Uptime he is able to ensure on servers he […]
LnT Infotech SQL Server Training
Just finished a virtual training for LnT InfoTech in EPIP industrial Area. Looking forward to the next training with Well Fargo