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 16129What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
2411Which 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 12567What is Query Execution Plan? How does it help optimize or tune a database driven application?
2 10354how 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 262461. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
12 21189Post New Accenture SQL Server Interview Questions
What is the difference between numeric and autonumber?
What are data modelling techniques?
How will you define e-commerce?
what is the PID controller?
We are Interior Decorators in Chennai,Tamilnadu. I would like to know the vat applicable for us 14.5% or 5%. We supply the material and do the works at the sites itself.
What are control room in automation anywhere?
Is laravel support caching? Explain
What are special characters in unix?
Distinguish between a seismograph and a seismogram?
How can I insert or delete a line (or record) in the middle of a file?
What are the tools that help to find bugs or perform the static analysis?
How do you make a powerpoint presentation on a laptop?
What is work centre category?
Is it safe to delete windows installer patch files?
Describe what a thread-local variable is in java?