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 16042What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
2373Which 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 12448What is Query Execution Plan? How does it help optimize or tune a database driven application?
2 10267how 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 258931. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
12 20818Post New Accenture SQL Server Interview Questions
What do you know about gail?
What is definition and declaration?
What is government doing for endangered indian species of medicinal plants used in various formulations of ayurveda, unani, siddha and homoeopathy?
What are maps ?
what happens if you inherit multiple interfaces and they have conflicting method names?
Where define directive used?
How do I freeze a table in word?
What does ng transclude do?
Is internet explorer going to be discontinued?
Explain about adobe photoshop’s work area.
HI Everybody, I am using QTP 9.2, I have a problem and hope everybody help me solve it. Now I need to use mouse wheel event to zoom in or zoom out in web client, but QTP can't catch this event. I look forward helping of everybody. Thank you very much.
How to prove a new block cipher, is resistant against differential cryptanalysis attack
What does the mvc pattern define with 3 logical layers?
What must be installed prior to running the PeopleSoft installer?
What is sql architecture?