SQL Server Interview Questions
Questions Answers Views Company eMail

How can I enforce to use particular index?

Symphony,

1 3871

What is sorting and what is the difference between sorting and clustered indexes?

1 6058

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 3573




What is the use of SCOPE_IDENTITY() function?

2 3689

Can we rollback records deleted by a truncate statement?

United Healthcare, CarrizalSoft Technologies,

3 5433

How many types of indexes are there in SQL Server?

United Healthcare, CarrizalSoft Technologies,

6 7037

How many types of TRIGGERS are there in MS SQL Server?

TCS, United Healthcare, CarrizalSoft Technologies,

8 24411

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

United Healthcare,

1 3542




Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

United Healthcare,

1 3682

Can we execute a stored procedure inside a trigger?

BirlaSoft, United Healthcare, CarrizalSoft Technologies,

6 18091

What is the query optimization statistics?

1 1230

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 3922

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

Cognizant, TCS,

12 7330

How will u test the stroded procedures and functions? difference between SP and Triggers

TCS,

2 4400

explain the type of contraints

3 2582


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1301


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1254


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

848


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

925


How retrieve field names from the table in SQL through JAVA code?

687






Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1335


what is the sql equivaent of the dataset relation object ?

827


what is package and it uses and how can u call a package

864


Tell about MOM Tool(Microsoft Operator Manager)?

668


what is the Ticketing tool used in Wipro technologies at Bangalore...???

4963


You are doing log shipping due to some reasons it is failing. How you will proceed from there

807


How to trouble shoot if unable to connect SQL Server

755


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1601


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

864


ow to bring suspect mode datbase online from scratch

677