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 11020
Difference between Cluster and Non-cluster index?32 125479
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1309
explain different types of jions with examples briefly?2 6006
Which databases are part of SQL server default installation? Explain the usage of each?2 5091
What all db objects can be found in MSDB database of a SQL Server instance?2 5271
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 8743
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 7363
How do you fine the performance tunning?2 5749
What are mdf,ndf,ldf files and how to see the data in those files?6 54334
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 15298
Differences between functions and stored procedures?8 9532
event classes in sql server2 4923
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.11 12167
What is the difference between a site definition and a site template?
What is the white precipitate produced at the end of point?
What is the difference in accessing db between sql server vs sql azure?
what is purpose of maintaining common distribution channels and common division??????
Can we declare an interface as final?
How to write the program on full-duplex communication on bidirectional?
What is the difference between a client & customer in a SAP BI Project?? Is it same?
why is not useing in boiler skin thermocople
What is the purpose of void class?
What is the unsecured configurations and how can we access from plug-in code?
List the forecast models involved.
What would you use to view contents of a large file? How to copy/remove file? How to look for help on a Linux?
Explain what are the steps for creating basic or vertical forms?
What is the use of infocube in the bw system?
what is the primary difference between the xml.sendandload method and the xml.load method? : Adobe flash