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 15908What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
2335Which 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 12315What is Query Execution Plan? How does it help optimize or tune a database driven application?
2 10150how 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 254441. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
12 20336Post New Accenture SQL Server Interview Questions
What is the use of hql in hibernate?
What is application context in spring boot? : Spring Boot
What is the latest version of objective-c?
Compare ansible with chef.
What is the definition of cube in datawarehousing?
Can dll be a virus?
How do you define a variable of comp-1 and comp-2?
How do you update a dataset in ado.net?
explain autoboxing in java?
What do you mean by fair rent?
How Many Points include in Mat Calculation , what is the different bitween Gross Profit & Book Profits?
What is the DG power factor ? how?
Explain me what are the different types of system involved in embedded system?
Draw the E-R diagram for the database of a departmental store having the following relational database scheme Employees(e-no, address) Department(d-name) work-n(e-no, d-name) Looking-after(d-name, e-no) Item (item-no, brand-name, model-no, cost-price, sale-price)
Explain different http methods supported by restful web services?