Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

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 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.

Error Msg 1807, Level 16, State 3, Line 1 Resolution

Error Msg 1807, Level 16, State 3, Line 1 Resolution The resolution of this error in Sql server is quick and easy to fix:- Error Message:- Msg 1807, Level 16, State 3, Line 1 Could not obtain exclusive lock on database ‘model’. Retry the operation later. Msg 1802, Level 16, State 4, Line 1 CREATE

SQL Server Table Types

Table Types in SQL Server Besides the standard user-defined tables, SQL Server provides the following types of tables in a database:- Partitioned tables:- Partitioned tables are those tables whose data is horizontally divided into units which may be placed across more than one filegroup in a database. Partitioning makes huge tables or indexes more easy to

How to create user defined data type in Sql server

Data Type:- Objects that contain data have an associated data type that defines the kind of data the object can contain. Alias Data type:- Alias types based on the system data types in SQL Server. Alias types are used when several tables must store the same type of data in a column and you have