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 10514
Difference between Cluster and Non-cluster index?32 124072
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1238
explain different types of jions with examples briefly?2 5784
Which databases are part of SQL server default installation? Explain the usage of each?2 4898
What all db objects can be found in MSDB database of a SQL Server instance?2 5101
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 8556
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 7205
How do you fine the performance tunning?2 5525
What are mdf,ndf,ldf files and how to see the data in those files?6 53807
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 14675
Differences between functions and stored procedures?8 9216
event classes in sql server2 4699
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.11 11612
Who all falls under the Perview of Excise Duty, we mean who has to pay the Excise Duty, eg: does all mfrs have to pay ED or who has high turnover they should only pay ED, if yes that what is the Turnover limit?
How do we calculate the Out put voltage of generator, after the excitation is being given?
Why every time that I hit the microphone or when I speak louder the amplifier is switched of?
What?s new in the LogicLock? feature?
There are prime factors of two numbers a and b , write a program using this prime factors whether a is divisible by b?
What are the items to inspect after cylinder liner is pulled out
i want o/p 011242110 in c# code.
Any one can help me abot any tickets in suport project in GL, AR, AP Please send me any issues on that with answer
A problem in a search space Is defined by, a) Initial state b) Goal test c) Intermediate states d) All of the above
What if high voltage side circuit breaker of a ehv transformer instead of lvcb? Kindly elaborate.
How to connect the remote desktop using QTP 9.2 explain the method or procedure?
How to estimate the shuttering material requirement for a slab and beam and shear wall..? Please send thumbrule to estimate material required ( Plywood, Ms plates, runners, acrospans, jacks)
Give five examples each of plants that have lateral and that have fiberous roots?
plz send me paper of mppgcl 2008 or experience posted by any candidate
What is the percentage i get to work in MICROSOFT