Help for a one year fresher to enter the software industry

Dear Freinds,
I am hoping a postive answer from this group. I have done my
graduation currently and looking for a break in programming in C# or
VB.NET with SQL Server. After graduation i joined a computer institute
and did a one year course there. For first six months i was nearly
taught nothing. But later some how i started to read things on my own.
After one year i have started attending interviews. But the questions
asked are so much out of topic sometimes. I can completed sample
projects. What should i do because after one year i have come to know
that questions in interviews are so different from actual projects.
For instance i was asked about SOA , damn it i have no idea about that
stuff. I am also reading interview questions and answers from
http://www.questpond.com but i am still not able to cope up.
Please help what approach should i take now. 1 year is a big time
freinds.<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers from
> http://www.questpond.com but i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
>
Welcome to the real world. (You didn't mention what part of it. That might
help. You may have to leave.)
Landing a first job with no employment experience is tough. Beyond the
obvious -take a shower, clean your nails, and look interested - there is no
simple answer.
You will be hired eventually because an employer thinks you can be a benefit
for him and he likes you. Sometimes all you need is to be likeable. Do
whatever you can to be likeable and appear useful.
For how to be likeable, getting some books, attending some emploment
seminars, etc. may help. Researching as much as you can about the employer
and the job will help you to appear useful.
Beyond that it is all BS, and gaming with a slightly irrational opponent in
charge of the rules. But if you keep plugging it will happen. That's the
positive.
-ralph|||On Oct 14, 1:58 pm, mrnagra...@.yahoo.co.in wrote:
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers fromhttp://www.questpond.combut i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
Two Things.
Firstly, try to go through as many interviews as possible. Usually for
every 15-20 resumes that you send out, you should expect a response of
1. And that is assuming your resume is in line with the job you are
applying for. Keep a track of the jobs you are applying to, what
skills are required, do you show case them in your interview, etc.
You don't have to have experience. But you have to know your stuff. So
e.g. for SOA, try spending a few hours every day learning new
technology. Read an article on WIKI about what SOA is. Then read about
web services. Maybe try building, and consuming a web service in C#.
Learn something new that you see on job listings, but you are not too
sure or confident about.
Stop wasting your money and time going to institutes. At the end of
the day, you will learn the most from your own practice.
Secondly, it is generally easier to get into a entry level QA or
Application Support role than is to get into development. You need to
have good communication skills though, so if you need, work on that as
well. Again, go through as many interviews as possible. The more you
get turned down, the harder you will become, and the better you will
be at the next interview.
I got a job at Bell Canada (Customer Service) working as a Sales Rep
selling TV channels to subscribers. I was making $10 an hour. I kept
giving interviews and stayed sharp with my tech skills. I ended up
getting a job as a Support Analyst with a Bank's IT firm next. I was
making $16 an hour. I still kept updating my skills. I am now an
Intermediate .Net developer with a multi national, making a lot more
than that :)
Keep at it, you will find your way.|||Ralph wrote:
> <mrnagrajan@.yahoo.co.in> wrote in message
> news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
>> Dear Freinds,
>> I am hoping a postive answer from this group. I have done my
>> graduation currently and looking for a break in programming in C# or
>> VB.NET with SQL Server. After graduation i joined a computer
>> institute and did a one year course there. For first six months i
>> was nearly taught nothing. But later some how i started to read
>> things on my own. After one year i have started attending
>> interviews. But the questions asked are so much out of topic
>> sometimes. I can completed sample projects. What should i do because
>> after one year i have come to know that questions in interviews are
>> so different from actual projects.
>> For instance i was asked about SOA , damn it i have no idea about
>> that stuff. I am also reading interview questions and answers from
>> http://www.questpond.com but i am still not able to cope up.
>> Please help what approach should i take now. 1 year is a big time
>> freinds.
> Welcome to the real world. (You didn't mention what part of it. That
> might help. You may have to leave.)
> Landing a first job with no employment experience is tough. Beyond the
> obvious -take a shower, clean your nails, and look interested - there
> is no simple answer.
> You will be hired eventually because an employer thinks you can be a
> benefit for him and he likes you. Sometimes all you need is to be
> likeable. Do whatever you can to be likeable and appear useful.
> For how to be likeable, getting some books, attending some emploment
> seminars, etc. may help. Researching as much as you can about the
> employer and the job will help you to appear useful.
> Beyond that it is all BS, and gaming with a slightly irrational
> opponent in charge of the rules. But if you keep plugging it will
> happen. That's the positive.
> -ralph
Lots of good advice in the two response so far. I second most everything
they said.
That said, I'd like to add:
English apparently isn't your native language, so you should get used to
using spell checks whenever you even come close to anything/anyone related
to the job market.
To more fully grab interest of the readers, you should add such things as
what degrees you have, in what, and where you earned them, along with any
work blocks and/or part time jobs relevant to your goals that you had while
you were in school.
It's tough to gain experience without a job, and tough to get a job without
experience, but it's a catch-22 you can overcome with patience and
perseverance. The comments so far about taking all the interviews you can
get were good ones. The more interview experience the better you'll be
prepared as you work you way through them all. Besides, you might just come
across an entry level job you weren't expecting to find and if it has any
advancement possibilities at all, it can be a good starting point for a
first job.
One thing I don't think was directly mentioned about sending out resumes
is, try to write a cover letter specific for each industry you apply to.
That gives you a chance to expose your goals and your work ethics, things
that aren't part of the resume as a rule. Ideally a cover letter should
only be one page long and do as good a job selling yourself as you can.
Unless you're strapped for cash, don't instantly grab the first offer you
receive. Most places will understand that you need to "think about it" for
a week or so, giving you time to do more research and think about the
overall prospects. But at the same time, don't overlook one that's just
exactly what you want.
A log book or notebook and some samples of your work are often handy at
interviews too, even if they don't look at them. Just having them is an
indicator of your preparedness.
And lastly, try to appear level-headed as possible, even when something
seriously surprises you or excites you to no end<g>. Those who can see
surprises and unexpected events as challenges are usually at the head of the
line. And then, after all that, "Be Yourself" and show a strong work
ethic.
Best of luck,
Pop`|||On Sun, 14 Oct 2007 10:58:47 -0700, mrnagrajan@.yahoo.co.in wrote:
>Dear Freinds,
>I am hoping a postive answer from this group. I have done my
>graduation currently and looking for a break in programming in C# or
>VB.NET with SQL Server. After graduation i joined a computer institute
>and did a one year course there. For first six months i was nearly
>taught nothing. But later some how i started to read things on my own.
>After one year i have started attending interviews. But the questions
>asked are so much out of topic sometimes. I can completed sample
>projects. What should i do because after one year i have come to know
>that questions in interviews are so different from actual projects.
>For instance i was asked about SOA , damn it i have no idea about that
>stuff. I am also reading interview questions and answers from
>http://www.questpond.com but i am still not able to cope up.
>Please help what approach should i take now. 1 year is a big time
>freinds.
I think I see your problem...
Where did you graduate from?|||Hi,
So are you new a team leader? Do you write documentation?
Do you sit any MCIT or other MS cert?
> Secondly, it is generally easier to get into a entry level QA or
> Application Support role than is to get into development. You need to
> have good communication skills though, so if you need, work on that as
> well. Again, go through as many interviews as possible. The more you
> get turned down, the harder you will become, and the better you will
> be at the next interview.
> I got a job at Bell Canada (Customer Service) working as a Sales Rep
> selling TV channels to subscribers. I was making $10 an hour. I kept
> giving interviews and stayed sharp with my tech skills. I ended up
> getting a job as a Support Analyst with a Bank's IT firm next. I was
> making $16 an hour. I still kept updating my skills. I am now an
> Intermediate .Net developer with a multi national, making a lot more
> than that :)
> Keep at it, you will find your way.|||<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Please help what approach should i take now. 1 year is a big time
> freinds.
1 year is not a long time especially seeing you say you didn't learn
anything for the first 6 months. Did you do any programming before this
year? If not I wouldn't hire you with your current level of training. If
this is your only experience then go back and do some more schooling. There
are a lot of people trying to get into the IT industry with minimal
expericence or training.
Michael|||"Michael C" <mike@.nospam.com> wrote in message
news:%23V2Ho4sDIHA.4584@.TK2MSFTNGP03.phx.gbl...
> .
> There are a lot of people trying to get into the IT industry with minimal
> expericence or training.
And they have succeeded.
www.beyondsql.blogspot.com|||"Steve Dassin" <rac4sqlnospam@.net> wrote in message
news:uvoReBtDIHA.1204@.TK2MSFTNGP03.phx.gbl...
> "Michael C" <mike@.nospam.com> wrote in message
> news:%23V2Ho4sDIHA.4584@.TK2MSFTNGP03.phx.gbl...
>> .
>> There are a lot of people trying to get into the IT industry with minimal
>> expericence or training.
> And they have succeeded.
> www.beyondsql.blogspot.com
You've been involved in IT for some time, right? The IT industry used to be
so desperate for people they'd hire anyone. Now it requires a little more
knowledge :-)
Michael|||"Michael C" <mike@.nospam.com> wrote in message
news:OoSoZQtDIHA.3332@.TK2MSFTNGP04.phx.gbl...
> You've been involved in IT for some time, right? The IT industry used to
> be so desperate for people they'd hire anyone. Now it requires a little
> more knowledge :-)
Oops, I din't mean that to sound like it did :-) I started the same way and
suspect I might have trouble getting in now if I tried with my initial
experience.
> Michael
>|||On Oct 14, 10:51 pm, "Michael C" <m...@.nospam.com> wrote:
> "Michael C" <m...@.nospam.com> wrote in message
> news:OoSoZQtDIHA.3332@.TK2MSFTNGP04.phx.gbl...
> > You've been involved in IT for some time, right? The IT industry used to
> > be so desperate for people they'd hire anyone. Now it requires a little
> > more knowledge :-)
> Oops, I din't mean that to sound like it did :-) I started the same way and
> suspect I might have trouble getting in now if I tried with my initial
> experience.
>
>
> > Michael- Hide quoted text -
> - Show quoted text -
I won't suggest going back to school to this individual. The guy has
already spent some hefty amounts I am sure. He needs to practice and
hone his skills. I also won't say that I would not hire him given his
current technical skills. Maybe he just needs to showcase what he
knows better. I remember when I was starting out, I knew a lot, but I
just didn't have enough interview experience, and I would get sweaty
hands and be nervous.
You need to take all of this advice, see what you think are potential
roadblocks for you, and work them out. Stick it out, take it easy, and
have a strategy.
Asad|||"Michael C" <mike@.nospam.com> wrote in message
news:%23k%230PZtDIHA.4028@.TK2MSFTNGP05.phx.gbl...
> "Michael C" <mike@.nospam.com> wrote in message
> news:OoSoZQtDIHA.3332@.TK2MSFTNGP04.phx.gbl...
> > You've been involved in IT for some time, right? The IT industry used to
> > be so desperate for people they'd hire anyone. Now it requires a little
> > more knowledge :-)
> Oops, I din't mean that to sound like it did :-) I started the same way
and
> suspect I might have trouble getting in now if I tried with my initial
> experience.
Nah, I bet most people would be comfortable with the inference from
the first response :)
Sure, just look into this forum for proof that you need a higher
level of knowledge and understanding today than 10 years ago.
It used to be when the smoke clears you could see what's really
going on. But the ability to blow smoke exceeds the patience
of waiting. So now the industry demands a higher level of knowledge
for what is really nothing more than a blow job. Are you kidding me?
Like Elvis, common sense seems to have left the building :-).
www.beyondsql.blogspot.com|||"Steve Dassin" <rac4sqlnospam@.net> wrote in message
news:uf9xnfuDIHA.4360@.TK2MSFTNGP06.phx.gbl...
> Nah, I bet most people would be comfortable with the inference from
> the first response :)
> Sure, just look into this forum for proof that you need a higher
> level of knowledge and understanding today than 10 years ago.
> It used to be when the smoke clears you could see what's really
> going on. But the ability to blow smoke exceeds the patience
> of waiting. So now the industry demands a higher level of knowledge
> for what is really nothing more than a blow job. Are you kidding me?
> Like Elvis, common sense seems to have left the building :-).
Dunno, common sense seems to have settled in a little bit. Some of the
people I used see get hired....
Michael|||mrnagrajan@.yahoo.co.in's wild thoughts were released on Sun,
14 Oct 2007 10:58:47 -0700 bearing the following fruit:
>Dear Freinds,
>I am hoping a postive answer from this group. I have done my
>graduation currently and looking for a break in programming in C# or
>VB.NET with SQL Server. After graduation i joined a computer institute
>and did a one year course there. For first six months i was nearly
>taught nothing. But later some how i started to read things on my own.
>After one year i have started attending interviews. But the questions
>asked are so much out of topic sometimes. I can completed sample
>projects. What should i do because after one year i have come to know
>that questions in interviews are so different from actual projects.
>For instance i was asked about SOA , damn it i have no idea about that
>stuff. I am also reading interview questions and answers from
>http://www.questpond.com but i am still not able to cope up.
>Please help what approach should i take now. 1 year is a big time
>freinds.
Be prepared to take a low paid trainee position. Getting
some experience is more importany initially than the wage.
Jan Hyde
https://mvp.support.microsoft.com/profile/Jan.Hyde|||Some helpful tips
http://www.itjobfeed.com/secrets-of-getting-an-IT-job.asp
<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers from
> http://www.questpond.com but i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
>|||s'pose no one thinks the cadence of the vernacular of the OP is pretty close to
the opening Paragraph of the link....
<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers from
> http://www.questpond.com but i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
>|||"MikeB" <m.byerleyATVerizonDottieNettie> wrote in message
news:%23qyZo$xDIHA.4296@.TK2MSFTNGP04.phx.gbl...
> s'pose no one thinks the cadence of the vernacular of the OP is pretty
> close to the opening Paragraph of the link....
Dunno, I didn't click any links.
Michael

help files in English (QA)

Dear fellows,
From my workstation I've got QA and its help files, in spanish. I'd like to
have in english and so I would avoid to use Terminal Server (against
production servers) for consult that info in English...
Is there any way for to change this?
Thanks a lot for any input or advice,
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)The support files for Books Online are stored in the following location:
C:\Program Files\Microsoft SQL Server\80\Tools\Books
The link is as follows:
C:\WINDOWS\hh.exe "C:\Program Files\Microsoft SQL
Server\80\Tools\Books\SQL80.col"
You could create a new folder like the following and copy the files from
another workstation that had an Engligh install:
C:\Program Files\Microsoft SQL Server\80\Tools\Books_EN
Once done, create a new shortcut on your desktop for the following:
C:\WINDOWS\hh.exe "C:\Program Files\Microsoft SQL
Server\80\Tools\Books_EN\SQL80.col"
I would expect that only one version of BOL can be linked with QA, EM and
the other client tools, so you would need to access the Engligh verison of
the documentation using the above shortcut.
Also, there is MSDN.com
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:E90A46EB-EBFD-4967-ADF9-FD5030B0F1A7@.microsoft.com...
> Dear fellows,
> From my workstation I've got QA and its help files, in spanish. I'd like
> to
> have in english and so I would avoid to use Terminal Server (against
> production servers) for consult that info in English...
> Is there any way for to change this?
> Thanks a lot for any input or advice,
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''s hard to provide information
> without seeing the code. location: Alicante (ES)|||hi JT,
Have done but not successful results. my workstaton is in spanish. Maybe
that's the reason. I have 'Archivos de programa' instead of 'Program Files'
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)
"JT" wrote:

> The support files for Books Online are stored in the following location:
> C:\Program Files\Microsoft SQL Server\80\Tools\Books
> The link is as follows:
> C:\WINDOWS\hh.exe "C:\Program Files\Microsoft SQL
> Server\80\Tools\Books\SQL80.col"
> You could create a new folder like the following and copy the files from
> another workstation that had an Engligh install:
> C:\Program Files\Microsoft SQL Server\80\Tools\Books_EN
> Once done, create a new shortcut on your desktop for the following:
> C:\WINDOWS\hh.exe "C:\Program Files\Microsoft SQL
> Server\80\Tools\Books_EN\SQL80.col"
> I would expect that only one version of BOL can be linked with QA, EM and
> the other client tools, so you would need to access the Engligh verison of
> the documentation using the above shortcut.
> Also, there is MSDN.com
> "Enric" <vtam13@.terra.es.(donotspam)> wrote in message
> news:E90A46EB-EBFD-4967-ADF9-FD5030B0F1A7@.microsoft.com...
>
>|||I don't see why an Engligh (.chm) help file can't be opened; adjust the
folder path to the files as needed. The Engligh characterset is part of a
Spanish language install of Windows.
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:577F1495-5E28-4201-A399-B901E8A13D0C@.microsoft.com...
> hi JT,
> Have done but not successful results. my workstaton is in spanish. Maybe
> that's the reason. I have 'Archivos de programa' instead of 'Program
> Files'
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''s hard to provide information
> without seeing the code. location: Alicante (ES)
>
> "JT" wrote:
>

Help :Custom Date Time Format

Dear All,
How to return current time in format as below:
YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
Thanks
Robert LieBest thing would be to write a UDF and put in some standardformat to get the
special format you need.
HTH, Jens Suessmeyer.
"Robert Lie" <robert.lie24@.gmail.com> schrieb im Newsbeitrag
news:O9BRSXJeFHA.3864@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How to return current time in format as below:
> YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
> Thanks
> Robert Lie|||Hi,
Use this format
select Convert(Varchar,getdate(),120)
Hope this will help
Herbert
"Robert Lie" wrote:

> Dear All,
> How to return current time in format as below:
> YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
> Thanks
> Robert Lie
>|||To add to the other responses, consider performing data formatting in your
presentation layer rather than Transact-SQL. SQL Server is optimized for
efficient data access and application code/reporting tools generally provide
more robust and efficient formatting capabilities.
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:O9BRSXJeFHA.3864@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How to return current time in format as below:
> YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
> Thanks
> Robert Lie

Help :Custom Date Time Format

Dear All,
How to return current time in format as below:
YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
Thanks
Robert Lie
Best thing would be to write a UDF and put in some standardformat to get the
special format you need.
HTH, Jens Suessmeyer.
"Robert Lie" <robert.lie24@.gmail.com> schrieb im Newsbeitrag
news:O9BRSXJeFHA.3864@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How to return current time in format as below:
> YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
> Thanks
> Robert Lie
|||Hi,
Use this format
select Convert(Varchar,getdate(),120)
Hope this will help
Herbert
"Robert Lie" wrote:

> Dear All,
> How to return current time in format as below:
> YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
> Thanks
> Robert Lie
>
|||To add to the other responses, consider performing data formatting in your
presentation layer rather than Transact-SQL. SQL Server is optimized for
efficient data access and application code/reporting tools generally provide
more robust and efficient formatting capabilities.
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:O9BRSXJeFHA.3864@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How to return current time in format as below:
> YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
> Thanks
> Robert Lie

Help :Custom Date Time Format

Dear All,
How to return current time in format as below:
YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
Thanks
Robert LieBest thing would be to write a UDF and put in some standardformat to get the
special format you need.
HTH, Jens Suessmeyer.
"Robert Lie" <robert.lie24@.gmail.com> schrieb im Newsbeitrag
news:O9BRSXJeFHA.3864@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How to return current time in format as below:
> YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
> Thanks
> Robert Lie|||Hi,
Use this format
select Convert(Varchar,getdate(),120)
Hope this will help
Herbert
"Robert Lie" wrote:
> Dear All,
> How to return current time in format as below:
> YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
> Thanks
> Robert Lie
>|||To add to the other responses, consider performing data formatting in your
presentation layer rather than Transact-SQL. SQL Server is optimized for
efficient data access and application code/reporting tools generally provide
more robust and efficient formatting capabilities.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:O9BRSXJeFHA.3864@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How to return current time in format as below:
> YYYYMMDDHHMM -> Year-Month-Date-Hour-Minute
> Thanks
> Robert Lie

Help : Rule

Dear All,
I have created a rule and i have bind it to several columns in server
tables.
For documentation purposes, I need to make list of bind columns to that
rule.
How to do that?
Thanks
Robert Lie
Any reason why you are using rules rather than CHECK constraints? Rules
have been deprecated since version 7.0. CHECK constraints are more
powerful, easier to use and are highly recommended instead of rules.
Also, unlike rules, CHECK constraints can be used by the optimizer to
improve the performance of your queries.
Try this to list all columns with rules:
SELECT
OBJECT_NAME(id) AS table_name,
name AS column_name,
OBJECT_NAME(domain) AS rule_name
FROM syscolumns
WHERE OBJECTPROPERTY(domain,'IsRule')=1
David Portas
SQL Server MVP

Help : Rule

Dear All,
I have created a rule and i have bind it to several columns in server
tables.
For documentation purposes, I need to make list of bind columns to that
rule.
How to do that?
Thanks
Robert LieAny reason why you are using rules rather than CHECK constraints? Rules
have been deprecated since version 7.0. CHECK constraints are more
powerful, easier to use and are highly recommended instead of rules.
Also, unlike rules, CHECK constraints can be used by the optimizer to
improve the performance of your queries.
Try this to list all columns with rules:
SELECT
OBJECT_NAME(id) AS table_name,
name AS column_name,
OBJECT_NAME(domain) AS rule_name
FROM syscolumns
WHERE OBJECTPROPERTY(domain,'IsRule')=1
--
David Portas
SQL Server MVP
--

Help : Rule

Dear All,
I have created a rule and i have bind it to several columns in server
tables.
For documentation purposes, I need to make list of bind columns to that
rule.
How to do that?
Thanks
Robert LieAny reason why you are using rules rather than CHECK constraints? Rules
have been deprecated since version 7.0. CHECK constraints are more
powerful, easier to use and are highly recommended instead of rules.
Also, unlike rules, CHECK constraints can be used by the optimizer to
improve the performance of your queries.
Try this to list all columns with rules:
SELECT
OBJECT_NAME(id) AS table_name,
name AS column_name,
OBJECT_NAME(domain) AS rule_name
FROM syscolumns
WHERE OBJECTPROPERTY(domain,'IsRule')=1
David Portas
SQL Server MVP
--

Help : Performance due to SQL Mail

Dear All,
I have a sql job that checking incoming email by using xp_findnextmsg,
read the incoming email then reply the sender with query result.
I schedule the job every minute.
My question is:
Does the job will make my sql server perfomance down?
Thanks
Robert Lie
Hi
The job itself, no. But test in your environment as to what affects your own
code you wrote causes on locking and blocking on your tables.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:1121049371.109507.159220@.g14g2000cwa.googlegr oups.com...
> Dear All,
> I have a sql job that checking incoming email by using xp_findnextmsg,
> read the incoming email then reply the sender with query result.
> I schedule the job every minute.
> My question is:
> Does the job will make my sql server perfomance down?
> Thanks
> Robert Lie
>

Help : Performance due to SQL Mail

Dear All,
I have a sql job that checking incoming email by using xp_findnextmsg,
read the incoming email then reply the sender with query result.
I schedule the job every minute.
My question is:
Does the job will make my sql server perfomance down?
Thanks
Robert LieHi
The job itself, no. But test in your environment as to what affects your own
code you wrote causes on locking and blocking on your tables.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:1121049371.109507.159220@.g14g2000cwa.googlegroups.com...
> Dear All,
> I have a sql job that checking incoming email by using xp_findnextmsg,
> read the incoming email then reply the sender with query result.
> I schedule the job every minute.
> My question is:
> Does the job will make my sql server perfomance down?
> Thanks
> Robert Lie
>

Help : Performance due to SQL Mail

Dear All,
I have a sql job that checking incoming email by using xp_findnextmsg,
read the incoming email then reply the sender with query result.
I schedule the job every minute.
My question is:
Does the job will make my sql server perfomance down?
Thanks
Robert LieHi
The job itself, no. But test in your environment as to what affects your own
code you wrote causes on locking and blocking on your tables.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:1121049371.109507.159220@.g14g2000cwa.googlegroups.com...
> Dear All,
> I have a sql job that checking incoming email by using xp_findnextmsg,
> read the incoming email then reply the sender with query result.
> I schedule the job every minute.
> My question is:
> Does the job will make my sql server perfomance down?
> Thanks
> Robert Lie
>

Help (question from 70-228)

Dear All,
I need your help to answer this question below:
======
You are the administrator of a SQL Server 2000 computer.
The server contains a database named Sales. A company e-commerce
application uses the Sales database to store sales transactions. The
company Web site has grown in popularity, and database utilization has
increased.
You need to collect data about the utilization of server resources so
that you can provide capacity planning. You want to automate the
collection process so that information is gathered as quickly as possible.
What should you do?
a. Configure System Monitor to collect data and store it in a SQL Server
table
b. Create a SQL Server Agent job that executes the sp_statistics stored
procedure daily and places the results in a text file
c. Use SQL Profiler to trace server activity and store the results in
SQL Server tables
d. Configure SQL Server alerts to store information in the Windows
application event log
======
Thanks
Robert Lie
I believe the answer is a) The reason is that a) is the only choice that
covers the whole server, to elaborate
b) gives the information on indexes, so you cannot perform capacity planning
from it
c) gives SQL Server commands executed but does not give such things as CPU
usage, disk usage ect
d) gives alert based upon a certain event, so that event has to occur before
its fired.
a) With a however you can configure it to report usage of server stuff i.e.
CPU Usgage, memory usage ect over a specific time period, i.e. every 10
seconds.
Anyone with anything different ?
Peter
"Robert Lie" wrote:

> Dear All,
> I need your help to answer this question below:
> ======
> You are the administrator of a SQL Server 2000 computer.
> The server contains a database named Sales. A company e-commerce
> application uses the Sales database to store sales transactions. The
> company Web site has grown in popularity, and database utilization has
> increased.
> You need to collect data about the utilization of server resources so
> that you can provide capacity planning. You want to automate the
> collection process so that information is gathered as quickly as possible.
> What should you do?
> a. Configure System Monitor to collect data and store it in a SQL Server
> table
> b. Create a SQL Server Agent job that executes the sp_statistics stored
> procedure daily and places the results in a text file
> c. Use SQL Profiler to trace server activity and store the results in
> SQL Server tables
> d. Configure SQL Server alerts to store information in the Windows
> application event log
> ======
> Thanks
> Robert Lie
>

Help (question from 70-228)

Dear All,
I need your help to answer this question below:
====== You are the administrator of a SQL Server 2000 computer.
The server contains a database named Sales. A company e-commerce
application uses the Sales database to store sales transactions. The
company Web site has grown in popularity, and database utilization has
increased.
You need to collect data about the utilization of server resources so
that you can provide capacity planning. You want to automate the
collection process so that information is gathered as quickly as possible.
What should you do?
a. Configure System Monitor to collect data and store it in a SQL Server
table
b. Create a SQL Server Agent job that executes the sp_statistics stored
procedure daily and places the results in a text file
c. Use SQL Profiler to trace server activity and store the results in
SQL Server tables
d. Configure SQL Server alerts to store information in the Windows
application event log
======
Thanks
Robert LieI believe the answer is a) The reason is that a) is the only choice that
covers the whole server, to elaborate
b) gives the information on indexes, so you cannot perform capacity planning
from it
c) gives SQL Server commands executed but does not give such things as CPU
usage, disk usage ect
d) gives alert based upon a certain event, so that event has to occur before
its fired.
a) With a however you can configure it to report usage of server stuff i.e.
CPU Usgage, memory usage ect over a specific time period, i.e. every 10
seconds.
Anyone with anything different ?
Peter
"Robert Lie" wrote:
> Dear All,
> I need your help to answer this question below:
> ======> You are the administrator of a SQL Server 2000 computer.
> The server contains a database named Sales. A company e-commerce
> application uses the Sales database to store sales transactions. The
> company Web site has grown in popularity, and database utilization has
> increased.
> You need to collect data about the utilization of server resources so
> that you can provide capacity planning. You want to automate the
> collection process so that information is gathered as quickly as possible.
> What should you do?
> a. Configure System Monitor to collect data and store it in a SQL Server
> table
> b. Create a SQL Server Agent job that executes the sp_statistics stored
> procedure daily and places the results in a text file
> c. Use SQL Profiler to trace server activity and store the results in
> SQL Server tables
> d. Configure SQL Server alerts to store information in the Windows
> application event log
> ======> Thanks
> Robert Lie
>

Help (question from 70-228)

Dear All,
I need your help to answer this question below:
======
You are the administrator of a SQL Server 2000 computer.
The server contains a database named Sales. A company e-commerce
application uses the Sales database to store sales transactions. The
company Web site has grown in popularity, and database utilization has
increased.
You need to collect data about the utilization of server resources so
that you can provide capacity planning. You want to automate the
collection process so that information is gathered as quickly as possible.
What should you do?
a. Configure System Monitor to collect data and store it in a SQL Server
table
b. Create a SQL Server Agent job that executes the sp_statistics stored
procedure daily and places the results in a text file
c. Use SQL Profiler to trace server activity and store the results in
SQL Server tables
d. Configure SQL Server alerts to store information in the Windows
application event log
======
Thanks
Robert LieI believe the answer is a) The reason is that a) is the only choice that
covers the whole server, to elaborate
b) gives the information on indexes, so you cannot perform capacity planning
from it
c) gives SQL Server commands executed but does not give such things as CPU
usage, disk usage ect
d) gives alert based upon a certain event, so that event has to occur before
its fired.
a) With a however you can configure it to report usage of server stuff i.e.
CPU Usgage, memory usage ect over a specific time period, i.e. every 10
seconds.
Anyone with anything different ?
Peter
"Robert Lie" wrote:

> Dear All,
> I need your help to answer this question below:
> ======
> You are the administrator of a SQL Server 2000 computer.
> The server contains a database named Sales. A company e-commerce
> application uses the Sales database to store sales transactions. The
> company Web site has grown in popularity, and database utilization has
> increased.
> You need to collect data about the utilization of server resources so
> that you can provide capacity planning. You want to automate the
> collection process so that information is gathered as quickly as possible.
> What should you do?
> a. Configure System Monitor to collect data and store it in a SQL Server
> table
> b. Create a SQL Server Agent job that executes the sp_statistics stored
> procedure daily and places the results in a text file
> c. Use SQL Profiler to trace server activity and store the results in
> SQL Server tables
> d. Configure SQL Server alerts to store information in the Windows
> application event log
> ======
> Thanks
> Robert Lie
>

Help - how to select from a comma delimited field ?

Dear SQL,

Lets say I have a field: User_Names

and it can have more than one name
example: "Yovav,John,Shon"

How can I select all the records that has "Yovav" in them ?

I try some like this:
SELECT * FROM User_Table WHERE User_Names IN ('Yovav')

but it only works if the field User_Names only has "Yovav" in it with no extras...

is there some SQL function to tell if string is found in a field ?

Any hope 4 me ?Try

SELECT * FROM User_Table WHERE User_Names LIKE '%Yovav%'|||Thank Q 4 lightning up my night in such times of overSQLing...

finally I can have some sleep :-)

and Thank GOD 4 this forum !!!

Help - Complex Currency Conversion - MDX

Dear all,

I have implemented Conversion conversion in my SSAS cube (One - Many) and is working fine. (Reporting Currency dimension that has currencies to which data can be converted, Fx rates measure group that has FX rates for those currencies from base currency (GBP) and calculation to convert it) The calculation I use is as below

Code Snippet

Scope ( {Measures.[YTD Value Reporting CCY], Measures.[LTD Value Reporting CCY]});

Scope (Leaves ([Calendar]), Except([Reporting Currency].[Reporting Currency].[Reporting Currency].Members , [Reporting Currency].[Reporting Currency].&[GBP]));

Scope ( {Measures.[YTD Value Reporting CCY], Measures.[LTD Value Reporting CCY]});

This = [Reporting Currency].[Reporting Currency].[GBP] *

( Measures.[Rate],

[Reporting Currency].[Reporting Currency].CurrentMember

);

End Scope;

End Scope;

End Scope;

Now I have a situation in which the FX rates can be different for each record in the fact table. So I have introducted the FX Rate Set ID dimension (degenerate dimension for the rate measure group) and also have it as a measure (non-additive, visible=false) for the Balance measure group that contain the data to be converted. Now, how do I acheive the actual conversion by modifying the above MDX?

Something similar to the below is what I'm trying to acheive but no idea how to get it right in MDX. Please help in the correct approach and the right MDX.

Code Snippet

This = [Reporting Currency].[Reporting Currency].[GBP] *

( Measures.[Rate],

[Reporting Currency].[Reporting Currency].CurrentMember,

[FX Rate Set].[Set ID].[<<'Value of Measures.[Rate Set ID]'>>]

);

Thanks in advance.

Cheers,

Arun

Pl can anyone help me on this?

|||Could you explain this statement with an example: "I have a situation in which the FX rates can be different for each record in the fact table"? Are you referring to the Balance or the FX Rate fact table - and does this mean that FX rates may vary on the same day?|||

Below is the sample data

Fx Rates : (the pivot currency is GBP)

Date RateSet ToCurrency Rate

03 May 2007 1 AUD 2.54

03 May 2007 2 AUD 2.51

03 May 2007 1 GBP 1

03 May 2007 2 GBP 1

03 May 2007 1 EUR 1.51

03 May 2007 2 EUR 1.6

Fact Table:

ID Date <<Other dimension keys>>> Currency Balance BalanceInGBP FXRateSet

101 03 May 2007 USD 100 195 1

102 03 May 2007 USD 100 194 2

Measure Group:

Balance MG:

Balance (FactTable.Balance)

BalanceReportingCurrency (FactTable.BalanceInGBP)

Rates:

Rate ([Fx Rates].Rate)

Calculation :

In my first post... (the column names may be bit different.)

In the above scenario, the for the same date, I may have to use different "Fx rate Set" whose ID is present in both Fact table and Fx rates table. I have a dimension called Currency that joins with the Currency column in fact table. I also have another dimension called [Reporting Hierarchy] that will hold the ToCurrency in Fx Rates and based on which the conversion will be done dynamically using calculations (The BalanceReportingCurrency measure will be calcualted dynamically using corresponding rates).

|||Forgot to mention - I have the FXRateSetID from the fact table as a measure in the balance MG as it may help in doing the calculation|||One idea is to slightly change the original solution by creating a new dimension like DailyRateSet, whose key attribute is a collection of the 2 fields: Date, RateSetID. This dimension would be used as the intermediate dimension, instead of Calendar. Another approach would be with a separate RateSet dimension, but I haven't been able to work that out yet.|||

Finally got it working. I'm having the Rate Set as another dimension referred by both fact table and the Fx rates table, then whilst doing the calculation, I perform the calc at leaf levels of both Fx rate set and Time - and using the fx rate set dimension for getting the correct rate.

At present, I convert all values to GBP when laoding to my cube. To make the data independent of rate change problems, now I'm trying to work out many-to many currency conversion.

Help - Complex Currency Conversion - MDX

Dear all,

I have implemented Conversion conversion in my SSAS cube (One - Many) and is working fine. (Reporting Currency dimension that has currencies to which data can be converted, Fx rates measure group that has FX rates for those currencies from base currency (GBP) and calculation to convert it) The calculation I use is as below

Code Snippet

Scope ( {Measures.[YTD Value Reporting CCY], Measures.[LTD Value Reporting CCY]});

Scope (Leaves ([Calendar]), Except([Reporting Currency].[Reporting Currency].[Reporting Currency].Members , [Reporting Currency].[Reporting Currency].&[GBP]));

Scope ( {Measures.[YTD Value Reporting CCY], Measures.[LTD Value Reporting CCY]});

This = [Reporting Currency].[Reporting Currency].[GBP] *

( Measures.[Rate],

[Reporting Currency].[Reporting Currency].CurrentMember

);

End Scope;

End Scope;

End Scope;

Now I have a situation in which the FX rates can be different for each record in the fact table. So I have introducted the FX Rate Set ID dimension (degenerate dimension for the rate measure group) and also have it as a measure (non-additive, visible=false) for the Balance measure group that contain the data to be converted. Now, how do I acheive the actual conversion by modifying the above MDX?

Something similar to the below is what I'm trying to acheive but no idea how to get it right in MDX. Please help in the correct approach and the right MDX.

Code Snippet

This = [Reporting Currency].[Reporting Currency].[GBP] *

( Measures.[Rate],

[Reporting Currency].[Reporting Currency].CurrentMember,

[FX Rate Set].[Set ID].[<<'Value of Measures.[Rate Set ID]'>>]

);

Thanks in advance.

Cheers,

Arun

Pl can anyone help me on this?

|||Could you explain this statement with an example: "I have a situation in which the FX rates can be different for each record in the fact table"? Are you referring to the Balance or the FX Rate fact table - and does this mean that FX rates may vary on the same day?|||

Below is the sample data

Fx Rates : (the pivot currency is GBP)

Date RateSet ToCurrency Rate

03 May 2007 1 AUD 2.54

03 May 2007 2 AUD 2.51

03 May 2007 1 GBP 1

03 May 2007 2 GBP 1

03 May 2007 1 EUR 1.51

03 May 2007 2 EUR 1.6

Fact Table:

ID Date <<Other dimension keys>>> Currency Balance BalanceInGBP FXRateSet

101 03 May 2007 USD 100 195 1

102 03 May 2007 USD 100 194 2

Measure Group:

Balance MG:

Balance (FactTable.Balance)

BalanceReportingCurrency (FactTable.BalanceInGBP)

Rates:

Rate ([Fx Rates].Rate)

Calculation :

In my first post... (the column names may be bit different.)

In the above scenario, the for the same date, I may have to use different "Fx rate Set" whose ID is present in both Fact table and Fx rates table. I have a dimension called Currency that joins with the Currency column in fact table. I also have another dimension called [Reporting Hierarchy] that will hold the ToCurrency in Fx Rates and based on which the conversion will be done dynamically using calculations (The BalanceReportingCurrency measure will be calcualted dynamically using corresponding rates).

|||Forgot to mention - I have the FXRateSetID from the fact table as a measure in the balance MG as it may help in doing the calculation|||One idea is to slightly change the original solution by creating a new dimension like DailyRateSet, whose key attribute is a collection of the 2 fields: Date, RateSetID. This dimension would be used as the intermediate dimension, instead of Calendar. Another approach would be with a separate RateSet dimension, but I haven't been able to work that out yet.|||

Finally got it working. I'm having the Rate Set as another dimension referred by both fact table and the Fx rates table, then whilst doing the calculation, I perform the calc at leaf levels of both Fx rate set and Time - and using the fx rate set dimension for getting the correct rate.

At present, I convert all values to GBP when laoding to my cube. To make the data independent of rate change problems, now I'm trying to work out many-to many currency conversion.

Help

Dear Sir,
My name is Sureshkanan working as programmer cum network
administrator. I hav been using VB 6 & Ms Sql server 7
(now 2000) for
the programs. I have so many problem to be solved. If u
don't mind,
please help me in this regard.
Problem 1.
I hav a varchar field in sql server, which can hold 750
characters.
When I try to show the field in the crystal report 8.5,
the field is
truncated @. 255th character. It is showing first 254
character of the
content.
Problem 2
I installed a program which I developed onto several
machines using
administrator password. I checked the installed program,
that works
fine. In one computer the program is working when I logon
as
administrator but it is not working in other users. The
following
error is displayed when I clicked on the program.
The error.
The application failed to initialize property
(0xc0000022). Click on
ok to terminate the application.
All my clients are in Windows 2000 professional plat form.
Please advice me how can I over come above problemsSureshkanan wrote:
> Dear Sir,
> My name is Sureshkanan working as programmer cum network
> administrator. I hav been using VB 6 & Ms Sql server 7
> (now 2000) for
> the programs. I have so many problem to be solved. If u
> don't mind,
> please help me in this regard.
> Problem 1.
> I hav a varchar field in sql server, which can hold 750
> characters.
> When I try to show the field in the crystal report 8.5,
> the field is
> truncated @. 255th character. It is showing first 254
> character of the
> content.
This sounds like a Crystal issue. You may want ask Business Objects for
help on this.

> Problem 2
> I installed a program which I developed onto several
> machines using
> administrator password. I checked the installed program,
> that works
> fine. In one computer the program is working when I logon
> as
> administrator but it is not working in other users. The
> following
> error is displayed when I clicked on the program.
> The error.
> The application failed to initialize property
> (0xc0000022). Click on
> ok to terminate the application.
> All my clients are in Windows 2000 professional plat form.
> Please advice me how can I over come above problems
Sounds like a rights issue. Are you sure this is a SQL Server problem?
David Gugick
Imceda Software
www.imceda.com|||Problem 1 does sound like a crystal problem.
I have seen this scenario before in Access on form or report fields when the
control is bound to a memo type field and the data length is greater than
255. The solution was to remove any formatting on the control. Dont know
whether this applies to Crystal but you can try it
As David said i think you need to expand on exactly what you are doing.
Does your program actually connect to SQL server or does it not get that far
?
Andy
"Sureshkanan" wrote:

> Dear Sir,
> My name is Sureshkanan working as programmer cum network
> administrator. I hav been using VB 6 & Ms Sql server 7
> (now 2000) for
> the programs. I have so many problem to be solved. If u
> don't mind,
> please help me in this regard.
> Problem 1.
> I hav a varchar field in sql server, which can hold 750
> characters.
> When I try to show the field in the crystal report 8.5,
> the field is
> truncated @. 255th character. It is showing first 254
> character of the
> content.
> Problem 2
> I installed a program which I developed onto several
> machines using
> administrator password. I checked the installed program,
> that works
> fine. In one computer the program is working when I logon
> as
> administrator but it is not working in other users. The
> following
> error is displayed when I clicked on the program.
> The error.
> The application failed to initialize property
> (0xc0000022). Click on
> ok to terminate the application.
> All my clients are in Windows 2000 professional plat form.
> Please advice me how can I over come above problems
>|||In Version 10 of Crystal the problem of data length limitation in solved.
Try in Version 10 of Crystal Report
Hth
"Andy B" <AndyB@.discussions.microsoft.com> wrote in message
news:96926578-5B5A-487F-B73B-61D0FDB1FE11@.microsoft.com...
> Problem 1 does sound like a crystal problem.
> I have seen this scenario before in Access on form or report fields when
the
> control is bound to a memo type field and the data length is greater than
> 255. The solution was to remove any formatting on the control. Dont know
> whether this applies to Crystal but you can try it
> As David said i think you need to expand on exactly what you are doing.
> Does your program actually connect to SQL server or does it not get that
far?
> Andy
> "Sureshkanan" wrote:
>