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 insert and update data into a table with "insert" and "update" statements?

1042

How to change the data type of an existing column with "alter table" statements in ms sql server?

1038

What happens when converting big values to numeric data types?

1226

Can we delete data from a view?

978

How to update multiple rows with one update statement in ms sql server?

1262

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

1026

Can binary strings be used in arithmetical operations?

985

What is a transact-sql statement?

1129

How to create stored procedures with parameters in ms sql server?

1155

How to specify the collation for a character data type in ms sql server?

1079

Does index slows down insert statements?

1047

What are the basic features of a trigger in ms sql server?

1265

Where is my database stored on the hard disk in ms sql server?

1110

What is a database in ms sql server?

1105

What are commonly used mssql functions in php?

1142

Un-Answered Questions { SQL Server }

Explain nested join?

1031

What are trace flags?

1084

How will you go about resolving deadlocks?

1033

What is the difference between ddl and dml?

1097

What is a db view?

948

What is importing utility?

1038

Tell me extended events in sql server 2008?

1053

What is scalar user-defined function?

1189

Explain the difference between clustered and non-clustered index?

968

Explain about protocol layer present in SQL server?

1292

What do you mean by cardinality?

940

Explain in details security in SQL azure?

123

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1157

What information is maintained within the msdb database?

1018

Is it possible to have clustered index on separate drive from original table location?

1014

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