1st Milestone – 100th post from SQLVersity
Posted in Uncategorized by Chandrasekhar Raparthi On December 31, 2014

@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
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 —————————————————
What is the difference between Deterministic and Non deterministic functions?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On December 28, 2014

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
What is Index Scan and Index Seek?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On December 27, 2014

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
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%’
What are the types of database recovery models available in SQL Server?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On December 25, 2014

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
What is meant by CRUD operations?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On December 24, 2014

CRUD: C – Create — INSERT Operation R – Read — SELECT Operation U – Update — UPDATE Operation D – Delete — DELETE Operation Happy Reading
Can you list some Maximum capacity specifications of SQL Server?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On December 24, 2014

Below are the Maximum capacity specifications according to SQL Server 2014 For more info: Click here Happy Reading
What are the types of Triggers available in SQL Server?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On December 22, 2014

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
What is the default TCP/IP port number does SQL Server run on?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On December 21, 2014

SQL Server runs on 1433 port number. Happy Reading