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 an execution plan? When would you use it? How would you view the execution plan?  1  425 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? Wipro   1  543 What is a trigger?  6  1588 Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table? eFunds  5  3240 What is database normalization? Digicel  5  1866 What is referential integrity? What are the advantages of it? Digital-Domain  3  1411 What are three SQL keywords used to change or set someone?s permissions?  3  2862 What is a sub-query? When would you use one?  3  2601 What are the different types of joins and what does each do?  2  1701 What should we do to copy the tables, schema and views from one SQL Server to another?  3  1763 What is BCP? When do we use it?  1  2565 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  435 Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?  2  1173 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  254 Where do you think the users names and passwords will be stored in sql server?  3  1753 E-Mail New Answers        Answer Selected Questions        Post New SQL Server Question   Prev    1   ... 5   ... 9   ... 13   ... 17   ... 21   ... 25   ... 29   ... 33   ... 37    40   [41]    42  ... 45    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’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ? 137   hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results. 166   Scalability, Availability, Integration with internet, etc.)? 152   Which is the best place or learning center for MS SQL?????In Bangladesh????? 86   my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify. 128   How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000? 164   A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons? 17 Sapient what is macro? 37 Excel One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h 32   where the connection string store in the database 115 HCL hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail 93 IntraLogic Explain what are db_options used for? 343 InterGraph How we create SQL Server 2005 Reporting Services ? Give me Sample 125 HCL Any one plz send me SQL Server Developer/DBA resume for 4 years experience 313   Explain Capacity planning to create a database? and how to monitor it? 84   role of sql sever 2005 in database rather than any other database 143   what are questions asked in TCS for database tester (sqlserver)for 2-3 exp? 118 TCS What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation? 26   What is SQL Profiler and the use of it? 27 247Customer 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. 254   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