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 are different types of backups available in sql server? : Sql server database administration

986

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1122

what happens on checkpoint? : Sql server database administration

1158

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

1041

explain the storage models of olap? : Sql server database administration

1018

how to create a scrollable cursor with the scroll option? : Sql server database administration

1148

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

952

what is create database syntax? : Sql server database administration

1170

what type of index will get created after executing the above statement? : Sql server database administration

1028

what authentication modes does sql server support? : Sql server database administration

1191

how many layers of tcp/ip protocol combined of? : Sql server database administration

1054

what is dbcc? : Sql server database administration

1087

how to define testing of network layers? : Sql server database administration

1026

is there a column to which a default can't be bound? : Sql server database administration

1055

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1111

Un-Answered Questions { SQL Server }

Differentiate between SQL and ORACLE joins and write their syntax.

1078

What are the difference between clustered and a non-clustered index?

1094

What is the maximum size of sql server database?

1066

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1138

What is set nocount on?

997

How to create a new schema in a database?

1214

How to enter unicode character string literals in ms sql server?

1124

What is the difference between deallocate cursor and close cursor?

1338

Can you explain what are various ways to enhance the ssrs report?

1070

What happens if strings are casted into wrong code pages in ms sql server?

1169

What is use of except clause? How does it differ from not in clause?

1071

What is the use of set nocount on/off statement?

1146

What is an expression in ms sql server?

1144

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2992

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1067

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