SQL Server Interview Questions
Questions Answers Views Company eMail

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

506

How to rename databases in ms sql server?

592

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

545

How to create a dml trigger using create trigger statements?

531

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

522

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

506

How to connect ms access to sql servers through odbc?

521

How to add an address record into adventureworkslt?

541

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

540

How to create a new schema in a database?

523

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

484

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

521

How to create a trigger for insert only?

569

How to delete a login name in ms sql server?

500

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

542


Un-Answered Questions { SQL Server }

What is sql sandbox in sql server?

591


What is page-level compression?

530


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

615


Define a cross join?

565


What are the new security features added in sql server 2012? : sql server security

504






What does set rowcount do?

489


Can you explain important index characteristics?

498


How to apply filtering criteria at group level with the having clause in ms sql server?

528


What is model database in sql server?

543


Define the one-to-one relationship while designing tables.

475


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1819


what is the difference between a primary key and a unique key? : Sql server database administration

505


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1549


query processing

1713


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

599