Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?1 4227
What is BCP? When do we use it?2 8023
What should we do to copy the tables, schema and views from one SQL Server to another?3 6029
What are the different types of joins and what does each do?2 5874
What is a sub-query? When would you use one?3 11064
What are three SQL keywords used to change or set someone?s permissions?3 11732
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?5 12468
What is a trigger?7 4267
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 9885
What is an execution plan? When would you use it? How would you view the execution plan?1 4172
What does it mean to have quoted_identifier on? What are the implications of having it off?2 8175
What are the different types of replication? How are they used?3 9263
What is the difference between a local and a global variable?5 34114
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
how to take backup bcp out for a column in table in sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Tell about MOM Tool(Microsoft Operator Manager)?
tell me the disaster recovery plan
You are doing log shipping due to some reasons it is failing. How you will proceed from there
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Explain Capacity planning to create a database? and how to monitor it?
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?
what is package and it uses and how can u call a package
what is difference between view and Dip.