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

Maximum Memory Configurations

What is the maximum amount of memory SQL2K can address per instance using the following configuration
WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
AWE Enabled
/PAE switch in boot.ini
Lock pages in memory enabled for MSSQL Service Account.
The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K Advanced Server but has no mention of max memory allowed.
It is my understanding that each instance will be able to use all of its =
addressable RAM. In your scenario you could configure three instances =
to use 8GB of RAM and you could have a fourth using 4GB of RAM. That =
would allow 4GB of free memory for the OS to work with. Of course you =
could install more instances, but you would want to limit the amount of =
RAM each uses so that you do not run into problems by trying to allocate =
more memory than you have in the server.=20
--=20
Keith
"Douglas Luke" <anonymous@.discussions.microsoft.com> wrote in message =
news:D6F9605B-497D-49C6-9BED-FF0B19B83BC9@.microsoft.com...
> What is the maximum amount of memory SQL2K can address per instance =
using the following configuration
>=20
> WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
> SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
> AWE Enabled
> /PAE switch in boot.ini
> Lock pages in memory enabled for MSSQL Service Account.
>=20
> The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K =
Advanced Server but has no mention of max memory allowed.

Maximum Memory Configurations

What is the maximum amount of memory SQL2K can address per instance using the following configuratio
WIN 2003 32 bit Enterprise Edition OS with 32 GB RA
SQL2K SP3 32 bit Enterprise Edition w/ hot fixe
AWE Enable
/PAE switch in boot.in
Lock pages in memory enabled for MSSQL Service Account
The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K Advanced Server but has no mention of max memory allowed.It is my understanding that each instance will be able to use all of its =addressable RAM. In your scenario you could configure three instances =to use 8GB of RAM and you could have a fourth using 4GB of RAM. That =would allow 4GB of free memory for the OS to work with. Of course you =could install more instances, but you would want to limit the amount of =RAM each uses so that you do not run into problems by trying to allocate =more memory than you have in the server.
-- Keith
"Douglas Luke" <anonymous@.discussions.microsoft.com> wrote in message =news:D6F9605B-497D-49C6-9BED-FF0B19B83BC9@.microsoft.com...
> What is the maximum amount of memory SQL2K can address per instance =using the following configuration
> > WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
> SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
> AWE Enabled
> /PAE switch in boot.ini
> Lock pages in memory enabled for MSSQL Service Account.
> > The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K =Advanced Server but has no mention of max memory allowed.

Maximum Memory Configurations

What is the maximum amount of memory SQL2K can address per instance using th
e following configuration
WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
AWE Enabled
/PAE switch in boot.ini
Lock pages in memory enabled for MSSQL Service Account.
The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K Advanced Se
rver but has no mention of max memory allowed.It is my understanding that each instance will be able to use all of its =
addressable RAM. In your scenario you could configure three instances =
to use 8GB of RAM and you could have a fourth using 4GB of RAM. That =
would allow 4GB of free memory for the OS to work with. Of course you =
could install more instances, but you would want to limit the amount of =
RAM each uses so that you do not run into problems by trying to allocate =
more memory than you have in the server.=20
--=20
Keith
"Douglas Luke" <anonymous@.discussions.microsoft.com> wrote in message =
news:D6F9605B-497D-49C6-9BED-FF0B19B83BC9@.microsoft.com...
> What is the maximum amount of memory SQL2K can address per instance =
using the following configuration
>=20
> WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
> SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
> AWE Enabled
> /PAE switch in boot.ini
> Lock pages in memory enabled for MSSQL Service Account.
>=20
> The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K =
Advanced Server but has no mention of max memory allowed.