What are parallel querys and query hints?
Answer / nagaraju bhatraju
parallel queries to optimize query execution and index
operations for computers that have more than one
microprocessor (CPU). Because SQL Server can perform a
query or index operation in parallel by using several
operating system threads, the operation can be completed
quickly and efficiently.
Is This Answer Correct ? | 6 Yes | 0 No |
What happens if the info. Server doesn't find the session parameter in the parameter file?
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
what is Partitioning ? where we can use Partition?
how can u tune u r informatica mapppings
What are the challenges of Dataware housing in the future?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What is meant by a domain?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
what is mapping override?
what are the deliverables?in your project?
why we use materialized view over view?
What is a data modeling?