#SQL SERVER INTERVIEW QUESTIONS How Use sp_MSForEachTable SP for Tables Row Count Easiest way to get row count of every table in a database. You can use sp_MSForEachTable SP CREATE TABLE #Tablescounts ( table_name varchar ( 255 ), row_coun 23:38 Share
#TCS INTERVIEW, #TCS SQL INTERVIEW QUESTIONS SQL Pivot Tricky Query Example Asked in TCS 1). We have a table(#Temp1) contain RollNumber, Subject, Marks and want output as below, Write query for same.(pivot) asked in TCS SELECT * FROM ( SELEC 23:27 1 Share
#Sapient SQL Interview, #SQL SERVER INTERVIEW QUESTIONS Most Important SQL Interview Question, Order of Query Process asked in Wipro/Sapient Asked in Wipro and Sapient SQL Server Interview What will execute first tell the order of every keyword used in below query? Ans is here: 09:30 1 Share
#MICROSOFT AZURE, #MICROSOFT AZURE INTERVIEW QUESTIONS Explain what is AutoScaling? Scaling by adding additional instances is often referred to as scaling out. Windows Azure also supports scaling up by using larger role instances ins 01:26 Share
#MICROSOFT AZURE, #MICROSOFT AZURE INTERVIEW QUESTIONS What is the difference between Web and Worker Roles in Windows Azure? As you know the main difference between the two is that an instance of a web role runs IIS, while an instance of a worker role does not. Both are man 01:25 Share
#MICROSOFT AZURE, #MICROSOFT AZURE INTERVIEW QUESTIONS Explain what is Azure Blob? Azure Blob storage is a service for storing large amounts of unstructured object data, such as text or binary data, that can be accessed from anywher 01:23 Share
#MICROSOFT AZURE, #MICROSOFT AZURE INTERVIEW QUESTIONS What are the three types of roles in Compute component in Windows Azure? VM WEB Worker 01:20 Share
#MICROSOFT AZURE, #MICROSOFT AZURE INTERVIEW QUESTIONS What is the difference between Windows Azure and Azure SQL database? Windows Azure is the cloud based premium service provided by Microsoft where we can able to host our application and make it available globally. Win 01:18 Share