SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 8115

What are functions

3 6337

how to get the automatic backup of the database in the sql server

4 31624




What command do we use to rename a db?

5 8336

What are the four main query statements?

Wipro,

7 14790

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 12085

What is the STUFF function and how does it differ from the REPLACE function?

2 16983

What is SQL server agent?

HCL, SAP Labs,

2 6089




What is the purpose of UPDATE STATISTICS?

2 9896

What is de-normalization and when do you do it?

3 5414

Difference between Function and Stored Procedure?

C1 India,

9 14621

What is data integrity? Explain constraints?

Thinksoft,

1 21785

Explain some DBCC commands?

6 13910

What are tasks?

Wipro,

3 8151

What is the purpose of using COLLATE in a query?

1 16163


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How much memory that we are using in Logshipping Concept?

775


on line cluster can we make if yes tell me the procedure

910


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2839


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1642


how to use DTS package in 2000,2005,2008 in sql server

851






You are doing log shipping due to some reasons it is failing. How you will proceed from there

899


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?

860


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

748


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

379


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?

689


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1119


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

919


Tell about MOM Tool(Microsoft Operator Manager)?

761


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

727


application server is slow what may be the problem

1151