SQL Server Interview Questions
Questions Answers Views Company eMail

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 3702

Is index a datbase objects in sql server?

2 3865

What is Dedicated Administrator Connection in sql server 2005?

2 4619

why SQL server is more used to store database rather than Access

2 3531

How many types of Joins in SQL Server 2005?

CarrizalSoft Technologies, HCL,

9 9735

What is Inner Join?

2 4254

What is Outter Join?

1 3086

How many types of Outer Joins?What are they?

1 3118

What is Left Outer Join?

2 3636

What is Right Outer Join?

2 3462

What is Full Outer Join?

3 4921

What is Cross Join

3 5211

Diff. b/w Full Outer Join And Cross Join?

3 6455

What is Self Join?

4 5317

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

Logitech, Mphasis,

1 15443


Un-Answered Questions { SQL Server }

What happens when converting big values to numeric data types?

560


What are the different types of upgrades that can be performed in sql server?

684


What is a matrix in ssrs?

101


How to create an multi-statement table-valued function?

521


What are the difference between data mart and data warehouse? : sql server analysis services, ssas

492






What is an expensive query?

528


What does truncate do?

525


What is after dml trigger?

563


What are the types of containers in ssis?

594


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

1430


Where is trigger in sql server?

530


What is difference between getdate and sysdatetime in sql server 2008?

592


What do you understand by a view?

549


Do you know what is replace and stuff function in sql server?

463


Why should one not prefix user stored procedures with ‘sp_’?

582