What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?2 10355
Difference between Cluster and Non-cluster index?32 123589
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1214
explain different types of jions with examples briefly?2 5718
Which databases are part of SQL server default installation? Explain the usage of each?2 4826
What all db objects can be found in MSDB database of a SQL Server instance?2 5022
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?3 8490
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 7139
How do you fine the performance tunning?2 5472
What are mdf,ndf,ldf files and how to see the data in those files?6 53596
how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?15 14501
Differences between functions and stored procedures?8 9129
event classes in sql server2 4633
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.11 11402
What is a liquid flooding in refrigeration system?
How to Design a Good Newsletter?
In any Hyderabd institute you can find these word commomly used by faculties ... Yes or no / Right or wrong so funny...
how is market for testing in banglore,chennai,pune,delhi?
what is the pre charge circuit,what will be work which function it will be use plz tell me
Who is to paid income tax and what is the procedure of filling income tax return?
Where does Big Data come from?
how to change login screen in xtuple ERP ?????
Have you prepared traceability matrix and how to prepare it?
what is transient stability analysis means?
I NEED 2006&2007 RAILWAY RECRUITMENT BOARD,JUNIOR ENGINEER (SIGNAL) Q&ANSWERS,PLEASE SEND TO: email@example.com
One of the Institutes contains 5 student groups. Every group contains 4 students. Institute wants to store student group’s details in array. Group should contain group member’s details (name and registration number and age), project name, and mark of the group.
What is ActiveX Control?
How to get the "old" (version 6) Visual C++ look in the new Visual Studio .NET environment?