write the query for find the top 2 highest salary in sql server36 50389
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C9 6882
Which data type can be used only on OUTPUT parameters of the stored proceduer?2 4336
Alternative way to DetDate() function?5 5635
How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ firstname.lastname@example.org 36995
How to delete an attribute from the emp table4 6204
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?2 2329
How we create SQL Server 2005 Reporting Services ? Give me Sample
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform
how to find out the repeated value from table using groupby function?4 4138
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
If user is owning any SQL Objects, can we drop that user
how to take backup bcp out for a column in table in sql server?
last function used in MS Access to convert sql what function will use in sql
What is Lock table in SQL?
Explain Capacity planning to create a database? and how to monitor it?
Scalability, Availability, Integration with internet, etc.)?
How retrieve field names from the table in SQL through JAVA code?
what is package and it uses and how can u call a package
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
How you trouble shoot when any job fails
Call by value and call by reference in procedure and function, with NOCOPY.
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
How to restore performance issues and how to check?