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 15904What 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 12312What is Query Execution Plan? How does it help optimize or tune a database driven application?
2 10149how 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 254321. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
12 20330Post New Accenture SQL Server Interview Questions
what will be the min curvature ratio for Round Bar dia. 1” size in material grade AISI 4330, Yield strength 115KSI Tensile 140KSI?
What is the main function of iis?
What is polyfill?
Explain forecasting & replenishment process under supply chain management?
Where do we use cross and standard cable?
Why is auto-regression used in forecasting used on cognos platform?
What is Drupal main menu?
People are motivated by the need for achievement, power, or affiliation according to which theory? A. Expectancy theory B. Achievement theory C. Contingency theory D. Theory X
What is the mix propotion of M10,M15,M20,M25,M30,M40,M50.M60 cement content,aggrigate,sand and water ratio.
what is threaded joints ,where present usage ?
How can I make justification between using concrete grade c35 compare c37?
Which function in C can be used to append a string to another string?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is admin password?
Whats the difference between MD 50 and RD 50