Help for C# Interview questions and career decision

Hi All
I am fresh college graduate who has done C and C++ during college
times.After that i had done a C# course from one of our local computer
institute.The course is BCM which ran for 1 year.But now when i am
looking for job the questions asked in interview are really very very
weird and does not match any where near to what my institute taught.
My faculty has give me following links for preparation of interview
http://www.geocities.com/dotnetinterviews/
http://www.techninterviews.com
http://www.brainbench.com
http://www.crackinterviews.com
with that he has said to do small project which will make me confident.
But i need a job soon and can not really wait to do dummy projects do
you really think those upper links can be helpful in getting a job
I am new comer so please excuse for asking in this way.Any good website
for interview question please help me
A great way to learn newer concepts is probably to study other people's
source code. Check out http://www.thecodeproject.com.
"programmerforknowledge" <aspdotnetprogrammer420@.yahoo.co.in> wrote in
message news:1126447024.790773.136420@.f14g2000cwb.googlegr oups.com...
> Hi All
> I am fresh college graduate who has done C and C++ during college
> times.After that i had done a C# course from one of our local computer
> institute.The course is BCM which ran for 1 year.But now when i am
> looking for job the questions asked in interview are really very very
> weird and does not match any where near to what my institute taught.
> My faculty has give me following links for preparation of interview
> http://www.geocities.com/dotnetinterviews/
> http://www.techninterviews.com
> http://www.brainbench.com
> http://www.crackinterviews.com
> with that he has said to do small project which will make me confident.
> But i need a job soon and can not really wait to do dummy projects do
> you really think those upper links can be helpful in getting a job
> I am new comer so please excuse for asking in this way.Any good website
> for interview question please help me
>
|||"programmerforknowledge" <aspdotnetprogrammer420@.yahoo.co.in> wrote:

>Hi All
>I am fresh college graduate who has done C and C++ during college
>times.After that i had done a C# course from one of our local computer
>institute.The course is BCM which ran for 1 year.But now when i am
>looking for job the questions asked in interview are really very very
>weird and does not match any where near to what my institute taught.
>...
>with that he has said to do small project which will make me confident.
>But i need a job soon and can not really wait to do dummy projects do
>you really think those upper links can be helpful in getting a job
Your advisor has given you good advice. The questions in your interviews
are designed to root out whether you actually have any real-world
experience, and based on your reaction, they seem to have done their job.
One of the great ways to get real-world experience is, well, to get
real-world experience, by tackling some project on your own. You might as
well use the time you have before you get a job.
Also, remember that Linux comes with hundreds of thousands of lines of
real-world, working C code that you can read and tinker with.
- Tim Roberts, timr@.probo.com
Providenza & Boekelheide, Inc.

Help for C# Interview questions and career decision

Hi All
I am fresh college graduate who has done C and C++ during college
times.After that i had done a C# course from one of our local computer
institute.The course is BCM which ran for 1 year.But now when i am
looking for job the questions asked in interview are really very very
weird and does not match any where near to what my institute taught.
My faculty has give me following links for preparation of interview
http://www.geocities.com/dotnetinterviews/
http://www.techninterviews.com
http://www.brainbench.com
http://www.crackinterviews.com
with that he has said to do small project which will make me confident.
But i need a job soon and can not really wait to do dummy projects do
you really think those upper links can be helpful in getting a job
I am new comer so please excuse for asking in this way.Any good website
for interview question please help me
I'll answer as best I can.
It's not unusual for Academia to teach skills which do not reflect the real
world. All they seem to do is prove you are capable of learning ...
something.
Firstly I would stongly advise that you learn the development cycle by
thinking of a project and write it. You'll go through all the pains of bugs,
code crashes, lack of information as well as building up a strong reference
of internet sites and material from which you can draw from in the future.
This does means time will need to be invested. You'll be very lucky to get a
job without some basic usable skills unless you find someone to employ you
as a trainee. As regards to getting a job. Get one but not neccesarily as a
programmer. After you've written your project(s) and got used to seeing
"real code" you'll be much better prepared for the interview process and
many of the things you were asked you will now understand and be able to
answer and maybe they'll offer you a job.
Nik Marshall-Blank MCSD/MCDBA
"programmerforknowledge" <aspdotnetprogrammer420@.yahoo.co.in> wrote in
message news:1126447136.410064.175010@.g44g2000cwa.googlegr oups.com...
> Hi All
> I am fresh college graduate who has done C and C++ during college
> times.After that i had done a C# course from one of our local computer
> institute.The course is BCM which ran for 1 year.But now when i am
> looking for job the questions asked in interview are really very very
> weird and does not match any where near to what my institute taught.
> My faculty has give me following links for preparation of interview
> http://www.geocities.com/dotnetinterviews/
> http://www.techninterviews.com
> http://www.brainbench.com
> http://www.crackinterviews.com
> with that he has said to do small project which will make me confident.
> But i need a job soon and can not really wait to do dummy projects do
> you really think those upper links can be helpful in getting a job
> I am new comer so please excuse for asking in this way.Any good website
> for interview question please help me
>

