Skip to main content

Free Online Books Tutorials interview questions

Book Reviews
Interview Questions
Magazine Feeds
Online Books

Home » Interview Questions » Microsoft Technologies

SQL SERVER

Submitted by bookman on Wed, 10/28/2009 - 00:51

SQL SERVER

What is normalization? What are different type of normalization?
What is denormalization ?
What is a candidate key ?
What are different types of joins and whats the difference between them ?
What are indexes and What is the difference between clustered and nonclustered indexes?
How can you increase SQL performance ?
What is the use of OLAP ?
What's a measure in OLAP ?
What are dimensions in OLAP ?
What are levels in dimensions ?
What are fact tables and dimension tables in OLAP ? (Twist :- can you explain the star schema for OLAP ? )
What is DTS?
What is fillfactor ? (Twist :- When does plage split occurs ?)
What is RAID and how does it work ?
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
What are the problems that can occur if you do not implement locking properly in SQL SERVER ?
What are different transaction levels in SQL SERVER ?(Twist :- what are different types of locks in SQL SERVER ?)
What are different locks in SQL SERVER ?
Can we suggest locking hints to SQL SERVER ?
What is LOCK escalation?
What are the different ways of moving data/databases between servers and databases in SQL Server?
What are advantages of SQL 2000 over SQl 7.0 ?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What is difference between UNION and UNION ALL SQL syntax ?
How can you raise custom errors from stored procedure ?
What is ACID fundamental and what are transactions in SQL SERVER ?
What is DBCC?
What is purpose of Replication ?
What are different type of replication supported by SQL SERVER ?
What is BCP utility in SQL SERVER ?
What are different types of triggers in SQl SERVER 2000 ?
If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ?
What is SQl injection ?

‹ Remoting and Webservices up Threading ›

Login or register to post comments

Tags in Tags

Cardiovascular System Computer Science Database Books DERMATOLOGY DIGESTIVE DISEASES GENARAL MEDICINE General GENETICS GYNECOLOGY AND OBSTETRICS Hardware Books HIV AIDS INFECTIOUS DISEASES Java Books Languages Math Books Medical Books Microsoft Books Networking NEUROSCIENCE NUTRITION ONCOLOGY Operating Systems OPHTHALMOLOGY Other Books PEDIATRICS PHARMACOLOGY RADIOLOGY Software Engineering UROLOGY Web Services and web Development

Book navigation

Art and Photography

Biographies and Memoirs

Book Reviews

Business and Investing

Comics and Graphic Novels

Computer Science

Computers and Internet

Cooking and culinary

Crafts and Hobbies

Engineering

Entertainment

Health and Life

History

Home and Garden

Interview Questions

Literature and Fiction

Magazine Feeds

Mathematics Books

Medicine

Mystery and Thrillers

Nonfiction

Online Books

Parenting and Families

Politics

Reference

Science Books

Self-Help

Sports

Text Books

Travel

User login

Username: *

Password: *

Create new account
Request new password

Follow on Twitter

Follow us on Twitter

Navigation

Popular content
Recent posts
Feed aggregator

Latest Online books

microsoft press microsoft windows communication foundation step by step
Inside Windows Communication Foundation
Essential Windows Communication Foundation (WCF): For .NET Framework 3.5
Microsoft .NET Server Solutions for the Enterprise
Microsoft .NET for Programmers
Expert C# 2008 Business Objects
Exam 70-536 Microsoft .NET Framework 2.0 Application Development Foundation
Visual Diagnosis in Emergency and Critical Care Medicine
Manual of Emergency and Critical Care Ultrasound
sex positions complete guide
.NET Development Security Solutions
Professional Enterprise .NET
Microsoft Â® ADO.NET Step by Step (Step By Step (Microsoft))
How to Design Programs An Introduction to Computing and Programming
Algorithms and Complexity
Processor Architecture Laboratory
Writing device drivers in Linux: A brief tutorial
Linux Device Drivers Demystified
Writing a Linux device driver
Write a Linux Hardware Device Driver
Developing Linux Device Drivers using Libusb Programming Interface
Engineering Mathematics Frequently Asked Questions
Advanced engineering mathematics (7th edition)
MATHEMATICS FOR ELECTRICAL ENGINEERING AND COMPUTING
Mathematics for Computer Science
Advanced Calculus for Engineers
Mathematical Methods for Engineers II
ISMAILIA A NARRATIVE OF THE EXPEDITION TO CENTRAL AFRICA FOR THE SUPPRESSION OF THE SLAVE TRADE
In The Heart Of Africa By Sir Samuel W. Baker

(c)chilanti.com