In this article we take a close look at the structure of files and filegroups present in SQL Server
SQL Server makes use of binary files and not textual files and it consists of two types of files Log files and Data files; these can further be grouped into Filegroups for the purpose of allocation and administration. Data files understandably consist of data and objects like tables, indexes, views etc. Log files on the other hand keep a record of all transactions and also stores information...
Read more »
In this article, we will discuss why it's so important for all users to upgrade SQL Server 2005 to new editions.
Since its first launch, Redmond based software giant Microsoft has released multiple editions of its SQL Server database application in a periodic manner. But there are still users who are hanging on to the more than a decade old edition of SQL Server; the 2005 edition. The extended support for the 2005 edition ended in early 2016; therefore it was imperative for all users to...
Read more »
In this article we give a close look at the jazzed up In Memory OLTP feature present in SQL Server 2016
The In-Memory OLTP feature, introduced by SQL Server in its 2014 addition has been upgraded in the SQL Server 2016 edition. The size limitation in the 2014 edition for memory-optimized tables has now been done away with, meaning that the tables can now be as big as the user wants them to be and can go on till there is enough memory available, this was not possible in earlier editions. The...
Read more »