Help for C# Interview questions and career decision

Hi All
I am fresh college graduate who has done C and C++ during college
times.After that i had done a C# course from one of our local computer
institute.The course is BCM which ran for 1 year.But now when i am
looking for job the questions asked in interview are really very very
weird and does not match any where near to what my institute taught.
My faculty has give me following links for preparation of interview
http://www.geocities.com/dotnetinterviews/
http://www.techninterviews.com
http://www.brainbench.com
http://www.crackinterviews.com
with that he has said to do small project which will make me confident.
But i need a job soon and can not really wait to do dummy projects do
you really think those upper links can be helpful in getting a job
I am new comer so please excuse for asking in this way.Any good website
for interview question please help meI'll answer as best I can.
It's not unusual for Academia to teach skills which do not reflect the real
world. All they seem to do is prove you are capable of learning ...
something.
Firstly I would stongly advise that you learn the development cycle by
thinking of a project and write it. You'll go through all the pains of bugs,
code crashes, lack of information as well as building up a strong reference
of internet sites and material from which you can draw from in the future.
This does means time will need to be invested. You'll be very lucky to get a
job without some basic usable skills unless you find someone to employ you
as a trainee. As regards to getting a job. Get one but not neccesarily as a
programmer. After you've written your project(s) and got used to seeing
"real code" you'll be much better prepared for the interview process and
many of the things you were asked you will now understand and be able to
answer and maybe they'll offer you a job.
--
Nik Marshall-Blank MCSD/MCDBA
"programmerforknowledge" <aspdotnetprogrammer420@.yahoo.co.in> wrote in
message news:1126447136.410064.175010@.g44g2000cwa.googlegroups.com...
> Hi All
> I am fresh college graduate who has done C and C++ during college
> times.After that i had done a C# course from one of our local computer
> institute.The course is BCM which ran for 1 year.But now when i am
> looking for job the questions asked in interview are really very very
> weird and does not match any where near to what my institute taught.
> My faculty has give me following links for preparation of interview
> http://www.geocities.com/dotnetinterviews/
> http://www.techninterviews.com
> http://www.brainbench.com
> http://www.crackinterviews.com
> with that he has said to do small project which will make me confident.
> But i need a job soon and can not really wait to do dummy projects do
> you really think those upper links can be helpful in getting a job
> I am new comer so please excuse for asking in this way.Any good website
> for interview question please help me
>sql

Help for C# Interview questions and career decision

Hi All
I am fresh college graduate who has done C and C++ during college
times.After that i had done a C# course from one of our local computer
institute.The course is BCM which ran for 1 year.But now when i am
looking for job the questions asked in interview are really very very
weird and does not match any where near to what my institute taught.
My faculty has give me following links for preparation of interview
http://www.geocities.com/dotnetinterviews/
http://www.techninterviews.com
http://www.brainbench.com
http://www.crackinterviews.com
with that he has said to do small project which will make me confident.
But i need a job soon and can not really wait to do dummy projects do
you really think those upper links can be helpful in getting a job
I am new comer so please excuse for asking in this way.Any good website
for interview question please help meI'll answer as best I can.
It's not unusual for Academia to teach skills which do not reflect the real
world. All they seem to do is prove you are capable of learning ...
something.
Firstly I would stongly advise that you learn the development cycle by
thinking of a project and write it. You'll go through all the pains of bugs,
code crashes, lack of information as well as building up a strong reference
of internet sites and material from which you can draw from in the future.
This does means time will need to be invested. You'll be very lucky to get a
job without some basic usable skills unless you find someone to employ you
as a trainee. As regards to getting a job. Get one but not neccesarily as a
programmer. After you've written your project(s) and got used to seeing
"real code" you'll be much better prepared for the interview process and
many of the things you were asked you will now understand and be able to
answer and maybe they'll offer you a job.
Nik Marshall-Blank MCSD/MCDBA
"programmerforknowledge" <aspdotnetprogrammer420@.yahoo.co.in> wrote in
message news:1126447136.410064.175010@.g44g2000cwa.googlegroups.com...
> Hi All
> I am fresh college graduate who has done C and C++ during college
> times.After that i had done a C# course from one of our local computer
> institute.The course is BCM which ran for 1 year.But now when i am
> looking for job the questions asked in interview are really very very
> weird and does not match any where near to what my institute taught.
> My faculty has give me following links for preparation of interview
> http://www.geocities.com/dotnetinterviews/
> http://www.techninterviews.com
> http://www.brainbench.com
> http://www.crackinterviews.com
> with that he has said to do small project which will make me confident.
> But i need a job soon and can not really wait to do dummy projects do
> you really think those upper links can be helpful in getting a job
> I am new comer so please excuse for asking in this way.Any good website
> for interview question please help me
>

