Creating Memory-Optimized Database And Table

Hello All, I hope you read my previous blog In-Memory OLTP . This is my second blog in In-Memory OLTP Series. As of now, you should have known what Sql Server In-Memory OLTP is. Giving you a quick recap, this new feature of Sql Server allows you to store your data […]

Read more

SQL Server In-Memory OLTP

In my next few blogs, I would attempt to explain you about SQL Server’s In-Memory OLTP (Hekaton). Let me know how am I doing with it by giving your valuable comments. In-Memory OLTP is the new feature introduced with the latest version of Sql Server i.e SQL Server  2014. What is […]

Read more

View row count of multiple tables with single query

I got myself in the situation, where I needed to find the row count of multiple large tables. Executing count(Fieldname) for these large tables was not a right choice, so I opted to use sysindexes. Then, I came up with the idea of joining sysindexes and sysobjects. Here is the […]

Read more

Backup all SQL Server database at once

Problem Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks.  One of these tasks may be the need to backup all databases on your server.   This is not a big deal if you have […]

Read more