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 4401
What is BCP? When do we use it?2 8126
What should we do to copy the tables, schema and views from one SQL Server to another?3 6161
What are the different types of joins and what does each do?2 5975
What is a sub-query? When would you use one?3 11290
What are three SQL keywords used to change or set someone?s permissions?3 12009
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?5 12729
What is a trigger?7 4425
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 10287
What is an execution plan? When would you use it? How would you view the execution plan?1 4393
What does it mean to have quoted_identifier on? What are the implications of having it off?2 8439
What are the different types of replication? How are they used?3 9582
What is the difference between a local and a global variable?5 34614
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Which is the best place or learning center for MS SQL?????In Bangladesh?????
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Tell about MOM Tool(Microsoft Operator Manager)?
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
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
whats the maximum size of view state??
wat wil hapn if we give the both read and deny read permission to user?
your distribution database is full what will u do
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i