Help find better option:Views from table in various Db Viz local d

I am having performance issues Timeout, blocking , long running stored
procedures etc.
Application is written in C sharp and uses database sql2000 sp3.
I have about 25 databases, view is used that joins tables from all db with
left outer join and multiple conditions in where clause.
Online updates are taking place which again goes back to that particular
table in spec. db. Triggers are used at few places to update the view. Every
where stored procedures are used extensively instead of t-sql. In sp at
places table variables are used to minimise locks.
In the initial phase only with each database having few thousand records
user start getting timeout ,slow response & blocking complaints.
Should I copy the view to have local copy of data and have job that run
every min or 2 to update local table . In that too I am not clear that how
useful it will be to keep local copy bcz. it will grow huge in size with
growth in all db.
Very complex thing I see is continuous updates back and forth , which may
keep local copy block for most of the time or else user wan't have latest
data available in their app.
Any one who has worked with similar situation can be lot more useful,
I will highly appreciate any suggestions or discussions from sql experts.
Thanks,Views can be good or bad. If you follow the rules for creating partitioned
views then only the needed table(s) will be scanned. Else, every table in a
view will be scanned which would introduce more unnecessary locks.
http://msdn.microsoft.com/library/e...des_06_9mlv.asp
-oj
"Sameer Raval" <Sameer Raval @.discussions.microsoft.com> wrote in message
news:DB036029-CA4E-463D-B475-19BCE875ACA7@.microsoft.com...
>I am having performance issues Timeout, blocking , long running stored
> procedures etc.
> Application is written in C sharp and uses database sql2000 sp3.
> I have about 25 databases, view is used that joins tables from all db with
> left outer join and multiple conditions in where clause.
> Online updates are taking place which again goes back to that particular
> table in spec. db. Triggers are used at few places to update the view.
> Every
> where stored procedures are used extensively instead of t-sql. In sp at
> places table variables are used to minimise locks.
> In the initial phase only with each database having few thousand records
> user start getting timeout ,slow response & blocking complaints.
> Should I copy the view to have local copy of data and have job that run
> every min or 2 to update local table . In that too I am not clear that how
> useful it will be to keep local copy bcz. it will grow huge in size with
> growth in all db.
> Very complex thing I see is continuous updates back and forth , which may
> keep local copy block for most of the time or else user wan't have latest
> data available in their app.
> Any one who has worked with similar situation can be lot more useful,
> I will highly appreciate any suggestions or discussions from sql
> experts.
> Thanks,
>
>
>
>
>
>
>
>|||Sameer
> I am having performance issues Timeout, blocking , long running stored
> procedures etc.
> Application is written in C sharp and uses database sql2000 sp3.
Have you started to investigate the queries? Have you defined indexes on the
tables?
http://www.sql-server-performance.com
"Sameer Raval" <Sameer Raval @.discussions.microsoft.com> wrote in message
news:DB036029-CA4E-463D-B475-19BCE875ACA7@.microsoft.com...
> I am having performance issues Timeout, blocking , long running stored
> procedures etc.
> Application is written in C sharp and uses database sql2000 sp3.
> I have about 25 databases, view is used that joins tables from all db with
> left outer join and multiple conditions in where clause.
> Online updates are taking place which again goes back to that particular
> table in spec. db. Triggers are used at few places to update the view.
Every
> where stored procedures are used extensively instead of t-sql. In sp at
> places table variables are used to minimise locks.
> In the initial phase only with each database having few thousand records
> user start getting timeout ,slow response & blocking complaints.
> Should I copy the view to have local copy of data and have job that run
> every min or 2 to update local table . In that too I am not clear that how
> useful it will be to keep local copy bcz. it will grow huge in size with
> growth in all db.
> Very complex thing I see is continuous updates back and forth , which may
> keep local copy block for most of the time or else user wan't have latest
> data available in their app.
> Any one who has worked with similar situation can be lot more useful,
> I will highly appreciate any suggestions or discussions from sql
experts.
> Thanks,
>
>
>
>
>
>
>
>

