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                             Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE

Categories  >>  Software  >>  Databases  >>  SQL Server        Suggest New Category      Question  Asked @ Answers Views     select   How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?  1  189 What about UPDATESTATISTICS ? Intelligroup  1  722 What is the difference between IN and EXISTS operators in SQL Server? Intelligroup  3  1407 what is index seek and index scan?  2  608 How to tune a stored procedure?  4  607 what are the problems in logshipping?  2  407 How the data stores in a page?  1  280 what is the Enterprise manager(2000) and management studio (2005)?  2  447 how can do you the system monitoring?  1  205 When do you create cluster and noncluster index? Satyam  4  996 what is physical sort data and logical sort data in index?  1  188 what is diffence between replicaion and logshipping?  1  410 How do you fine the performance tunning? Accenture  2  552 what is the query and condition to delete datas in sql server.  1  198 what is hash table Teledata  2  429 E-Mail New Answers        Answer Selected Questions     Prev    1   ... 4   ... 7    9   [10]    11  ... 13   ... 16   ... 19   ... 22   ... 25   ... 28   ... 31   ... 34    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   If a stored procedure is taking a table data type, how it looks? 90   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 How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000? 75   Explain sp_configure commands, set commands? 186   how to take backup bcp out for a column in table in sql server? 50   Which command displays the SQL command in the SQL buffer, and then executes it? 78 TCS 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. 75   Explain what are db_options used for? 139   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   How would you Update the rows which are divisible by 10, given a set of numbers in column? 89   Any one plz send me SQL Server Developer/DBA resume for 4 years experience 111   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 do u do Performance tunning ? 48 Satyam Explain couple pf features of SQL server 96   Explain the storage models of OLAP? 81   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 How we create SQL Server 2005 Reporting Services ? Give me Sample 37 HCL What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ? 61 Wipro What is indexed views? plz explain with example? 61   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 ... 76 Crown-Solutions 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