good online resources for teaching SQL for SQL server 2000

my freind asked me to look for him for online book or something very good that teach SQL for SQL server 2000 ... what i need is something like hands on examples that will take user from level 1 to level * ... i have seen alot of stuff in google but i think some of you might know what i need and can direct me to better resources as i could not find someting specail !!!Try this link and check the side bar but the best remains download the eval version and use the BOL (books online). Hope this helps.
http://www.mssqlserver.com/tsql/|||thanks Caddre!!
when i see you reply ... i got a feeling that you will meet the expectation ... the link is really great !!
thanks again!

Good online resources

Hi,
I am a newbie in the world of the SQL server . However I have a
reasonable idea of SQL and a little bit of Oracle. Could you please suggest
some good online resources for me preferable starting from scratch... but
leading in real deep.
Anupam
--
We all want to destroy evil. But the line dividing evil and good is
insidiously hidden in each of our hearts and who wants to destroy a piece of
his own heartThere are lots of resources out there with a mixture of content difficulty
and area of specialisation
here is a good starter index for you
http://www.microsoft.com/sql/community/relcommunities.asp
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Anupam" <anupam_mukherjee@.persistent.co.in> wrote in message
news:uPh0E2vkDHA.2012@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am a newbie in the world of the SQL server . However I have a
> reasonable idea of SQL and a little bit of Oracle. Could you please
suggest
> some good online resources for me preferable starting from scratch... but
> leading in real deep.
> Anupam
> --
> We all want to destroy evil. But the line dividing evil and good is
> insidiously hidden in each of our hearts and who wants to destroy a piece
of
> his own heart
>|||See here for some links:
http://www.microsoft.com/sql/community/relcommunities.asp
Also, don't forget SQL's own essential help file, Books Online.
--
David Portas
--
Please reply only to the newsgroup
--
"Anupam" <anupam_mukherjee@.persistent.co.in> wrote in message
news:uPh0E2vkDHA.2012@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am a newbie in the world of the SQL server . However I have a
> reasonable idea of SQL and a little bit of Oracle. Could you please
suggest
> some good online resources for me preferable starting from scratch... but
> leading in real deep.
> Anupam
> --
> We all want to destroy evil. But the line dividing evil and good is
> insidiously hidden in each of our hearts and who wants to destroy a piece
of
> his own heart
>|||Hi,
Thanx guys for the info. Its highly appreciated.
Regards,
Anupam
--
We all want to destroy evil. But the line dividing evil and good is
insidiously hidden in each of our hearts and who wants to destroy a piece of
his own heart

Good AS/BI Resources

I'm new to these things and would like to get my hands on as many resources as I can. Can anyone recommed some good bloggers, forums, and sites that I could use to get better acclimated with AS/BI? Thanks!

Hi

Popular blogs: Mosha Pasumansky, Marco Russo,Darren Gosbell, Chris Web.

Thanks

Subhash Subramanyam

|||

Thanks Subhash, can anyone recommend any good forums? Aside from this one?

|||

Hi Alexander,

Visit Chris Web's Blogroll, you will find links to many blogs. so and so forth.

Thank

Subhash Subramanyam

Giving Active Queries Priority

Is there a way to give a particular query greater system resources,
such as share of the processor?

I have two queries that were started from Query Analyzer. One is very
long, the other rather short. However the long one is taking almost
all the processor resources and not allowing the short one to complete.
I'd like to allocate more of the processor to the short one until it
is done.

I am the admin on this system and have access to Enterprise Mgr.

Thanks.Hi

If you had multiple processors then you may want to look at the maxdop query
hint, or you may want to break your longer running query up so that other
activity can occur. You may also want to look at the query plan to see if
you can optimise the long running query or possibly re-architect the
database/system to remove the need for such intensive processing.

John

<sfarkas@.visa.com> wrote in message
news:1117592953.657773.238730@.o13g2000cwo.googlegr oups.com...
> Is there a way to give a particular query greater system resources,
> such as share of the processor?
> I have two queries that were started from Query Analyzer. One is very
> long, the other rather short. However the long one is taking almost
> all the processor resources and not allowing the short one to complete.
> I'd like to allocate more of the processor to the short one until it
> is done.
> I am the admin on this system and have access to Enterprise Mgr.
> Thanks.