In this article we look at the states in which the SQL Server database can operate. There are seven states in which SQL Server can operate. All these states are denoted by differences in their performance, the results produced and the ease of...
Read more »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...
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...
Read more »