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 11641
Difference between Cluster and Non-cluster index?32 128461
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1438
explain different types of jions with examples briefly?2 6350
Which databases are part of SQL server default installation? Explain the usage of each?2 5396
What all db objects can be found in MSDB database of a SQL Server instance?2 5599
Which 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 9206
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 7750
How do you fine the performance tunning?2 6098
What are mdf,ndf,ldf files and how to see the data in those files?6 55476
how 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)?15 16597
Differences between functions and stored procedures?8 10260
event classes in sql server2 5303
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.11 13259
If a round rectangle has straight edges and rounded corners, your roundrect class inherits both from rectangle and from circle, and they in turn both inherit from shape, how many shapes are created when you create a roundrect?
Which filter operation can you use to filter items with a numeric value lower than x?
What should one use for plugin development — custom post types or custom database tables?
How to know/find 32 or 64 bit in windows xp?
What is dl/i?
how can i pass a "cript"as a parameter in to a function
What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?
what is technical system, business system, logical system in sap pi7.0
What is dblink?
What is the primary configuration file for a process scheduler server and where is it located?
Is it possible to pass the dynamic values to views?
Recent trends in Human resource?
What is the difference between inheritance and encapsulation?
What is the purpose of the linux?
How is clustered index different from non-clustered index?