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 11267
Difference between Cluster and Non-cluster index?32 126401
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1349
explain different types of jions with examples briefly?2 6119
Which databases are part of SQL server default installation? Explain the usage of each?2 5164
What all db objects can be found in MSDB database of a SQL Server instance?2 5358
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 8857
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 7471
How do you fine the performance tunning?2 5845
What are mdf,ndf,ldf files and how to see the data in those files?6 54707
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 15675
Differences between functions and stored procedures?8 9720
event classes in sql server2 5043
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.11 12506
Explain the difference between drop and truncate commands in sql?
What are decorators in angular?
I want to put this query to SENIOR & EXPERIENCED ELECTRICAL ENGINEERS. 1)I want to know about the control circuit diagrams for control panels. I found it difficult to understand. Is there ant booklet through which we can learn the circuit diagrams? 2)I want to learn about conduiting, laying cables, preparing cable schedules and various techniques which is the part of building infrastucture(construction field). I don't have any experience in this area. I have experience in control panels only. that's why i am not getting any opening in building infrastucture (construction field).Can I get the job in this field as Trainee Engineer? How to enter this field? I need job in PUNE
Are Utility Services Affected?
What is meant by pulse triggered devices?
Is there possible to Test Transformer for Overfluxing Capability. Or is there any firm who does Overfluxing Test on Transformer?
Mention some of the most commonly used directives in angularjs application?
What is the difference between multimeter
What is replication factor?
What Are The Different Types Of Loans Offered By Commercial Banks?
What is the main difference between soap and rest web services?
How do you set up a table of contents in word 2013?
rents part of its building for a monthly fee of $1,250. The rent for the month just past has not been received.
What do you mean by caching in teradata?
How to connect to a sql server using odbc_connect()?