In this article we introduce you to the concept of Indexes in Ms SQL Server
In SQL Server, indexes are used to make the task of data access comparatively faster. With the help of indexes, we are able to glance at the entire database file in a single scroll. Like in every book we see an index at the beginning; it makes the presentation of our data more systematic and organized.
Indexes are mostly in the form of tables. They have entries of topics and sub-topics. It works in a...
Read more »
In this article we look at why Ms SQL Server is a better choice than the open source MySQL for many companies.
MS SQL and MySQL are two different database solutions, with very distinctive origins. While the MS SQL server is a proprietary solution from Microsoft, the MySQL database is an open source solution which has found quite a fan following amongst web developers. However from a pure play enterprise database solution, the Ms SQL Server application is considered way superior to MySQL....
Read more »
In this article we look at how the Ms SQL Server database solution has evolved the years
Microsoft launched its version of SQL server in 1989 as Sybase SQL server by collaborating with Sybase and Ashton -Tate; it was a variant of the older Sybase SQL server for IBM. With its own version of SQL server Microsoft forayed into enterprise- level database market, with rivals like Oracle, IBM and Sybase. Starting from 1989 till now, Microsoft has launched a dozen editions of the SQL server with SQL...
Read more »