Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

Can we drop user if user mapped to any logins

1 2030

How to transfer Logins from SQL Server 2000 to 2005

2 2112

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1082

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 1962

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

Liquid Hub,

6148

find the 3rd max salary

10 6427

How to Handle the exceptions in Sqlsrver 2005??

Value Labs, Wipro,

3 5151

What is best institute to Learn DotNET And SQL in chennai?

1256

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

TCS,

2 2830

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

984

how do u find least salary in a table

4 3754

Delete duplicate records from the table?(Table must have unique id)

TCS, Thomson Reuters,

7 8106

Why we are using the sql language?. What is the purpose of using this?

2 2310

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 2754

How do you connect 100 files as a flat file sources in one package of SSIS?

2 3278







Un-Answered Questions { SQL Server }

Can we write ddl in trigger?

108


What are different backups available in sql server?

147


How to recreate an existing index in ms sql server?

141


Can we call stored procedure in trigger?

119


What methods do you follow to protect from sql injection attack?

139






What are cursors stored procedures and triggers?

104


Do you know hot add cpu in sql server 2008?

140


What is a deadlock and what is a live lock?

136


What is the main difference between ‘between’ and ‘in’ condition operators?

120


What is save transaction and save point?

155


Why I am getting this error when renaming a database in ms sql server?

145


How do I find the query plan in sql server?

106


What is model database in sql server?

111


Can truncate be rolled back?

104


Do you know how to implement service broker?

115