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

How to find the login name linked to a given user name?

951

How to rename databases in ms sql server?

1133

How to select all columns of all rows from a table with a select statement in ms sql server?

1051

How to create a dml trigger using create trigger statements?

981

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

962

What is the simplest way to create a new database in ms sql server?

964

How to connect ms access to sql servers through odbc?

973

How to add an address record into adventureworkslt?

939

How to select some specific rows from a table in ms sql server?

965

How to create a new schema in a database?

1077

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

922

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

1024

How to create a trigger for insert only?

990

How to delete a login name in ms sql server?

1010

What are the differences between decimal and float in ms sql server?

1134

Un-Answered Questions { SQL Server }

What is the difference between ddl and dml?

1009

What is SQL Azure Data sync?

119

What is index in an assignment?

897

How to defragment table indexes?

934

How can I create a report based on a query? : sql server management studio

978

Can we use trigger new in before insert?

871

How do I create an extended event in sql server?

913

What languages bi uses to achieve the goal?

960

Tell me in brief how sql server enhances scalability of the database system?

946

Can we do dml on views?

921

What is TDS(Tabular Data Stream) Gateway?

121

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

859

What is normalization of database?

1031

How do you improve the performance of a SQL Azure Database?

135

How to start and end transact-sql statements?

981

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