Please Share Your Thoughts For Sql Server Dev Position Interviews

[Vinuu]

Please share your thoughts for SQL Server Dev position Interviews,regarding what are the frequent questions,tips and tricks

I am sharing some

1. What is the difference between a clustered and a non-clustered index?
2. What is the difference between truncate and delete?
3. What does the SQL Server Agent Windows service do?
4. What are DBCC commands?
5. What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

[JollyBoy]

neku interview unda ipudu.. T-SQL okkatena.. IS, RS akakrleda..

[SQLbie]

Joins chusuko and cursors
Which join helps to avoid cursors??

[Vinuu]

Thanku

[JollyBoy]

[quote name='SQLbie' timestamp='1379705122' post='1304277903']
Joins chusuko and cursors
Which join helps to avoid cursors??
[/quote]


join cursor ni enduku avoid chestadi.. just asking emaina miss ayya emo ani..

[JollyBoy]

OPtimization techniquies,, sql profiler n query execution plan gurunchi cheppali.. sql profiler lo no of reads ekkuva unte performance baledu ani meaning...no of reads should be less ,, no fn's in where clause, use proper joins ,, if using temp tables have indexes on them.. real tables ki elagu undali..
CTE, recursive cte,, wat new functions did you use like hiereachy , merge insert...
Transacrtions advantages..

[SQLbie]

[quote name='JollyBoy' timestamp='1379706149' post='1304278032']



join cursor ni enduku avoid chestadi.. just asking emaina miss ayya emo ani..
[/quote]
Cross join chusuko nannu interview appudu adigaru Nenu edo sollu cheppanu
Taruvatha chusthe ardam ayindi
Check with cross join

[siritptpras]

Ho can u replace cursors I had this in one interview

[ghazni]

[quote name='SQLbie' timestamp='1379706754' post='1304278094']
Cross join chusuko nannu interview appudu adigaru Nenu edo sollu cheppanu
Taruvatha chusthe ardam ayindi
Check with cross join
[/quote]
And also cursors can be avoided by using CTEs too if i am not wrong...

[JollyBoy]

[quote name='SQLbie' timestamp='1379706754' post='1304278094']
Cross join chusuko nannu interview appudu adigaru Nenu edo sollu cheppanu
Taruvatha chusthe ardam ayindi
Check with cross join
[/quote]
Cross join is never a good option when u work in real time..
Cursors alternative is while loop.. based on requirement we can avoid both sometimes..
Most of the times while loop is better..

[JollyBoy]

There is CROSS APPLY which is efficient in some cases.. this kind of requirements doesnt come so often.

[Vinuu]

Thanku all