Un-Answered Questions { SQL Server }

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2006


What 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.

2290


Scalability, Availability, Integration with internet, etc.)?

2403


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1609


If a stored procedure is taking a table data type, how it looks?

5758


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1822


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1549


what is difference between view and Dip.

1963


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1756


What is the difference between NOROW and LOCKROW?

2195


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?

1701


How we create SQL Server 2005 Reporting Services ? Give me Sample

1545


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5472


what is the sql equivaent of the dataset relation object ?

1528


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2088