article on Windows 2003 + sql

I came across an article long time ago and cannot seem to track it now.
It talked about the advantages of migrating your SQL 2000 from Windows 2000
to windows 2003.
Can someone who knows about this, send me a linkHi
I don't know of any SQL Server specific articles, but you will gain all the
generic advantages from using this version:
Top 10:
http://tinyurl.com/bqnx
Why upgrade:
http://tinyurl.com/2u2j9
Performance comparison:
http://tinyurl.com/x7ma
Upgrade site:
http://tinyurl.com/2yhgj
Analyst reports:
http://tinyurl.com/8fnxj
Background:
http://tinyurl.com/adhaf
John
"Hassan" wrote:
> I came across an article long time ago and cannot seem to track it now.
> It talked about the advantages of migrating your SQL 2000 from Windows 2000
> to windows 2003.
> Can someone who knows about this, send me a link
>
>

article on Windows 2003 + sql

I came across an article long time ago and cannot seem to track it now.
It talked about the advantages of migrating your SQL 2000 from Windows 2000
to windows 2003.
Can someone who knows about this, send me a link
Hi
I don't know of any SQL Server specific articles, but you will gain all the
generic advantages from using this version:
Top 10:
http://tinyurl.com/bqnx
Why upgrade:
http://tinyurl.com/2u2j9
Performance comparison:
http://tinyurl.com/x7ma
Upgrade site:
http://tinyurl.com/2yhgj
Analyst reports:
http://tinyurl.com/8fnxj
Background:
http://tinyurl.com/adhaf
John
"Hassan" wrote:

> I came across an article long time ago and cannot seem to track it now.
> It talked about the advantages of migrating your SQL 2000 from Windows 2000
> to windows 2003.
> Can someone who knows about this, send me a link
>
>

article on Windows 2003 + sql

I came across an article long time ago and cannot seem to track it now.
It talked about the advantages of migrating your SQL 2000 from Windows 2000
to windows 2003.
Can someone who knows about this, send me a linkHi
I don't know of any SQL Server specific articles, but you will gain all the
generic advantages from using this version:
Top 10:
http://tinyurl.com/bqnx
Why upgrade:
http://tinyurl.com/2u2j9
Performance comparison:
http://tinyurl.com/x7ma
Upgrade site:
http://tinyurl.com/2yhgj
Analyst reports:
http://tinyurl.com/8fnxj
Background:
http://tinyurl.com/adhaf
John
"Hassan" wrote:

> I came across an article long time ago and cannot seem to track it now.
> It talked about the advantages of migrating your SQL 2000 from Windows 200
0
> to windows 2003.
> Can someone who knows about this, send me a link
>
>

Are Population Schedules required?

Hi All: I have an FT Cat with 3 tables in it that I created 6 months ago.
Each table in the FT Cat has "track changes" set to "automatic"
There's no defined population schedule.
Will this catalog be updated automatically when the data in the tables
changes, or does it require a population schedule to regularly refresh the
FT Catalog?
TIA
It will be updated within seconds - change tracking updates the index near
real time.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"geek-y-guy" <noone@.nowhere.org> wrote in message
news:%23rTq57VQHHA.3460@.TK2MSFTNGP03.phx.gbl...
> Hi All: I have an FT Cat with 3 tables in it that I created 6 months ago.
> Each table in the FT Cat has "track changes" set to "automatic"
> There's no defined population schedule.
> Will this catalog be updated automatically when the data in the tables
> changes, or does it require a population schedule to regularly refresh the
> FT Catalog?
> TIA
>
>
|||Thanks Hilary!
So, just for my edification, what are population schedules for? For very
large cats & datasets where you would NOT want it automatically updating,
but would want to schedule repopulation say once daily at 3 am?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OshsXadQHHA.4276@.TK2MSFTNGP02.phx.gbl...
> It will be updated within seconds - change tracking updates the index near
> real time.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "geek-y-guy" <noone@.nowhere.org> wrote in message
> news:%23rTq57VQHHA.3460@.TK2MSFTNGP03.phx.gbl...
>
|||Hello geek-y-guy,
Historically in SQL 2000, populations could impact querying (errors occurring)
so you may have wanted to do delay the population.
If you have lots of changes you may still want to delay population to avoid
the performance hit of population and querying
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> Thanks Hilary!
> So, just for my edification, what are population schedules for? For
> very large cats & datasets where you would NOT want it automatically
> updating, but would want to schedule repopulation say once daily at 3
> am?
>
|||In general you should always use change tracking as it offers best
performance and near real time indexing. If you select manual change
tracking you can update the index during quiet times or in batches to
minimize the impact of locking during indexing.
There are two other indexing options: full-populations and incremental
populations. If the bulk of your data changes in regular patterns you might
want to schedule a full-population. Incremental populations work best when a
smaller portion of your data changes at a time. In this case you could
schedule an incremental population.
As change tracking can lead to some fragmentation you might want to schedule
the reorganization of your catalog.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"geek-y-guy" <noone@.nowhere.org> wrote in message
news:%230E6UWkQHHA.4448@.TK2MSFTNGP04.phx.gbl...
> Thanks Hilary!
> So, just for my edification, what are population schedules for? For very
> large cats & datasets where you would NOT want it automatically updating,
> but would want to schedule repopulation say once daily at 3 am?
> --
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OshsXadQHHA.4276@.TK2MSFTNGP02.phx.gbl...
>