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 16013What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
2362Which 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 12415What is Query Execution Plan? How does it help optimize or tune a database driven application?
2 10236how 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 258011. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
12 20735Post New Accenture SQL Server Interview Questions
what are the no. of leaf nodes in a fibonacci tree ?
What are the server requirements to install yii 2.0 framework?
What are the objectives of internal audit?
What is different command used in command Prompt while using QTP?
what are the five benefits of using standard terminology in the measurement process?
How to use element in xslt? : xslt
What is the current status of DSS?
Explain the difference between swing and jsf.
Suppose you solve a problem and after that you are getting an almost same problem with high complexity (and lower complexity). How will you approach to the next problem.
what is the favicon.ico request that my site receives now and then?
Why is lazy loading?
What is a trigger? Give an example of how the repository is polled when a new commit is detected.
What are the benefits of sap gts?
How do we create tasks? What is the difference between task and change request?
What causes an ssd to fail?