Q&A Categories

SQL-server-2000-interview-questions

Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform

Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform a full database backup. You decide to implement the following backup strategy : Full backup : 9am...

Write sql query for retrieving employee names from employee table who are having salary greater than

Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause? '

Why can a "group by" or "order by" clause be expensive to process?

Why can a "group by" or "order by" clause be expensive to process? '

Which is the best option used to move database from one server to another serve on same network?a) Import

Which is the best option used to move database from one server to another serve on same network?a) Import - Exportb)Backup-Restorec)Detach-AttachWhy? '

When do you get constraint violation? What are the types of constraints?

When do you get constraint violation? What are the types of constraints? '

What's the use of SQL Profiler?

What's the use of SQL Profiler? '

What is the use of Analyzing the tables?

What is the use of Analyzing the tables? '

What is the use of database index (apart from fast searching of records);What is use of composite key

What is the use of database index (apart from fast searching of records);What is use of composite key ? '

What is the query used to display all tables names in SQL Server (Query analyzer)?

What is the query used to display all tables names in SQL Server (Query analyzer)? '

What is the pivot operator in MS SQL Server2005? What is the use of it and how do we use it

What is the pivot operator in MS SQL Server2005? What is the use of it and how do we use it '

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]