1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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 10320

How to get max 100 values from sql server

 7 11349

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

CarrizalSoft Technologies, DELL, SoftSol,

7 9679

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 4261

To find second largest salary in Employee table

CSS,

17 16243

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

 1431

How can we Use Linked Server? Uses of Linked server

IBM,

1 4823

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 3611

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

IBM,

2 7796

What is Trace flag?

Wipro,

1 3842

Differences between Standby Vs No recovery?

Wipro,

2 15272

what is lazy writer?

Wipro,

1 8026

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

Wipro,

1 6275

What is the use of Port no?

Wipro,

1 3902

Can you explain some of the DTS problems?

UBS, Wipro,

1 4115

Un-Answered Questions { SQL Server }

Explain about Views?

597

What is the function of inner join?

546

Explain cursor as data base object?

566

How to set database to be single_user in ms sql server?

553

How many types of built in functions are there in sql server 2012?

483




Can foreign key be duplicate?

623

What is a partitioned view?

557

How can you hide the sql server instances?

506

What happens if an integer is too big for int date type?

567

How to check status of stored procedure in sql server?

435

What command do we use to rename a database?

607

What is a covering index?

521

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

563

What is difference between index seek vs. Index scan?

612

How does using a separate hard drive for several database objects improves performance right away?

524

For More Un-Answered { SQL Server } Questions Click Here