What are Indexes and it’s types

Index:-An index is a collection of pages associated with a table used to improve the performance.Indexes are used to point to the location of a row on data page instead of  look through all data pages in a table. Planning useful indexes is one of the most important factor of improving query performance. It requires

How Data Is Accesses In Sql Server

SQL Server first determines existence of a  index. Then query optimizer—the component responsible for generating the optimal execution plan for that query— then it determines is scanning a table or using the index is more efficient for accessing data. SQL Server accesses data in one of two ways: By scanning all the data pages in

How to create partition table in Sql server

Partition Table in Sql Server In this tutorial i will let you know that how to create a partition table in sql server.Partitioning makes large tables or indexes more manageable, because partitioning enables you to manage and access subsets of data quickly and efficiently. Partitioned tables and indexes are only supported in the SQL Server

How to create a partition scheme in Sql server

A partition scheme in database is that maps the partitions of a partitioned table or index to filegroups. The number and domain of the partitions of a partitioned table or index are determined in a partition function. A partition function must first be created in a CREATE PARTITION FUNCTION statement before partition scheme. Permission can

How to define custom width for gridview columns.

In this tutorial you will learn how to define custom width for asp.net gridview coloumn width. Your asp.net grid view look like this in code view without specifying any custom coloumns or their width. <asp:GridView ID=”GridView1″ runat=”server”> </asp:GridView> But after the custom coloumn and their width this look like as shown below. <asp:GridView ID=”GridView1″ runat=”server”>

How to create a Partition Function in Sql server

A partition function in database is what that maps the rows of a table or index into partitions based on values of a specified column. Scope of a partition function is limited to database that it was created in. Within the database, partition functions reside in separate namespace from other functions. Any rows whose partitioning

How to run Sql server agent job from a Batch file

In this tutorial you will learn how to run a sql server agent job from a batch file.For this you don’t need to know any coding. Create a job in Sql server to take backup of any database. Give it name whatever you want and save the job. Save the below query as batch file.