SQL Server Interview Questions
Questions Answers Views Company eMail

Can we drop user if user mapped to any logins

1 1685

How to transfer Logins from SQL Server 2000 to 2005

2 1637

Issues related in upgrading SQL Server 2000 to 2005 / 2008

792




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

1 1636

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

Liquid Hub,

5085

find the 3rd max salary

10 5171

How to Handle the exceptions in Sqlsrver 2005??

Wipro, Value Labs,

3 4426

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

980




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

TCS,

2 2356

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.

715

how do u find least salary in a table

4 3122

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

TCS, Thomson Reuters,

7 7120

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

2 1923

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

2 2206

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

2 2742


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

role of sql sever 2005 in database rather than any other database

894


What are the dis_advantages of stored procedures, triggers, indexes?

982


application server is slow what may be the problem

1095


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

874


wat wil hapn if we give the both read and deny read permission to user?

954






1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

795


How much memory that we are using in Logshipping Concept?

725


Issues related in upgrading SQL Server 2000 to 2005 / 2008

792


New concepts of sql server 2005 use in your project.

1246


where the connection string store in the database

832


Delete duplicate rows without using rowid.

209


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

883


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1275


What is Lock table in SQL?

286


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

629