Advertise your Business Here      Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new    Refer this Site               Login  |  Sign Up                         SiteMap shows list of All Categories in this site.

Categories  >>  Software  >>  Databases  >>  SQL Server        Suggest New Category      Question  Asked @ Answers Views     select   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.  0  86 Where do you think the users names and passwords will be stored in sql server?  2  1380 What are the authentication modes in SQL Server?  2  1348 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  1034 How do you troubleshoot SQL Server if its running very slow?  2  1866 Can you explain the role of each service?  1  862 What are the OS services that the SQL Server installation adds?  1  696 Which stored procedure will you be running to add a linked server?  1  807 Can you link only other SQL Servers or any database servers such as Oracle?  1  791 What is a Linked Server?  1  976 When do you use SQL Profiler?  2  1411 Can you explain the types of Joins that we can have with Sql Server?  2  1340 What is a Join in SQL Server?  1  1021 What do you mean by COLLATION?  4  1642 What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? Yardi-Software   2  3220 E-Mail New Answers        Answer Selected Questions     Prev    1   ... 4   ... 7   ... 10   ... 13   ... 16   ... 19   ... 22   ... 25   ... 28    31   [32]    33   Next         Oracle Interview Questions     SQL Server Interview Questions     MS Access Interview Questions     MySQL Interview Questions     Postgre Interview Questions     Sybase Interview Questions     DB Architecture Interview Questions     DB Administration Interview Questions     DB Development Interview Questions     SQL PLSQL Interview Questions     Databases AllOther Interview Questions       Un-Answered Questions    Question Views Asked at   Select   What is the difference between NOROW and LOCKROW? 54 Honeywell How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000? 75   whate is advantages of sql server 2000 74   Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype? 40 Value-Labs 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? 41 ABC 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? 95 Wipro Which command executes the contents of a specified file? 85 InfoMedia where the connection string store in the database 52 HCL 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. 86   What is an execution plan? When would you use it? How would you view the execution plan? 110   Any one plz send me SQL Server Developer/DBA resume for 4 years experience 111   If a stored procedure is taking a table data type, how it looks? 90   Scalability, Availability, Integration with internet, etc.)? 64   Explain the storage models of OLAP? 81   How would you Update the rows which are divisible by 10, given a set of numbers in column? 89   What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ? 61 Wipro Rate yourself in .NET and SQL ? 41 Cognizent 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 24 IGT if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition 35 Aviva Which command displays the SQL command in the SQL buffer, and then executes it? 78 TCS E-Mail New Answers        Answer Selected Questions

Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |            Copyright © 2007  ALLInterview.com.  All Rights Reserved. ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com