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 10665
Difference between Cluster and Non-cluster index?32 124492
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1262
explain different types of jions with examples briefly?2 5850
Which databases are part of SQL server default installation? Explain the usage of each?2 4964
What all db objects can be found in MSDB database of a SQL Server instance?2 5162
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 8615
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 7251
How do you fine the performance tunning?2 5591
What are mdf,ndf,ldf files and how to see the data in those files?6 53971
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 14837
Differences between functions and stored procedures?8 9315
event classes in sql server2 4766
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.11 11768
Name the popular scripting language of DevOps?
What will you do if a portion of load bearing wall collapses under your supervision?
can any one tell me what kind of qns are asked in gail entrance test. i m apearing for the exam of accounts & finance. please let me know the ans on my id firstname.lastname@example.org
132/66kv sub-station procation ?
In Excell sheet how v-lookup can be used?
what happen if the parallel generator phase angle shift by 1 degree in manual mode
what is that one cub metre plaster in cemant and fine sand
_________________ are mathematical problems defined as a set of objects whose state must satisfy a number of constraints or limitations. a) Constraints Satisfaction Problems b) Uninformed Search Problems c) Local Search Problems d) Only a) and b)
Does malachite green have an inhibitory effect effect on bacterial growth?
what is roles and authorization??? During text determination procdure i dont want any one to change the text in transaction how to do it???
how to prepare the internal audit sheet ? explain me with example. (take example of LOGISTICS& SUPPLYCHAIN MANGEMENT COMPANY)
why hyper acute t waves appears in anterior leads of ECG during exercise
WHat is execution in manual testing and when will we start execution and what language we use in execution
Explain the Quantitative PCR for Intestinal Samples?