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 9269
Difference between Cluster and Non-cluster index?32 121013
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1069
explain different types of jions with examples briefly?2 5216
Which databases are part of SQL server default installation? Explain the usage of each?2 4388
What all db objects can be found in MSDB database of a SQL Server instance?2 4680
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 8061
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 6686
How do you fine the performance tunning?2 5082
What are mdf,ndf,ldf files and how to see the data in those files?6 52400
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 13505
Differences between functions and stored procedures?8 8607
event classes in sql server2 4131
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.11 10565
How many un-protected FlexiHopper links can be operated with one FIU19(E) with Flexbus plug-in unit?
How can you save the sea from oil and sound polution?
is a pvt ltd. comp. can give advance against salary to his director.
what is procedure of measuring operating length of mechanical seal .(in case of centrifugal pump)?
What is spooling and buffering?
WHY DO VOLTAGE TRANSFORMERS FAIL DURING EARTH FAULT IN THE DELTA CONNECTED 6.6KV ELECTRICAL SYSTEM
What kind of deliverables you have on a day to day basis?
What is Key escrow?
Hi, Please can one tell me how to test the usability testing, which method has to be used, how to write the report? Thanks Deepa
What is the default block size in hdfs?
What the various ways to tune a teradata query
Difference between MD04 and MD05.
Different Bitwin ADSL & DSL ROUTER? How To Configure
HOW FORCE ACTING ON SPUR AND HELICAL GEAR
why you want to be a quality analysts