You have modified 100 store procedures and want to
replicate these changes from development to prodution, and
production can have users using the Server/DB, how would
you replicate without causing issues?
No Answer is Posted For this Question
Be the First to Post Answer
Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What is model database in sql server?
How to Check if table exists in sql server?
What is the contrast between sql and pl/sql?
how many type of indexing in database?
Tell me when is the update_statistics command used?
Determine when an index is appropriate?
How can you check the version of sql server?
Explain table valued parameters in sql server? Why tvp used?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration