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 12813
Difference between Cluster and Non-cluster index?32 131460
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1556
explain different types of jions with examples briefly?2 6832
Which databases are part of SQL server default installation? Explain the usage of each?2 5841
What all db objects can be found in MSDB database of a SQL Server instance?2 6104
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 9724
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 8164
How do you fine the performance tunning?2 6533
What are mdf,ndf,ldf files and how to see the data in those files?6 56352
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)?16 18019
Differences between functions and stored procedures?8 11169
event classes in sql server2 5750
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.12 14343
What is the main use of rotary phase converter ?
List major difference between protractor vs selenium?
What is a shell script in windows?
What purpose do Work Workers serve and what are some of their benefits?
Does node.js provide debugger?
Is angularjs difficult to learn?
Explain about the box cox transformation in regression models?
Can any one provide the inspection procedure of MIMIC for VFD panel? Details: If someone wants to have a mimic in the VFD panel what are inputs considered for the mimic(like on,off,trip) whether we are able to add speed variation in the mimic(if so how can we get) and what are the parameters to be checked in the MIMIC during inspection?
What is the purpose of using additional actions infotype (aai)?
What Is Encryption?
What is python literal?
how many clauses are there in iso? give me the clauses details?
Does zend framework support php 7?
what r the main attributes of test automation?