Sql Server 2005 Interview Questions and Answers 


Sql Server 2005 Interview Questions and Answers
I am seeking a sql expert currently looking for a good job. The role includes:

Participate in the support/enhancement of the Ford Credit Treasury Business Intelligence (Rick) application. Duties would include: - assist in the development of business requirements - translate business requirements into technical specifications - design, code, test and implement changes - support business questions and production issues
Skills Required:
- Strong knowledge and experience in relational databases (Teradata) - Strong knowledge and experience with MSSQL (2000/2005) - ability to work with cross-functional team - ability to learn new concepts and technologies quickly - strong communication skills
Skills Preferred:
- strong knowledge and experience with Microsoft Analysis Services (2000/2005) - knowledge of Windows server infrastructure
Experience Required:
- Minimum 5 years experience with MSSQL development and/or support
Experience Preferred:
- experience working with vend
I want to implement some of the points of ERP in my application.
i want to run visual studio 2005 (VB.NET) application through browser.

I create one SQL & Application server. I want to run application on each client machine.
I am looking for someone who has some background in 'Microsoft Visual C# 2005 Express Edition' and 'Microsoft Visual Web Developer 2005 Express Edition' and 'SQL Server Business Intelligence Development Studio'. I don't just want a Web site built - its important i can learn this process so i can develop the skill & know-how to mantain the site and add to it myself.

So i need to get lessons as well !

Dont have a big budget - so cant spend to much on this.

Keen to learn - and I enjoy this side of computers.

task 1:
create an auto installer CD for installing
SQL 2005
.NET (framework)
IIS server
DATABASE (application specific tables are already present just install them automatically)

task 2:
create a scrolling table (i guess its done in javascript)
datasets are huge so the page shouldnt scroll just the table.

I am working on a project using 2005 as front end and for database SQL server as back end. There r two forms, in first form there r 3 combo boxes which are populated from differnt tables.There are some searching criteria & according to that a DataGridView which is on the same form is populated.The second detailed form will have the value from the specific column of DataGridView of first form.i need values of those fields of a row on form 2 when doubleclicking any row of the DataGridView on form 1.stuck up ,unable to get a solution,can someone plez solve this problem for me.

I am using OleDbConnection,OleDbDataAdapter,DataSet...

Thanks in advance.

I am Commerce Graduate. I have completed VB 6.0 and now i have been learning and SQL Server 2000 and 2005 for Microsoft Certification.. Having 5 yrs exp. in computer soft skill teaching viz: Vb, Ms-Access,C,HTML,DHTML,Ms-Office,Tally,D...
Pl. suggest me the best carrier track and also some way to introduce myself as a Programmer.
Thanks in advance.
Hello All.

I am trying to find a recommended Book to help me teach myself solid Windows (not web) development practices and clean coding using the C# programming language. What I hope to gain is a good understanding of basic programming practices (e.g. using conditional loops, etc.) using the C# language in the Visual Studio environment. I already have Visual Studio 2005 and SQL Server 2000 installed on my laptop and have created some basic forms (very basic) using VB. Any suggestions for a good book that will help me achieve these objectives would be greatly appreciated. Thanks.
I would like to know which order I should install the cds in. I have:
Disc 1
Disc 2
MSDN library for VS.system disc 1, 2, 3 (I have two of these, I am guessing one is 64 bit and the other 32 but cant tell which one)
SQl server 32 bit disc 1,2
SQL server 64 bit disc 1, 2
SQL server IA 64 bit disc 1, 2
can i connect visual studio 2005 with sql server express in windows xp home edition sp2???or tell me anyother sql server.
really very confused.any one help me........
how to establish a connection from 2005 to SQL server 2000????
have a look at this images.They are perfect when am uploading and
corrupt after download.i testes on sqlserver 2005 and sql server 2000.
the images are here
is there a setting in php.ini am missing.php.ini has most defaults.
We are looking for a WinForm programmer with C#, SQL Server 2000, and 2005 experience. This is for a permenant position in Dallas. You will work remotely from your home after the first few months. E-mail me through here. Thank you
The problem is
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Unable to connect to SQL Server database.
I need to from VB.NET 2005, to go through a large number of Excel with different content and organization: Look at cell content, copy rows etc.
The most important is extraction, perhaps writing out in new Excel files, or deleting from the files I am extracting from.

I know about automation as in

I think the main alternative is ADO.NET, or perhaps classic ADO? Or ADO.NET without datasets? I know you can also go through SQL Server, but I am not database person.

There is also Office Web Components, but I think that is more for presenting data in Web Pages
Hey GISers,

I just graduate from BCIT, Canada. I am looking for a job as GIS Developer/Analyst to develop my career in GIS. However, I less network/connections to explore the hidden market in North America since I migrated to Canada from Asia.
Before I moved to Canada, I worked as a GIS developer in Singapore. Highlights of my skills and abilities include:

• Databases: Oracle 8i/9i Spatial, SQL Server 2000/2005, PostgreSQL, Access
• Languages: Visual Basic/C#.NET, C/C++, ASP.NET, PHP, JavaScrpt
• Software: ArcGIS 9.2, ArcObjects and ArcSDE, FME, PostGIS, PCI Geomatics, Intergraph Geomedia, etc.
• Strong interpersonal and problem solving skills

Thank you very much.
1234553Showing 16 to 30 of 795