1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

 621

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

 575

What is replication with database mirroring? : sql server database administration

 519

What is your recommendation for a query running very slow? : sql server database administration

 581

What is stored in the mssqlsystemresource database? : sql server database administration

 577

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

 611

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

 589

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

 486

What are system databases into sql server (2005/2008) : sql server database administration

 557

What are truncate options available in sql server? : sql server database administration

 571

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

 577

What is database isolation in sql server? : sql server database administration

 557

What are the dmvs? : sql server database administration

 586

What is policy based management (pbm)? : sql server database administration

 574

Where can you find the error log information? : sql server database administration

 555

Un-Answered Questions { SQL Server }

Define cursor locking

540

What is database replication?

565

Where do we use trace frag?

558

What is the minimum recommended amount of ram for sql server 2012 enterprise?

491

How to get the definition of a user defined function back?

554




What is the exact numeric data type in sql?

537

Define clusters?

639

What is Service Broker in sql server 2012?

612

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

501

What are the mathematical functions supported by sql server 2005?

532

Differentiate between ms sql server reporting services vs crystal reports?

473

Why do we need different type of parameter?

539

Can a synonym name of a table be used instead of a table name in a select statement?

563

What are the requirements to use odbc connections in php scripts?

583

What is sharding?

88

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