Help connecting SQL

I have an application that connect to a local SQL server, but i need
to install the same application in another office outside of the
office. How can i make my application connect to my SQL server
remotely to make transactions?The app connects to your SQL Server using TCP/IP and some port number. If it is a default instance,
then the port is by default 1433. If it is a named instance, then you should look up what port
number the instance is using (pls post what version of SQL Server). So the app need to be able to
connect using this port, either by opening for the port in your firewall (NOT RECOMMENDED!!!) or
using VPN or similar.
Of course, you can re-architecture your app into either a n-tier app or by using HTTP endpoints
(assuming 2005), but I have a feeling that re-writing your app isn't an option.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Macana" <leninarias@.gmail.com> wrote in message
news:14ead399-dab5-4826-95c4-c280f8a485f3@.l32g2000hse.googlegroups.com...
>I have an application that connect to a local SQL server, but i need
> to install the same application in another office outside of the
> office. How can i make my application connect to my SQL server
> remotely to make transactions?

HELP ! How to Print Through Network Printer

Hello All,
I have Sample printer deliver extension provided with Reporting
Services. This code works well when i use Local printer, but i want to
use network printer, for that i changed config file as -
<Printer>\\199.63.103.253\NB1OACHP5100</Printer>
but Reporting Services shows error - The printer
\\199.63.103.253\NB1OACHP5100 is not currently installed on the server.
Can anybody help me how to solve this? Also can i print the report on
an trigger like in my application i use a button to print, and on click
this report get printed.
Please help me if you solved such problem or you know how to solve
this.
Thank You
Regards
RajAll printers you use from the server Must be defined to the server... This is
simply the control panel add printer stuff.
This is doc'd in books on line...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Raj" wrote:
> Hello All,
> I have Sample printer deliver extension provided with Reporting
> Services. This code works well when i use Local printer, but i want to
> use network printer, for that i changed config file as -
> <Printer>\\199.63.103.253\NB1OACHP5100</Printer>
> but Reporting Services shows error - The printer
> \\199.63.103.253\NB1OACHP5100 is not currently installed on the server.
>
> Can anybody help me how to solve this? Also can i print the report on
> an trigger like in my application i use a button to print, and on click
> this report get printed.
> Please help me if you solved such problem or you know how to solve
> this.
> Thank You
> Regards
> Raj
>|||Thanks for reply Wayne, but i already defined the printer to the
server. It is installed on my machine where server is installed. And
also do anybody know how to print report without preview on click
event?
Thanks & Regards
Raj|||We've been trying to auto-print without the preview or dialog box that pops
up, the only thing we have found is by doing a subscription...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Raj" wrote:
> Thanks for reply Wayne, but i already defined the printer to the
> server. It is installed on my machine where server is installed. And
> also do anybody know how to print report without preview on click
> event?
> Thanks & Regards
> Raj
>|||The printer delivery sample indicates that the server name/address must be
included in the configuration for a Networked printer. This does not appear
to be true. All that is necessary here is that the name be exactly the
same (exact case also) as what is defined in the Control Panel for the
computer
on which the Report Server is running.
"Raj" wrote:
> Hello All,
> I have Sample printer deliver extension provided with Reporting
> Services. This code works well when i use Local printer, but i want to
> use network printer, for that i changed config file as -
> <Printer>\\199.63.103.253\NB1OACHP5100</Printer>
> but Reporting Services shows error - The printer
> \\199.63.103.253\NB1OACHP5100 is not currently installed on the server.
>
> Can anybody help me how to solve this? Also can i print the report on
> an trigger like in my application i use a button to print, and on click
> this report get printed.
> Please help me if you solved such problem or you know how to solve
> this.
> Thank You
> Regards
> Raj
>

