SEO report of techtalkspro.com

Domain : www.techtalkspro.com/

Character length : 21

Good! The OG (Open Graph) protocol is set on this website.

title: TECHTalksPro
type: website
url: http://www.techtalkspro.com/
image: http://www.techtalkspro.com/favicon.ico
description: TechTalksPro provides quality software tutorials for SQL Server,SSIS,SSRS,BIGData, Hadoop, HDFS, MapReduce,Sqoop, Flume, Hive, Pig,Greenplum
site_name: TECHTalksPro
locale: en_US
locale:alternate: id_ID

• http://www.techtalkspro.com/search?updated-max=2017-02-26T00:35:00-0... ("Older Posts")
• http://www.techtalkspro.com/.. /rearrange?blogID=8579084863904183920&wid...
• http://www.techtalkspro.com/.. /rearrange?blogID=8579084863904183920&wid...
• http://www.techtalkspro.com/.. /rearrange?blogID=8579084863904183920&wid...

• <H2> Thursday, March 9, 2017
• <H2> Getting Error while accessing Hive from command line interface
• <H2> Logging initialized using configuration in file:/etc/hive/2.5.0.0-1245/0/hive-log4j.properties
• <H2> Exception in thread "main" java.lang.RuntimeException: org.apache.hadoop.security.AccessControlException: Permission denied: user=root, access=WRITE, inode="/user/root":hdfs:hdfs:drwxr-xr-x
• <H2> Sunday, February 26, 2017
• <H2> TOP 100 SQL SERVER INTERVIEW QUESTIONS
• <H2> SQL SERVER INTERVIEW QUESTIONS
• <H3> 
• <H3> 1.      What is the Complex task that you handled in your project 2.      What are the differences between Delete and Truncate? 3.      Diff b/w Char and Varchar 4.      Diff b/w Unicode and Non-unicode characters 5.      Different ways to identify duplicate records in table 6.      How will you identify table granularity if we table doesn’t have any primary key/unique key 7.      Diff b/w Stored procedure and Function 8.      How parameter sniffing will happen? Give me one example 9.      Can we embed Dynamic SQL in Functions 10. Diff b/w CROSS Apply and Outer Apply and different from INNER JOIN and OUTER JOINS 11. Brief about Windows Functions which were introduced as part of SQL Server 2012 12. Diff b/w Coalesce() and ISNULL() and which will be best? 13. How many clustered and non clustered indexes can be created in one table? 14. What are the main differences between UNION ,  UNION ALL and EXCEPT 15. How will identify the root causes of slow running procedures/functions 16. How will you identify slow running queries in SQL Server 17. How will identify the matched and non matched records between two tables  18. What are ACID properties 19. What are the isolation levels and explain each one with example 20. What is the diff b/w LOCK and NOLOCK 21. What is Table variable, Temp  table and CTE and in which scenarios what kind of table will you use 22. Explain the scenario where you have written normal subquery and Correlated Subquery 23. Diff b/w Where and Having Clause 24. Can we execute Stored Procedure inside Function? 25.  Can we you use Case Statement in Order by Clause? 26. Explain about INNER, LEFT, RIGHT, FULL OUTER joins 27. Explain the scenario where you have used Self join 28. What are deleted and inserted tables 29. Explain the scenario where MERGE statement will be use ful 30. How will you reseed the identity column 31. How will you check if column exists for a table or view in database 32. What is trigger and different types of triggers 33. What is view and indexed view/materialised view 34. What is the Query logical execution order 35. Difference between clustered and non clustered index 36. Difference between Stuff and Replace function 37. What is linked Server 38. Difference b/w Varchar and Varchar(max) 39. What are the system databases (master, msdb, model and tempdb) roles and functionalities 40. Difference b/w index seek and index scan 41. Difference b/w RaiseError and throw and which one will be the best to use 42. Pivot and Unpivot 43. Diff b/w IN and EXISTS clause 44. What is cursor and how many different types are there 45. What is exception handling 46. What are dirty reads, phantom reads 47. What is dead lock 48. Diff b/w Local and Global Temporary tables 49. What is synonym 50. What is Sequence? Diff b/w Sequence and Identity
• <H2> SQL SERVER : ALTER, DELETE,DROP
• <H3> What is the difference between DELETE and TRUNCATE?
• <H3>  Both are deleting rows. Yes both are deleting table data however there are some differences are there while deleting the data.
• <H2> SQL Server- SQL Server Data Types
• <H2> SQL SERVER Data types
• <H4> What is data type?
• <H2> Blog Archive
• <H2> Popular Posts
• <H2> Featured post
• <H3> Getting Error while accessing Hive from command line interface
• <H2> Follow us on FaceBook
• <H3> About
• <H3> Web Tools
• <H3> Newsletter

• data36
• table32
• delete27
• sql22
• server21
• types17
• alter15
• drop14
• emp_test13
• how13
• b/w13
• size13
• column13
• truncate12
• time11
• hdfs11
• command11
• diff10
• error10
• all10
• varchar9
• hive9
• add9
• example9
• using8
• date8
• rows8
• hadoop7
• below7
• syntax7
• empid6
• char6
• string6
• root6
• between6
• type6
• some6
• used6
• yyyy-mm-dd6
• difference6
• existing6
• identity5
• constraint5
• identify5
• numeric5
• modify5
• explain5
• interview5
• joins4
• max4
• int4
• posts4
• empname4
• techvasuit4
• statement4
• comment4
• different4
• unicode4
• line4
• questions4

• sql server10
• diff b/w9
• data types8
• table emp_test6
• what are6
• how will6

• how will you4
• alter table emp_test3
• explain the scenario where3
• sql server sql2
• logging initialized using2
• unicode string data2

• https://2.bp.blogspot.com/.. /apache-hive-logo400px.jpg (1 occurrences)
• https://1.bp.blogspot.com/.. /sqlserver.png (1 occurrences)
• https://1.bp.blogspot.com/.. /sqlserver.png
• https://resources.blogblog.com/img/icon18_wrench_allbkg.png (2 occurrences)

• https://www.blogger.com/.. /1171200566-widget_css_mobile_2_bundle.cs...

• http://www.techtalkspro.com/feeds/posts/default/-/?published&alt=json-in-script&callback=labelthumbs
• http://www.techtalkspro.com/feeds/posts/default/-/?published&alt=json-in-script&callback=labelthumbs

• By lossless compressing the http://1.bp.blogspot.com/.. /TechTalksPro.png you can save 2.9KB (34%) data.
• By lossless compressing the https://3.bp.blogspot.com/.. /apache-hive-logo400px.jpg you can save 1.3KB (32%) data.
• By lossless compressing the https://2.bp.blogspot.com/.. /serveimage.png you can save 1.2KB (20%) data.