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 9658
Difference between Cluster and Non-cluster index?32 121890
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1105
explain different types of jions with examples briefly?2 5413
Which databases are part of SQL server default installation? Explain the usage of each?2 4523
What all db objects can be found in MSDB database of a SQL Server instance?2 4776
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 8205
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 6813
How do you fine the performance tunning?2 5213
What are mdf,ndf,ldf files and how to see the data in those files?6 52815
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 13775
Differences between functions and stored procedures?8 8743
event classes in sql server2 4295
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.11 10766
How do you feel about doing repetitive work?
WHAT IS THE ACTUAL DEFINATION OF PLANET?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id email@example.com
what are the mandatory properties for a tex boxc (scenario?)
upto how much low RPM we will run the commercial motor which is run through VFD without any problem occurs in motor.Motor rating Duty is S1 & RPM is 1400.
what are all the things will consider while doing sensitivity analysis?
What is PL/I?
What is the structural formula of molybdenum blue?
what is a state cheque? how it differes from stale cheque?
how can i develop forum code? any one pleale help me on this question
draw diagram of earthings
what is the calculation method to design core and winding of a 200kva 3phase distribution transformer?
Name some Big Data products?