HELP - Problem with Replication

Hello,

I have transactional replication running between two SQL Servers. It's a push subscription and the distributor is on the local publisher.

Recently after running for a year the replication stopped working and we get the following two errors.

1 - The process could not bulk copy into the table "History_Rep"

String Data, Right Truncation. Error Number 22001.

-

2 - The process could not bulk copy into the table "History_Rep"

Unexpected EOF encountered in BCP Data-File. Error Number S1000

The data types between the source and target tables are identical. I've tried emptying my source tables so that BCP doesn't have to send anything to the subscriber but it still fails. Do I maybe need to purge my distribution database and BCP log files? How do I go about doing that.

Thanks in advance Guys,

Hugo

Hi Hugo,

Once you have emptied the source table, you would need to reinitialize your subscription and re-generate the snapshot in order to 'remove' the bad bcp data from the system. Having said that, I can't help but suspect that there is a schema (column size) mismatch between the publisher and the subscriber based on the error message that you posted. Is this on SQL2000 (my guess) or SQL 2005?

-Raymond

|||

Raymond.

Yes, SQL Server 2000.

I've checked the column names, data types, sizes, three or four times - they're identical. How do I reinitialize the subscription - do I have to remove it and re-add it? Can it be done easily with Enterprise manager?

Thanks,

Hugo

|||

Hi Hugo,

You should be able to just right-click on your subscription node in Enterprise Manager and choose reinitialize subscription on the context manual. Does the problematic table have multiple text\image columns at the end by any chance?

-Raymond

|||

Hey Raymond,

When I right click on the subscription node, there's no option for re-initializing the subscription. I can't find that anywhere.

The table is all varchars and ints. No Text fields. There is a varchar 4000 second from the end where we put some XML data but that's it.

Thanks,

Hugo

|||

Hi Hugo,

My thinking was probably mixed up by how the SQL2005 UI is laid out, here is what worked for me using the SQL2000 Enterprise Manager:

For a well-known push or pull subscription:

1) Publisher Server->Expand Replication Folder->Expand Publications Folder->Select publication whose subscription(s) you want to reinitialize, all your subscriptions should show up on the right plane->now right-click on the subscription you want to reinitialize on the right-plane and you should be able to choose "Reinitialize" from the context menu.

For an anonymous pull subscription:

2) Subscriber Server->Expand Replication Folder->Select Subscriptions Folder, all your pull subscriptions should show up on the right-plane-> Right-click on the subscription you want to reinitialize on the right-plane and you should be able to choose "Reinitialize" from the context menu.

Hope that helps,

-Raymond

|||

Raymond,

Awesome - that worked. Not it says it's pending - why? How can I find out why it's pending - there's nothing in any logs that I can see.

Thanks for all your help,

Hugo

|||

Hey Raymond,

I also started the snapshot agent and it ran okay. But, my subscription still says pending and when I try to start the distribution agent I get the same error.

Hugo

|||

Have you restarted the snapshot agent?

-Raymond

|||

Sorry for the hasty reply, were there any rows bulk copied out by the snapshot agent for the problematic table?

-Raymond

|||

No need for apologies

Well, it said four articles were generated - I'll investigate more.

Hugo

|||

Hugo, something is not adding up correctly in your case (assuming that you have indeed deleted all data of the problematic table at the publisher), you can drop and re-add the subscription to make sure that it is not picking up a stale snapshot (I am out of ideas and my mind if that doesn't work). I am also wondering if you have different code pages between the publisher and the subscriber (or if you are using character mode snapshot) which would have caused the original bcp problem to happen. In any case, it would appear that the problem becomes extremely difficult to debug through forum postings, and so I would really appreciate if you can:

1) Open a support case with product support so they can gather sufficient information for us to investigation the issue further, or

2) Log a bug @. http://connect.microsoft.com/registration/registration.aspx with enough information (schema & data of problematic article) so we can investigate the issue properly.

Thanks much!

-Raymond

|||

Raymond,

We solved the problem last night - thanks. There was a program pumping data into the problematic table and once we shut that program down and followed your advice it worked. I think that maybe I have character mode of the snapshot going on because that has never worked. Can I change that - how?

Thanks again,

Hugo