MCTS SQL Server 2005

What scares me about the 70-431 exam is the huge amount of complicated
T-SQL commands. Look at the syntax of any T-SQL command with all its
options; many many options, how can I remember them. Do I need to
remember all these instructions for the exam. Please let me know.If you learn it, you don't have to remember it :) On top of that, I think it
is an easier test than 7.0 or 2000. Just practice and understand why and you
will be fine.
--
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"lrantisi" <lrantisi@.gmail.com> wrote in message
news:b833a574-8d18-4b79-9498-b84df470ec14@.e23g2000prf.googlegroups.com...
> What scares me about the 70-431 exam is the huge amount of complicated
> T-SQL commands. Look at the syntax of any T-SQL command with all its
> options; many many options, how can I remember them. Do I need to
> remember all these instructions for the exam. Please let me know.|||Agree!
70-431 was mutch easier that 70-228/70-229 and 70-028/029
but the follow ups 70-441/70-442 and 70-443/70-444
are more complicated that SQL2000 or SQL7 exams
what is good - You can optain quite easyly MCTS SQL2005
What I can recomment - for repeating, self training and getting the point of
real tests - go thorugh some preparation provider material (measureup or
something like)
But the main point is - You dont know exact syntacs or exact options for
every single thing (I don't know for example and in real life BOL is always
opened on my hand, during work, during traiining etc - unfortunately not
allowed during exams :))
You have to know and understand the principles of things. The structure, the
goal, the reason and the target of sql sentences.
As I remember - there wasn't so much in 431 about performance stuff
With bests
Henn
PS! Let me know when You pass the 431 :)
"jason" <jason-r3move@.statisticsio.com> kirjutas sõnumis
news:93A5B69C-EA5B-4269-9C70-6D3B7EDE0E5F@.microsoft.com...
> If you learn it, you don't have to remember it :) On top of that, I think
> it is an easier test than 7.0 or 2000. Just practice and understand why
> and you will be fine.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
> "lrantisi" <lrantisi@.gmail.com> wrote in message
> news:b833a574-8d18-4b79-9498-b84df470ec14@.e23g2000prf.googlegroups.com...
>> What scares me about the 70-431 exam is the huge amount of complicated
>> T-SQL commands. Look at the syntax of any T-SQL command with all its
>> options; many many options, how can I remember them. Do I need to
>> remember all these instructions for the exam. Please let me know.
>

MCTS SQL Server 2005

What scares me about the 70-431 exam is the huge amount of complicated
T-SQL commands. Look at the syntax of any T-SQL command with all its
options; many many options, how can I remember them. Do I need to
remember all these instructions for the exam. Please let me know.
If you learn it, you don't have to remember it On top of that, I think it
is an easier test than 7.0 or 2000. Just practice and understand why and you
will be fine.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"lrantisi" <lrantisi@.gmail.com> wrote in message
news:b833a574-8d18-4b79-9498-b84df470ec14@.e23g2000prf.googlegroups.com...
> What scares me about the 70-431 exam is the huge amount of complicated
> T-SQL commands. Look at the syntax of any T-SQL command with all its
> options; many many options, how can I remember them. Do I need to
> remember all these instructions for the exam. Please let me know.
|||Agree!
70-431 was mutch easier that 70-228/70-229 and 70-028/029
but the follow ups 70-441/70-442 and 70-443/70-444
are more complicated that SQL2000 or SQL7 exams
what is good - You can optain quite easyly MCTS SQL2005
What I can recomment - for repeating, self training and getting the point of
real tests - go thorugh some preparation provider material (measureup or
something like)
But the main point is - You dont know exact syntacs or exact options for
every single thing (I don't know for example and in real life BOL is always
opened on my hand, during work, during traiining etc - unfortunately not
allowed during exams )
You have to know and understand the principles of things. The structure, the
goal, the reason and the target of sql sentences.
As I remember - there wasn't so much in 431 about performance stuff
With bests
Henn
PS! Let me know when You pass the 431
"jason" <jason-r3move@.statisticsio.com> kirjutas snumis
news:93A5B69C-EA5B-4269-9C70-6D3B7EDE0E5F@.microsoft.com...
> If you learn it, you don't have to remember it On top of that, I think
> it is an easier test than 7.0 or 2000. Just practice and understand why
> and you will be fine.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
> "lrantisi" <lrantisi@.gmail.com> wrote in message
> news:b833a574-8d18-4b79-9498-b84df470ec14@.e23g2000prf.googlegroups.com...
>
sql

MaximumErrorCount

Trying to find MaximumErrorCount. May anyone explain me, what is it and
where is it? What program should be invoked, what menu commands used? I can
find a task in SQL Agent, but I have no idea how to force it ignore
nonexistent errors.
Yours faithfully, Vadim Maksimenko.
Hi Vadim Maksimenko
I assume this is a data pump task in a DTS package? In which case check out
information on error handling in
http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
John
"Vadim Maksimenko" wrote:

