Interview question – Is Clustered index on column with duplicate values possible?
Through this article, we are going to discuss three important interview questions of SQL which are given below:- 1) Can we create clustered index on...
Question of the Month (July)
Question of the Month Suppose we have a table emp_plan which contains 4 columns “Empid” (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its...
Script to find complete months between two given dates
Complete months between two given dates Below script will help in finding the complete months within the 2 given dates. In the below script we...
Script to find the complete weeks within two given dates
Complete weeks within two given dates Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding...
Interview questions for database developer
Technical Round Database Interview Questions 1) What are the different types of Trace flags which we used for detecting the Deadlock? 2) What are the...
SQLTea – New SQL tutorial app in Google play store
SQLTea – Our new SQL Tutorial App on Google Play Store We are happy to announce our new SQL tutorial app SQLTea ( Native android...
Question of the Week -08/04/2014
Suppose we need to find out the name of all the months in a given year (Year will be given as an input parameter) where...
Answer – Objective Question (How many Null values in an unique constraint can be inserted in SQL Server)
Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server? Options:- a) 1 b) 2 c) More than...
Question of the Week – 11/1/2014
Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record set as shown in the below...
Answer – Objective Question (In which database temporary tables are created in SQL Server)
Question :- In which database temporary tables are created in SQL Server? 1) User database (where temporary table are defined) 2) Master database...