Sonata Software Solutions,Bangalore - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. Last post, I have posted Capgemini, Hyderabad interview Questions

       I gathered Sonata Software Solutions, Bangalore Company’s interview questions in Dec 2013. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt!! ALL THE BEST!!

(1)   Tell me about yourself?

(2)   Tell me about your current project?

(3)   Out of 3 tools, which one is more comfortable?

(4)   What do you mean by type 2 SCD?

(5)   What do you mean by type 1 SCD?

(6)   What do you mean by type 3 SCD?

Capgemini,HYD - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. Last post, I have posted Hitachi Consulting, Hyderabad.

       I gathered Capgemini Consulting, Hyderabad Company’s interview questions in Dec 2013. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt!! ALL THE BEST!!

1.       What is the difference between Delete - Truncate: in terms of transaction rollback?

2.       Write a Query to get maximum 5th salaried employee?

3.       Write a single DML statement to replace 0 with 1 & 1 with 0?

4.       How to call a Query which is in a variable?

Hitachi Consulting,HYD - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. Last post, I have posted L&T, Chennai interview Questions

       I gathered Hitachi Consulting, Hyderabad Company’s interview questions in Dec 2013. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt!! ALL THE BEST!!

1.       What is the difference between Delete - Truncate: in terms of transaction rollback?

2.       Write a Query to get maximum 5th salaried employee?

3.       Write a single DML statement to replace 0 with 1 & 1 with 0?

4.       How to call a Query which is in a variable?

L&T, Chennai - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. Last post, I have posted UHG, Hyderabad interview Questions.

       I gathered L&T Software Company’s interview in June 2013. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt!! ALL THE BEST!!

SSIS Datatypes

When I was working with SSIS packages initially, I often used to confuse with SSIS data types. Now, I used to it since I have been working with them. So, I want to blog this article so that the newbies can be benefited with this.

SSIS Data Type	SSIS Data Type Description	SQL Server Data Type
DT_WSTR	Unicode string	nchar, nvarchar, sql_variant, xml
DT_STR	string	char, varchar
DT_BOOL	Boolean	bit
DT_GUID	unique identifier	uniqueidentifier
DT_R4	float	real
DT_CY	currency	smallmoney, money
DT_DBDATE	database date	date
DT_DBTIME	database time	time
DT_DBTIME2	database time with precision	time
DT_DBTIMESTAMP	database timestamp	datetime, smalldatetime
DT_R8	double-precision float	float
DT_I2	two-byte signed integer	smallint
DT_I4	four-byte signed integer	int
DT_I8	eight-byte signed integer	bigint
DT_UI1	single-byte unsigned integer	tinyint
DT_DATE	date	date
DT_NUMERIC	numeric	decimal, numeric
DT_BYTES	byte stream	binary, varbinary, timestamp
DT_DBTIMESTAMP2	database timestamp with precision	datetime2
DT_DBTIMESTAMPOFFSET	database timestamp with timezone	datetimeoffset
DT_DECIMAL	decimal	decimal
DT_IMAGE	image	image
DT_TEXT	text stream	text
DT_NTEXT	Unicode string	ntext

Connect to Server - SQL Server Connecting Issue

I got the below issue today. I surprised by seeing this message because everything was working fine till last night. Suddenly, it was saying that permission problem, configuration issue, instance typing mismatch and so on.   

    I guess most of the people would have faced this issue. So, I want to blog this issue with solution to our new bees.

TITLE: Connect to Server

------------------------------

Cannot connect to localhost.

------------------------------

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

UHG, HYD - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. Last post, I have posted Xchange, Bangalore interview Questions.

       I attended UHG Software Company’s interview in April 2012.  I have given all the questions which I faced during interview. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt !! ALL THE BEST!!

1.       What is the difference between primary key and foreign key?

2.       What is the difference between unique key and primary key?

3.       What is a stored procedure? How can you declare input parameters and output parameters?

4.       One scenario: There is an employee table. And, I am moving employee table data to employee1 table. Next, I am deleting employee table. Now, I am getting the error. How can I handle this situation?

5.       How many reports have you created till now? What type of reports have you developed?

Xchange, Bangalore - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies.
       I attended Xchange software company's interview in March 2012.  I have given all the questions which I faced during interview. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt !! ALL THE BEST!!

(1)Tell me about yourself in terms of roles and responsibilities?

(2) How to create a cube in SSAS? Explain detailed steps from creation to deployment?

(3) What is a hierarchy? How many types of hierarchies do you have in SSAS?

(4) What is a huge data migration means in your project?

(5) How did you load 1 tera byte data from source system to target system?

Print numbers from 1 to 10 using CTE

CTE stands for "Common Table Expression". A CTE is a temporary result set that can be referenced within a SELECT, INSERT, UPDATE or DELETE statement that immediately follows the CTE.

The syntax of the CTE as follows

WITH expression_name [ ( column_name [,...n] ) ]

AS

( CTE_query_definition )

We can print the numbers by using CTE very easily.

WITH CTEName

AS

(

SELECT COUNT=1

UNION ALL

SELECT COUNT=COUNT+1

FROM CTEName where COUNT<10

)

SELECT COUNT FROM CTEName

SQL server 2008 R2 Editions

Microsoft always releases SQL server with different editions. The different editions of SQL server accommodate the unique performance, run time, price requirements of organizations and individuals.

1. SQL server 2008 R2 Data Center Edition
2. SQL Server 2008 R2 Enterprise Edition
3. SQL Server 2008 R2 Standard Edition
4. SQL Server 2008 R2 Developer Edition
5. SQL Server 2008 R2 Workgroup Edition
6. SQL Server 2008 R2 Web Edition
7. SQL Server 2008 R2 Express Edition
8. SQL Server 2008R2 Compact Edition

SqlServer History

I feel that every SQL Server professional must know about the evolution of SQL Server versions. So, I have come up with this article.

Version	year	Release Name	Code Name	Comments
1.0 (OS/2)	1989	SQL Server 1.0 (16-bit)		Microsoft, Sybase, and Aston-Tate joint venture.
1.1 (OS/2)	1991	SQL Server 1.1 (16-it)		Aston-Tate drops out of SQL Server development in 1990. Microsoft and IBM end joint development of OS/2.
4.21(WinNT)	1993	SQL Server 4.21	SQLNT
6.0	1995	SQL Server 6.0	SQL95
6.5	1996	SQL Server 6.5	Hydra
7.0	1998	SQL Server 7.0	Sphinx
	1999	SQL Server 7.0 OLAP Tools	Palato mania
8.0	2000	SQL Server 2000	Shiloh	SQL Server 2000 Service Pack 1 Released on   June 12, 2001 SQL Server 2000 Service Pack 2  Released on November 30, 2001
8.0	2003	SQL Server 2000 64-bit Edition	Liberty	SQL Server 2000 Service Pack 3 - Release date: January 17, 2003. SQL Server 2000 Service Pack 3a - Release date: May 19, 2003
9.0	2005	SQL Server 2005	Yukon
10.0	2008	SQL Server 2008	Katmai
10.25	2010	SQL Azure DB	CloudDB
10.5	2010	SQL Server 2008 R2	Kilimanjaro
11.0	2012	SQL Server 2012	Denali