Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
1 4412What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
2304Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?
2 5872
What is 2nf in normalization?
How to Check if table exists in sql server?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
How to find out what is the default collation in a database?
What are the advantages of passing name-value pairs as parameters?
What is command parameter in ssrs?
Call by value and call by reference in procedure and function, with NOCOPY.
What is amo? : sql server analysis services, ssas
You want to implement the many-to-many relationship while designing tables. How would you do it?
Which rendering formats are affected by the pagesize properties?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is the Difference Between Primary and Foreign Key?
Explain what is analysis service repository?
What is the main difference between ‘between’ and ‘in’ condition operators?
Explain syntax for viewing trigger?