Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mahesh_newbie
Starting Member
3 Posts |
 Posted - 2009-06-01 : 11:33:38
|
Hello gurus,I am very new to SQL Server. I have attended the intreview for SQL server Junior developer. I can not find the answers for some of the questions which they have asked me.I googled it. But i could not get some answers.Could anyone help me to find out the answers? Please help me to get into job.quote:
How can you create a script for row selection in a table? What is Query Analyzer's replacement in SQL Server 2005?What are the new SQL Server 2008 index types?resolving concurrency problems in SQL Server 2005? How to find size of SQL Server tables and objects with stored procedureWhat are common name restriction on tables and columns? How to retrive database tables with no recordsWhat are the different ways of moving data/databases between servers and databases in SQL Server?What are the steps you will take to improve performance of a poor performing query?If I create a separate index on each column of a table. what are the advantages and disadvantages of the approach?Is there any significant performance difference when joining tables across different databases on the same server?
Thank you Mahesh kumar |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-06-01 : 12:26:33
|
| You claim you tried Google? You must have NO IDEA how to use Google then.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
SQLRatankalwa
Starting Member
42 Posts |
Posted - 2009-06-01 : 12:34:14
|
| How can you create a script for row selection in a table?http://searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid87_gci1155187_mem1,00.htmlWhat is Query Analyzer's replacement in SQL Server 2005?SQL Server Management StudioWhat are the new SQL Server 2008 index types?1. Spatial2. Filteredresolving concurrency problems in SQL Server 2005?1. use RowVersion Datatype2. Programatically lock the records you all the user to edit using a flagHow to find size of SQL Server tables and objects with stored procedurehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1309027_mem1,00.htmlWhat are common name restriction on tables and columns?DBMS table and column names under SQL Server 2000 have a 1 through 128-byte limit and follow the rules established for identifiers.The first character must be one of the following:* A letter as defined by the Unicode Standard 2.0The Unicode definition of letters includes Latin characters from A through Z in addition to letter characters from other languages.* The underscore (_), "at" sign (@) or number sign (#)Certain symbols at the beginning of an identifier have special meaning in SQL Server. An identifier beginning with the "at" sign denotes a local variable or parameter. An identifier beginning with a number sign denotes a temporary table or procedure. An identifier beginning with double number signs (##) denotes a global temporary object.Some Transact-SQL functions have names that start with double at signs (@@). To avoid confusion with these functions, it is recommended that you do not use names that start with @@.Subsequent characters can be any of the following:* Letters as defined in the Unicode Standard 2.0* Decimal numbers from either Basic Latin or other national scripts* The "at" sign, dollar sign ($), number sign, or underscoreThe identifier must not be a Transact-SQL reserved word. SQL Server reserves both the uppercase and lowercase versions of reserved words. Embedded spaces or special characters are not allowed although you will see these objects in good old Northwind with names that include embedded spaces. You'll have to access them by enclosing them in brackets.How to retrive database tables with no recordshttp://blog.sqlauthority.com/2007/01/10/sql-server-query-to-find-number-rows-columns-bytesize-for-each-table-in-the-current-database-find-biggest-table-in-database/What are the different ways of moving databases between servers in SQL Server?backup and restoredetach and attachLog ShippingCopy Database Publish Database WizardWhat are the steps you will take to improve performance of a poor performing query?Read the following articles:http://msdn.microsoft.com/en-us/library/ms181034.aspxhttp://www.sql-server-performance.com/articles/per/performance_audit_part8_p1.aspxIf I create a separate index on each column of a table. what are the advantages and disadvantages of the approach?If you create an index on each column of a table, it improves the query performance, as the query optimizer can choose from all the existing indexes to come up with an efficient execution plan. At the same t ime, data modification operations (such as INSERT, UPDATE, DELETE) will become slow, as every time data changes in the table, all the indexes need to be updated. Another disadvantage is that, indexes need disk space, the more indexes you have, more disk space is used.Is there any significant performance difference when joining tables across different databases on the same server?the execution plans are identical, which tells you that performance of the query, whether it is inside a single database, or between two databases on the same server, are more or less identical.On the other hand, if the databases are on separate servers, performance may suffer greatly due to network latency, etc.Ratan KalwaSQL Server Professionals User Grouphttp://www.revalsys.com |
|
|
|
Mahesh_newbie
Starting Member
3 Posts |
Posted - 2009-06-01 : 12:48:49
|
| Ratan Kalwa,Thanks for your help. I got all the answers.Thanks againMahesh |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-06-01 : 15:16:40
|
| Being able to repeat them in an interview is one thing. Actually putting them into use when needed is quite another. I've seen you on at least one other wbe board and the suggestions were to use BOL and then Google it. Good luck on the interview but even better luck to the prospective employer if thay cannot detect that it's memorization versus knowledge!Terry-- Procrastinate now! |
|
|
|
Mahesh_newbie
Starting Member
3 Posts |
Posted - 2009-06-01 : 18:48:57
|
| Tosscrosby, I appreciate your kind advice. The thing is I already attended the interview. I don't know the answers for the above questions. I am very new to Database world. One of the interviewer advised me about sqlteam.com. This was my first interview in my life. I am sure I will improve my knowledge in further days.Thanks for your supportMaheshThank you |
|
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-06-02 : 03:57:37
|
| wow i learnt something in this post |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-06-02 : 05:30:42
|
quote:
Originally posted by waterduck
wow i learnt something in this post
That people do turn up for an interview without knowing much of anything and without preparing?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
|
|
Interview questions - Please help newbie