An index in a database is pretty much similar to an index in a book which helps us to find a piece of data in an efficient manner. For example, let say you want to find customers from Auckland city. Now if we have an index on city column then SQL Server can find all … Continue reading Indexes in SQL Server
Category: SQL Server
Constraints – SQL Server
SQL Server constraints are very useful and help us to achieve data integrity. There are two types of constraints. Default ConstraintsTable Constraints Default Constraint It's a column level constraint. It helps to set a default value for a column if the value for that column is not provided while insertion of the row. It makes … Continue reading Constraints – SQL Server
NULL in T-SQL
In T-SQL NULL represents the missing value. This means if the value for a column is not provided while row insertion then the NULL marker will be used in that column(if the column is nullable). Note that NULL is not a value. Various components of T-SQL language treat NULL in a different way. NULL can … Continue reading NULL in T-SQL
Database Normalization
Database normalization is consist of a set of normalization rules derived from recognized good practices. It ensures that the database is structured to store data in a possible efficient way. It also helps to reduce the amount of duplicate data from the database. First Normal Form(1NF) A table is in 1NF if there is all … Continue reading Database Normalization
Tables in SQL Server
Tables in database are responsible to store data in form of a grid like structure. Tables consist of Columns and Rows. The columns are the variables for which we want to store values and these values for each column forms a row of data. Each row is a collection of values of columns. Table Types … Continue reading Tables in SQL Server
What is Database
Consider the database as a container which contains several type of objects such as tables, views and many more. These objects helps database to store data in an organised fashion. There are two types of databases available. System Databases: These databases are used by SQL Server itself to perform its functionality such as logging transactions.User … Continue reading What is Database
SQL Server Editions
There are many SQL Server editions that focus on specific requirements such as SQL Server BI stack. Let's take a quick look at the available versions. Express: This version of SQL Server is available for free. If you are starting with SQL Server it's a good option to start with. It has almost all the … Continue reading SQL Server Editions
What is SQL Server?
MS SQL Server is an Relational Database Management System (RDBMS). To explain what RDBMS is, we need to understand SQL, Server and then RDBMS. SQL: It stands for Structured Query Language. It's a language that enable us to interact with Databases like Microsoft SQL Server. Server: A server is a computer that accept requests and … Continue reading What is SQL Server?
SQLer 
You must be logged in to post a comment.