> Trying to find MaximumErrorCount. May anyone explain me, what is it and
> where is it? What program should be invoked, what menu commands used? I can
> find a task in SQL Agent, but I have no idea how to force it ignore
> nonexistent errors.
> --
> Yours faithfully, Vadim Maksimenko.
>
|||Thank you so much, but my problem is an attempt to use stupid Database Copy
Wizard from SQL Server 2005. It creates a task with is neither available for
editing nor accessible through Properties. Stupid, because it attempts to
copy views' contents!!! Could ignore that via setting MaximumErrorCount to
billions, but cannot locate that parameter.
Yours faithfully, Vadim Maksimenko.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...[vbcol=seagreen]
> Hi Vadim Maksimenko
> I assume this is a data pump task in a DTS package? In which case check
> out
> information on error handling in
> http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
> John
> "Vadim Maksimenko" wrote:
|||Hi Vadim Maksimenko
You can use the wizard to create a SSIS package which you can then change in
BIDS. Having the export as a package will also allow it to be run in a ad-hoc
manner using dtexec and give you the option to specify verbose logging.
John
"Vadim Maksimenko" wrote:

> Thank you so much, but my problem is an attempt to use stupid Database Copy
> Wizard from SQL Server 2005. It creates a task with is neither available for
> editing nor accessible through Properties. Stupid, because it attempts to
> copy views' contents!!! Could ignore that via setting MaximumErrorCount to
> billions, but cannot locate that parameter.
> --
> Yours faithfully, Vadim Maksimenko.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...
>
|||Already have found a better solution: MS SQL Maestro -- waaay much more
comfortable than original MS manager It does not force to look for brains
in the XXX in order to edit an SQL Agent job.
Yours faithfully, Vadim Maksimenko.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:97F23B99-5505-42B1-B17F-C534E0BBD15A@.microsoft.com...[vbcol=seagreen]
> Hi Vadim Maksimenko
> You can use the wizard to create a SSIS package which you can then change
> in
> BIDS. Having the export as a package will also allow it to be run in a
> ad-hoc
> manner using dtexec and give you the option to specify verbose logging.
> John
> "Vadim Maksimenko" wrote:
|||rHi
If SQL Maestro does it for you that's fine, but as I said it's nothing to do
with SQL Agent, so I am not surprised you couldn't find it.
John
"Vadim Maksimenko" wrote:

> Already have found a better solution: MS SQL Maestro -- waaay much more
> comfortable than original MS manager It does not force to look for brains
> in the XXX in order to edit an SQL Agent job.
> --
> Yours faithfully, Vadim Maksimenko.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:97F23B99-5505-42B1-B17F-C534E0BBD15A@.microsoft.com...
>
sql

MaximumErrorCount

