SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What objects does the fn_my_permissions function reports on? : sql server security

1028

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1088

Differentiate between a having clause and a where clause.

961

Explain the stored procedure?

1041

What functions can a view be used to performed?

1055

Describe the functionalities that views support.

1093

Explain primary key?

951

What are partitioned views and distributed partitioned views?

1016

What are the basic functions for master, msdb, model, tempdb databases?

1033

Explain the concept of recursive stored procedure.

934

What do you mean by an execution plan? Why is it used? How would you view it?

923

What is dbcc? Give few examples.

1021

What is row_number function?

994

What do you mean by an execution plan?

1108

What is a trace frag? Where do we use it?

1096

Un-Answered Questions { SQL Server }

How to define the name and server for a new dsn?

1101

How can you check the level of fragmentation on a table?

1039

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2358

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

2012

Mention what are the different types of ssrs reports?

150

Explain Normalization and DE normalization

1100

Can you name some of the dml commands in sql?

1021

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1040

Does table partitioning improve performance?

957

How will you make an attribute not process? : sql server analysis services, ssas

1077

application server is slow what may be the problem

2213

How to modify existing triggers using "alter trigger"?

1009

How to disable stored procedure sql server?

1598

How to truncate the log in sql server 2012? : sql server database administration

1277

What do you mean by sql server agent?

983

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