Another Newbie questions

Hi,
Do i need to populate the Full-Text catalog and Full-Text Index both in
order to get the most updated data? I thougth all I need to do is to
populate the Full-Text Index, if so, what is the reason to populate the
catalog, too?
If I need to populate both, do i have to populate the catalog first, then
Index?
Thanks for any explaination
Ed
Ed,
I guess the answer is both, but not because there are *two* objects, but
because often these terms are used interchangeable. See SQL Server 2000 BOL
(Books online) title "Full-Text Indexes" for more details on the differences
between "Full-text indexes" and "Regular SQL indexes" as well as BOL title
"Full-Text Catalogs and Indexes".
Specifically, you *populate* a FT Catalog via sp_fulltext_catalog
(start_full) as you can have more than one table per FT Catalog. However,
you set "Change Tracking" and "Update Index in Background" at the
table-level via sp_fulltext_table (start_change_tracking).
Hope this helps!
John
"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:BB2E4741-C0D9-42C0-9B45-0802987E3DA8@.microsoft.com...
> Hi,
> Do i need to populate the Full-Text catalog and Full-Text Index both in
> order to get the most updated data? I thougth all I need to do is to
> populate the Full-Text Index, if so, what is the reason to populate the
> catalog, too?
> If I need to populate both, do i have to populate the catalog first, then
> Index?
> Thanks for any explaination
> Ed
|||A catalog may index one or more tables. If you are only indexing one table,
it makes no difference when you run a full population on the catalog or on
the index.
If you are indexing multiple tables, you should run a full popluation on a
table basis for performance reasons. In other words, it will be faster and
you will get better performance when run populations on a per table basis.
In general you should place index each table its own catalog as MSSearch
(the engine which does the indexing) allocates threads on a per catalog
basis. So the more catalogs you have the more threads there will be
servicing your indexing and querying processes. However, there will be
greater overheard with the larger number of threads and catalogs.
Even so if you are indexing large tables you can get performance increases
by splitting the table up into pieces/child table (this process is called
partitioning) and having a seperate catalog for each child table.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:BB2E4741-C0D9-42C0-9B45-0802987E3DA8@.microsoft.com...
> Hi,
> Do i need to populate the Full-Text catalog and Full-Text Index both in
> order to get the most updated data? I thougth all I need to do is to
> populate the Full-Text Index, if so, what is the reason to populate the
> catalog, too?
> If I need to populate both, do i have to populate the catalog first, then
> Index?
> Thanks for any explaination
> Ed

Another Newbie Question (about queries)

I'm moving things from Access to SQL Server. What do I do with queries? I'm
using Access 2000 to access Sql Server, and there doesn't seem to be
anything for queries.

Does SQL Server have queries, or are they just done in the page code (to
access data on a website)?

I also have a trial version of Enterprise Manager, but I can't figure out
how to connect. If that would show queries.

Thanks

JAQueries would be either Views or Stored Procedures in your SQL database.
Normally Views are for select statement and the rest you would use Stored
Procedures.

When you open SQL Enterprise Manager you need to expand on the left
pane until you open your local server, databases and access your database.

SQL Query Analyzer is where you can execute SQL code for example
SELECT statements and see the result there.

> I'm moving things from Access to SQL Server. What do I do with queries?
I'm
> using Access 2000 to access Sql Server, and there doesn't seem to be
> anything for queries.
> Does SQL Server have queries, or are they just done in the page code (to
> access data on a website)?
> I also have a trial version of Enterprise Manager, but I can't figure out
> how to connect. If that would show queries.

Another newbie question

What is the role of the SQL agent and what is the difference whether it will
run automatically or manually (I am trying to run the replication wizard)
Thanks,
Shmuel
There are several agents associated with replication and they are
essentially jobs fundamental to replication. Have a look in BOL for
replication,agents for a description of each agent. Running continuously
will help you work with miniumum latency, but you will not then have control
over when the load is placed on your server, and connectivity is mandatory.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||i'm kinda new at this too... but it seems to me that automatic means the same thing as scheduled... you can have it run once a day at a certain time, etc... manual means you want to control if and when it runs.
Andrea Garcia
Yahoo IM: mmmmojobootay
CS degree arriving in: July 2005
www.millionformarriage.com
"S Shulman" <smshulman@.hotmail.com> wrote in message news:uQ8Z4J0IFHA.2648@.TK2MSFTNGP14.phx.gbl...
What is the role of the SQL agent and what is the difference whether it will
run automatically or manually (I am trying to run the replication wizard)
Thanks,
Shmuel
|||sql server agent is the component of sql server which runs all of your
jobs. If you configure it to run automatically it will start whenever
you reboot your machine. If you configure it to run manually you will
have to manually start it.
S Shulman wrote:
> What is the role of the SQL agent and what is the difference whether it will
> run automatically or manually (I am trying to run the replication wizard)
> Thanks,
> Shmuel
>

ANOTHER NEWBIE QUESTION

Can someone tell me the Transact-SQl equivalent of any of these:

