70-431 SQL Server 2005 exam

hi there,

i am planning to take the exam 70431 for sql server 2005 ...does any one have a good exam and course material either online or it will be great if it could be emailed to me.

Thanks in advance

You can google Sql Server 2005 exam materials from website and will get a lot.Besides this,SQL Server 2005 online help is a good one for you.

|||

i tried already !!

i could not see FREE material there either exam or course material ... if you get luck in google :) ...please send me the links

Thanks for the reply

|||

If you are not in a hurry the book used by SQL Server people is by Robert Vierra but if you are take the second link and fill it in as the third link is from MSDN and you have a study guide or just print it out with the developer edition or Enterprise installed run searches in the BOL. And remember to understand the recursive trigger because Microsoft is known to give you four almost identical triggers with nothing more than space missing. And the index structure have changed know the whole thing because indexes are vendors creations all improvements are very important, when you are through with the material get Transcenders exams because the material is not the exam. If you know how to take the exam you are almost there. Hope this helps.

http://www.amazon.com/gp/product/0764584340/002-6732392-4240017?v=glance&n=283155

http://www.microsoft.com/learning/exams/70-431.asp

http://www.codeclinic.com/70-229skills.htm

64-bit MSDE?

I've seen references in Microsoft online material to a 64-bit
edition of MSDE - the description of Windows XP 64-bit
Edition Version 2003 refers to it, for example. However,
I haven't been able to find any more information about the
existence, if any, and availability of 64-bit MSDE. I'm
specifically intererested in determining whether it's
available for the server operating system editions .
Can anyone help?
Thanks,
Peter Hornby
Unisys Corporation
Mission Viejo
hi Peter,
"Pete Hornby" <peter.hornby@.unisys.com> ha scritto nel messaggio
news:umltR66KEHA.644@.tk2msftngp13.phx.gbl...
> I've seen references in Microsoft online material to a 64-bit
> edition of MSDE - the description of Windows XP 64-bit
> Edition Version 2003 refers to it, for example. However,
> I haven't been able to find any more information about the
> existence, if any, and availability of 64-bit MSDE. I'm
> specifically intererested in determining whether it's
> available for the server operating system editions .
AFAIK, only the Enterprise Edition is available in the 64bit flavour..
http://www.microsoft.com/sql/evaluat...ew/default.asp and
http://www.microsoft.com/sql/64bit/default.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:c6jga9$cocpm$1@.ID-207518.news.uni-berlin.de...
> hi Peter,
> "Pete Hornby" <peter.hornby@.unisys.com> ha scritto nel messaggio
> news:umltR66KEHA.644@.tk2msftngp13.phx.gbl...
> AFAIK, only the Enterprise Edition is available in the 64bit flavour..
> http://www.microsoft.com/sql/evaluat...ew/default.asp and
> http://www.microsoft.com/sql/64bit/default.asp
Andrea,
Many thanks for your quick response. I accept what you say, but I
remain confused by the statement - admittedly a year old - in
http://www.microsoft.com/windowsxp/6...uation/faq.asp
where the answer to "What's New In Windows XP 64-Bit Edition
Version 2003" includes the line "Microsoft SQL Server Desktop
Engine (MSDE)".
Peter
|||hi Peter,
"Pete Hornby" <peter.hornby@.unisys.com> ha scritto nel messaggio
news:c6jll6$17ca$1@.si05.rsvl.unisys.com...
> Many thanks for your quick response. I accept what you say, but I
> remain confused by the statement - admittedly a year old - in
> http://www.microsoft.com/windowsxp/6...uation/faq.asp
> where the answer to "What's New In Windows XP 64-Bit Edition
> Version 2003" includes the line "Microsoft SQL Server Desktop
> Engine (MSDE)".
as IIS 6.0, I think that MSDE 2000 will be (or is) provided in the 32bit
flavour =:-)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply