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

What is the functional difference between @@ROWCOUNT and ROWCOUNT_BIG function?

@@RowCount vs RowCount_Big(): Functionally there is no difference between these two. Both returns the number of records returned by the last executed SQL statement. But the return value of @@ROWCOUNT is INT whereas the return type of ROWCOUNT_BIG () is BigInt.  

Read More