IF INSERTING ...
IF DELETING ...
IF UPDATING ...

TIA
Allan M. Hart"Allan Hart" <allan.hart@.mnsu.edu> wrote in message news:<bqe8qk$1ch$1@.nitrogen.mnsu.edu>...
> Can someone tell me the Transact-SQl equivalent of any of these:
> IF INSERTING ...
> IF DELETING ...
> IF UPDATING ...
> TIA
> Allan M. Hart

I don't know what that syntax means, but I guess it's from trigger
code in another product, to identify the firing action? If so, then
one approach in MSSQL is to check for the existence of rows in the
inserted and deleted tables:

/* INSERT */
if exists (select * from inserted)
and not exists (select * from deleted)

/* DELETE */
if not exists (select * from inserted)
and exists (select * from deleted)

/* UPDATE */
if exists (select * from inserted)
and exists (select * from deleted)

Simon|||To add to Simon's response, you won't be able to infer the statement type
when no rows are affected by the statement firing the trigger.

/* UNKNOWN */
if not exists (select * from inserted)
and not exists (select * from deleted)

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Allan Hart" <allan.hart@.mnsu.edu> wrote in message
news:bqe8qk$1ch$1@.nitrogen.mnsu.edu...
> Can someone tell me the Transact-SQl equivalent of any of these:
> IF INSERTING ...
> IF DELETING ...
> IF UPDATING ...
> TIA
> Allan M. Hart|||Simon Hayes wrote:
> "Allan Hart" <allan.hart@.mnsu.edu> wrote in message news:<bqe8qk$1ch$1@.nitrogen.mnsu.edu>...
>>Can someone tell me the Transact-SQl equivalent of any of these:
>>
>>IF INSERTING ...
>>IF DELETING ...
>>IF UPDATING ...
>>
>>TIA
>>Allan M. Hart
>
> I don't know what that syntax means, but I guess it's from trigger
> code in another product, to identify the firing action? If so, then
> one approach in MSSQL is to check for the existence of rows in the
> inserted and deleted tables:
> Simon
It is likely from Oracle and it is based upon the abilty to write a
single trigger that contains within itself the ability to detect if the
the triggering actions as an insert, update, or delete.

--
Daniel Morgan
http://www.outreach.washington.edu/...oad/oad_crs.asp
http://www.outreach.washington.edu/...aoa/aoa_crs.asp
damorgan@.x.washington.edu
(replace 'x' with a 'u' to reply)

Another Newbie

Trying to insert into a field that is varchar(20) but I want to pad the
entry with "0" on the beginning of it... so if the item to be written is 10
chars long I want to write 10 "0" on the front of the item.. how to
accomplish?
Thanks
--
Austin Henderson <><
Network Administratorprint replicate('0',20 -len('microsoft')) + 'microsoft'
--
gani
"Austin Henderson" <kahenderson@.firstfleetinc.NOSPAM.com> wrote in message
news:u06WsobcDHA.652@.tk2msftngp13.phx.gbl...
> Trying to insert into a field that is varchar(20) but I want to pad the
> entry with "0" on the beginning of it... so if the item to be written is
10
> chars long I want to write 10 "0" on the front of the item.. how to
> accomplish?
> Thanks
>
> --
> Austin Henderson <><
> Network Administrator
>|||Got it THANKS!
--
Austin Henderson <><
Network Administrator
"gani" <a@.a.com> wrote in message
news:Ow8oA5bcDHA.1540@.tk2msftngp13.phx.gbl...
> print replicate('0',20 -len('microsoft')) + 'microsoft'
> --
> gani
>
>
> "Austin Henderson" <kahenderson@.firstfleetinc.NOSPAM.com> wrote in message
> news:u06WsobcDHA.652@.tk2msftngp13.phx.gbl...
> > Trying to insert into a field that is varchar(20) but I want to pad the
> > entry with "0" on the beginning of it... so if the item to be written is
> 10
> > chars long I want to write 10 "0" on the front of the item.. how to
> > accomplish?
> >
> > Thanks
> >
> >
> > --
> > Austin Henderson <><
> > Network Administrator
> >
> >
>

Analysis Services 2005 Newbie Question

I can't seem to find an analysis services newsgroup. Just getting started
with Analysis Services. In my first cube I have a table
of cases broken down by geographical area. I am looking at it in the browser
and I have regions along the top with sums in each column. But regions do
not show up if they have no cases. Is there any way to force SSAS to display
all regions with zero for no cases. Regards, Chris.Hi Bob
Unfortunately I can't answer your question, but if no one else gives you are
reply try posting in microsoft.public.sqlserver.olap
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.olap
John
"Fresno Bob" wrote:
> I can't seem to find an analysis services newsgroup. Just getting started
> with Analysis Services. In my first cube I have a table
> of cases broken down by geographical area. I am looking at it in the browser
> and I have regions along the top with sums in each column. But regions do
> not show up if they have no cases. Is there any way to force SSAS to display
> all regions with zero for no cases. Regards, Chris.
>
>