how do you determine the Load performance of any query in
sql server {example how do u determine performance of a
select stmnt which returns Dynamically many no of records
... some times 100,1000,10000 etc., }
What is difference between process and thread? Explain lazy writer funcationality.
Rate yourself in .NET and SQL ?
1 Answers Cognizant, HCL, SunGard,
What is dimension table? : sql server analysis services, ssas
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..
How do you know if sql server is running on your local system?
What does asynchronous call backs means?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What are the steps you must follow to hide sql server instances?
What is Trigger?
Which command executes the contents of a specified file?
Does group by sort data?
What Is The Difference Between Primary Key & Super Key