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

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 8561

How to get max 100 values from sql server

7 9491

What are the factors you will check for the performane optimization for a database query?

CarrizalSoft Technologies, DELL, SoftSol,

7 7508

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 3417

To find second largest salary in Employee table

CSS,

17 11982

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

966

How can we Use Linked Server? Uses of Linked server

IBM,

1 4180

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 2927

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

IBM,

2 6880

What is Trace flag?

Wipro,

1 3042

Differences between Standby Vs No recovery?

Wipro,

2 13278

what is lazy writer?

Wipro,

1 7137

Can we move Resource database from one path to another? If yes,How can we?

Wipro,

1 5573

What is the use of Port no?

Wipro,

1 3146

Can you explain some of the DTS problems?

UBS, Wipro,

1 3408







Un-Answered Questions { SQL Server }

Explain about local stored procedure?

114


What is right outer join in sql server joins?

190


How to create a view on an existing table in ms sql server?

147


Is BCNF better than 2NF & 3NF? Why?

155


How to check if stored procedure is running in sql server?

103






What are the advantages of using stored procedures?

149


What is the definition for sql server 2000?

149


Is truncate a dml command?

104


What is the purpose of sql profiler in sql server?

130


What is Extended user-defined?

134


What is normalization 1nf 2nf 3nf?

106


What is the use of commit?

106


What are the tables in sql?

170


What functions can a view be used to performed?

138


What is difference between group by and having?

105