SQL Server Interview Questions
Questions Answers Views Company eMail

How can I enforce to use particular index?

Symphony,

1 3922

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

1 6117

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 3612




What is the use of SCOPE_IDENTITY() function?

2 3733

Can we rollback records deleted by a truncate statement?

United Healthcare, CarrizalSoft Technologies,

3 5502

How many types of indexes are there in SQL Server?

United Healthcare, CarrizalSoft Technologies,

6 7134

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

TCS, United Healthcare, CarrizalSoft Technologies,

8 24561

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

United Healthcare,

1 3593




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

United Healthcare,

1 3715

Can we execute a stored procedure inside a trigger?

BirlaSoft, United Healthcare, CarrizalSoft Technologies,

6 18276

What is the query optimization statistics?

1 1264

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 3976

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 7422

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

TCS,

2 4451

explain the type of contraints

3 2624


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what is isolation level at dead lock?

1019


If user is owning any SQL Objects, can we drop that user

858


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

725


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

883


last function used in MS Access to convert sql what function will use in sql

862






your distribution database is full what will u do

963


what are the critical issues you have resloved in your company

836


what is the sql equivaent of the dataset relation object ?

851


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

858


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

668


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

904


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1162


What is the difference between online clustering and Offline clustering?

1236


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1308


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

911