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

‘Order by’ is not allowed in a view how can you sort information from a view?

1091

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

950

How do you use a subquery to find records that exist in one table and do not exist in another?

1051

Can a cursor be updated? If yes, how you can protect which columns are updated?

1117

What is xdr?

996

How can you set the threshold at which sql server will generate keysets asynchronously?

998

Which table keeps information about stored procedures?

948

How is a full-text index updated?

961

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

954

How can you find out how many rows returned in a cursor?

1037

What does the automatic recovery do?

1 2490

What is the difference between writing data to mirrored drives versus raid5 drives

942

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1033

Give an example of why you would want to denormalize a database

982

How many full-text indexes can a table have?

982

Un-Answered Questions { SQL Server }

What is sql language?

1156

Does sql server 2016 have ssms?

969

Can I delete event logs?

931

What is the name of the Database which IBM mainframe uses?

989

Can you leave a union at any time?

1068

Explain the collation?

1117

How to modify an existing stored procedure in ms sql server?

1091

What is the default server name for sql server?

1182

Explain about remote stored procedure?

1016

What is the downside of using udf?

1116

What are four major operators that can be used to combine conditions on a where clause?

1058

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1114

how to take backup bcp out for a column in table in sql server?

2110

What is service broker? : sql server database administration

1001

Explain what is lock escalation?

1074

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