SQL Server interview questions – page 6

Difference between Triggers and Stored Procedure

Where are connection strings stored?

What is transaction ? Give me one example.

Usage of stored procedure and sql syntax's.

Do you know the query for auto generating the next number in a series ?

User management and secirity and package upgrading. kernal upgrading and more ...

Difference between self join and inner join ? Indexes where you can use it ? Write a Pivot query in sql ?

How to create dynamic sql query in sql server ?

What are different types of queries and joins in SQL. Explain with the example

Sql queries on Join, C, Data Structures (Mostly linked list, stack, queues), Basics of SDLC and Testing.

What is derived table?

How to migrate SSRS reports from one server to another?

How to get the last updated identity field value, not necessarily the max value?

Write a query to find out duplicate rows in a table?

How to get max of record without using MAX keyword in sql?

DBMS concepts, SQL queries, C programming techniques, basic electronic concepts.

How to delete duplicate records in sql server?

What are the advantages of referential integrity?

What are different normalization forms?

What is cte?

What are different types of Collation Sensitivity?

How will you copy the structure of a table without copying the data?

What is the difference between SSAS 2000 and SSAS 2005?

What is the difference between Oracle and SQL Server?

What is the difference between xml Index and Basic Index

What do you know about low level architecture?

What are the differences between Oracle and SQL Server?

How does -818 sql error occur? Why does it happen and what can be done to overcome this error code?

How does SQL Server session state works?

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of SP nesting is possible?