1st Milestone – 100th post from SQLVersity

@Dear SQLVersitians, On the occasion of publishing my 100th post in http://sqlversity.com/ I heart fully express my happiness to all my friends, colleagues also most importantly all readers of SQLVersity, who made my site successful and inspired me to write lots and lots of

Read More

Itz Puzzle tym

Try to guess the Answers for the below Queries and also check with the key which i have provided. Click here to see the answers from the below. ————————————————— — I – Silly SELECTs. But Funny results. ————————————————— USE [AdventureWorks2008R2] GO —————————————————

Read More

What is the difference between Deterministic and Non deterministic functions?

Deterministic vs Non deterministic functions:  A function is deterministic, when it returns the same result every time for the same set of argument values.  For example adding two specific numbers returns the same output  at anytime. Ex: Sum(), Avg(), Floor(), Ceil(), Round()….etc

Read More

What is Index Scan and Index Seek?

Any technical guy in this world can write code logic for developing a software. But finally performance matters for any software. We are aware that Indexes in database plays a vital role to fetch the records quickly which in turn gives good

Read More

What is Soundex() function?

Soundex(): In real time we frequently use search criteria to search for Employee names from Employee table. Below are the few examples. —————————————————————— SELECT * FROM [HumanResources].[Employee] WHERE [JobTitle] = ‘Chief Executive Officer’ —————————————————————— SELECT * FROM [HumanResources].[Employee] WHERE [JobTitle] LIKE ‘%Design%’

Read More

What are the types of database recovery models available in SQL Server?

Recovery model: We all are aware that Transaction log is the heart of any database and needs to be taken care of it every time.  But unfortunately if we lose transaction log, that will be the end of the story 😉 So

Read More

What is meant by CRUD operations?

CRUD: C – Create — INSERT Operation R – Read — SELECT Operation U – Update — UPDATE Operation D – Delete — DELETE Operation Happy Reading

Read More

Can you list some Maximum capacity specifications of SQL Server?

Below are the Maximum capacity specifications according to SQL Server 2014 For more info: Click here  Happy Reading

Read More

What are the types of Triggers available in SQL Server?

Types of Triggers: DDL Triggers DML Triggers After Triggers After Insert Triggers After Update Triggers After Delete Triggers Instead of Triggers Instead of Insert Triggers Instead of Update Triggers Instead of Delete Triggers CLR Triggers Happy Reading

Read More

What is the default TCP/IP port number does SQL Server run on?

SQL Server runs on 1433 port number. Happy Reading 

Read More