Microsoft Technology

As we all aware, each and every new release of any software, we might expect changes in the release like, new features, update/upgrade on ...

Microsoft has released the first public preview of SQL Server 2016 Community Technology Preview 2. This version delivered with faster tran...

The database file extensions .mdf and .ldf are quite straightforward. Data files are organized in logical groups called f...

This history of SQL Server goes back to 1989 and this video covers each of the SQL Server releases up to the new SQL Server 2012

Denali is code name of SQL Server 2011. Here is the list of the code name of other versions of SQL Server. In 1988, Microsoft released ...

Books Online includes Setup and upgrade instructions. Information about new features and backward compatibility. Conceptual descriptions ...

In the previous post, we have seen, what is the difference between in “Truncate vs. Delete” ? Actually if we use truncate then we can’t r...

Truncate Delete Truncate Table <Table Name> Delete from <Table Name> Where <Conditio...

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension language for SQL and the Oracle ...

Today, one of my friend asked me, how to extract only Date from Datetime field. The following SQL Script helps to Extract only Date from D...

Problem: Today I tried to install SQL Server 2005 Developer edition in my system. During the installation, it throws the given error: --...

Structured Query Language (SQL) Transact-SQL (T-SQL) ANSI/ISO Standard DB Language SQL Server's Implementation of Language Simple SQL...

Functions (UDF) Stored Procedures (SP) Execute Functions thru SQL Statement It Can not be used in SQL Statements UDF run thru SQL SELECT ...

Composite Key is a primary key, combination of more than one column to maintain unique record. It is also known as Concatenated Key or Aggre...

It is a Database concept, it maintain the consistent relation between parent and child tables. When one table contains FK, it may not allow ...

You can use any of the following queries to retrieve list of all databases SELECT name FROM sys . databases SELECT name FROM sys . sys...

COALESCE NULLIF It Accepts N Parameters, It returns first Not Null Values For Example:- select coalesce ( NULL,2 ,NULL...

This is continuation of my previous post "What is Normalization" http://blog-mstechnology.blogspot.com/2010/06/what-is-normaliza...