Trying to find MaximumErrorCount. May anyone explain me, what is it and
where is it? What program should be invoked, what menu commands used? I can
find a task in SQL Agent, but I have no idea how to force it ignore
nonexistent errors.
--
Yours faithfully, Vadim Maksimenko.Hi Vadim Maksimenko
I assume this is a data pump task in a DTS package? In which case check out
information on error handling in
http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
John
"Vadim Maksimenko" wrote:
> Trying to find MaximumErrorCount. May anyone explain me, what is it and
> where is it? What program should be invoked, what menu commands used? I can
> find a task in SQL Agent, but I have no idea how to force it ignore
> nonexistent errors.
> --
> Yours faithfully, Vadim Maksimenko.
>|||Thank you so much, but my problem is an attempt to use stupid Database Copy
Wizard from SQL Server 2005. It creates a task with is neither available for
editing nor accessible through Properties. Stupid, because it attempts to
copy views' contents!!! Could ignore that via setting MaximumErrorCount to
billions, but cannot locate that parameter.
--
Yours faithfully, Vadim Maksimenko.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...
> Hi Vadim Maksimenko
> I assume this is a data pump task in a DTS package? In which case check
> out
> information on error handling in
> http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
> John
> "Vadim Maksimenko" wrote:
>> Trying to find MaximumErrorCount. May anyone explain me, what is it and
>> where is it? What program should be invoked, what menu commands used? I
>> can
>> find a task in SQL Agent, but I have no idea how to force it ignore
>> nonexistent errors.
>> --
>> Yours faithfully, Vadim Maksimenko.
>>|||Hi Vadim Maksimenko
You can use the wizard to create a SSIS package which you can then change in
BIDS. Having the export as a package will also allow it to be run in a ad-hoc
manner using dtexec and give you the option to specify verbose logging.
John
"Vadim Maksimenko" wrote:
> Thank you so much, but my problem is an attempt to use stupid Database Copy
> Wizard from SQL Server 2005. It creates a task with is neither available for
> editing nor accessible through Properties. Stupid, because it attempts to
> copy views' contents!!! Could ignore that via setting MaximumErrorCount to
> billions, but cannot locate that parameter.
> --
> Yours faithfully, Vadim Maksimenko.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...
> > Hi Vadim Maksimenko
> >
> > I assume this is a data pump task in a DTS package? In which case check
> > out
> > information on error handling in
> > http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
> >
> > John
> >
> > "Vadim Maksimenko" wrote:
> >
> >> Trying to find MaximumErrorCount. May anyone explain me, what is it and
> >> where is it? What program should be invoked, what menu commands used? I
> >> can
> >> find a task in SQL Agent, but I have no idea how to force it ignore
> >> nonexistent errors.
> >>
> >> --
> >>
> >> Yours faithfully, Vadim Maksimenko.
> >>
> >>
>|||Already have found a better solution: MS SQL Maestro -- waaay much more
comfortable than original MS manager :) It does not force to look for brains
in the ass in order to edit an SQL Agent job.
--
Yours faithfully, Vadim Maksimenko.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:97F23B99-5505-42B1-B17F-C534E0BBD15A@.microsoft.com...
> Hi Vadim Maksimenko
> You can use the wizard to create a SSIS package which you can then change
> in
> BIDS. Having the export as a package will also allow it to be run in a
> ad-hoc
> manner using dtexec and give you the option to specify verbose logging.
> John
> "Vadim Maksimenko" wrote:
>> Thank you so much, but my problem is an attempt to use stupid Database
>> Copy
>> Wizard from SQL Server 2005. It creates a task with is neither available
>> for
>> editing nor accessible through Properties. Stupid, because it attempts to
>> copy views' contents!!! Could ignore that via setting MaximumErrorCount
>> to
>> billions, but cannot locate that parameter.
>> --
>> Yours faithfully, Vadim Maksimenko.
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...
>> > Hi Vadim Maksimenko
>> >
>> > I assume this is a data pump task in a DTS package? In which case check
>> > out
>> > information on error handling in
>> > http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
>> >
>> > John
>> >
>> > "Vadim Maksimenko" wrote:
>> >
>> >> Trying to find MaximumErrorCount. May anyone explain me, what is it
>> >> and
>> >> where is it? What program should be invoked, what menu commands used?
>> >> I
>> >> can
>> >> find a task in SQL Agent, but I have no idea how to force it ignore
>> >> nonexistent errors.
>> >>
>> >> --
>> >>
>> >> Yours faithfully, Vadim Maksimenko.
>> >>
>> >>
>>|||rHi
If SQL Maestro does it for you that's fine, but as I said it's nothing to do
with SQL Agent, so I am not surprised you couldn't find it.
John
"Vadim Maksimenko" wrote:
> Already have found a better solution: MS SQL Maestro -- waaay much more
> comfortable than original MS manager :) It does not force to look for brains
> in the ass in order to edit an SQL Agent job.
> --
> Yours faithfully, Vadim Maksimenko.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:97F23B99-5505-42B1-B17F-C534E0BBD15A@.microsoft.com...
> > Hi Vadim Maksimenko
> >
> > You can use the wizard to create a SSIS package which you can then change
> > in
> > BIDS. Having the export as a package will also allow it to be run in a
> > ad-hoc
> > manner using dtexec and give you the option to specify verbose logging.
> >
> > John
> >
> > "Vadim Maksimenko" wrote:
> >
> >> Thank you so much, but my problem is an attempt to use stupid Database
> >> Copy
> >> Wizard from SQL Server 2005. It creates a task with is neither available
> >> for
> >> editing nor accessible through Properties. Stupid, because it attempts to
> >> copy views' contents!!! Could ignore that via setting MaximumErrorCount
> >> to
> >> billions, but cannot locate that parameter.
> >>
> >> --
> >>
> >> Yours faithfully, Vadim Maksimenko.
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...
> >> > Hi Vadim Maksimenko
> >> >
> >> > I assume this is a data pump task in a DTS package? In which case check
> >> > out
> >> > information on error handling in
> >> > http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
> >> >
> >> > John
> >> >
> >> > "Vadim Maksimenko" wrote:
> >> >
> >> >> Trying to find MaximumErrorCount. May anyone explain me, what is it
> >> >> and
> >> >> where is it? What program should be invoked, what menu commands used?
> >> >> I
> >> >> can
> >> >> find a task in SQL Agent, but I have no idea how to force it ignore
> >> >> nonexistent errors.
> >> >>
> >> >> --
> >> >>
> >> >> Yours faithfully, Vadim Maksimenko.
> >> >>
> >> >>
> >>
> >>
>