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 […]
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 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 […]
Categories
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 […]