Maintenance plan

Can somebody provide more information about how to setup maitenance plan or
there is any white paper?
Thanks.Check the article at
http://www.sql-server-performance.com/ak_inside_sql_server_maintenance_plans.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"NickT" <NickT@.discussions.microsoft.com> wrote in message
news:CD69F721-C590-4D7F-AFD7-31138ABEA4C3@.microsoft.com...
> Can somebody provide more information about how to setup maitenance plan
or
> there is any white paper?
> Thanks.|||Hello
There is a section in the SQL 7 Backup/Restore Whitepaper that talks about
the maintenance plan -
http://www.microsoft.com/downloads/details.aspx?FamilyID=cb603365-f15f-433e-
8909-172e2347e461&DisplayLang=en
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

mail merge problem

Hi there,
maybe you can help me. is there way to
skip lines in the mail sticker? we
are using 20 mail stickers/page paper and
usually the user uses only 4-5 stickers
we want to maximize the use of the unprinted
stickers is there way to skip the already
printed sticker by passing parameter "no. of skips"?
we are connected to an oracle database and uses
pl-sql with cursor ref.
thanks.Maybe you could just put something in the report header to skip the relevant amount of space. Here's two things I can think of:
1) A formula that writes 'n' * 'parameter' empty lines, assuming you can exactly match 'n' lines to a sticker.
2) An 'empty' sticker in a subreport, and force 'parameter' detail records to skip the space by using the command statement
select * from (select level from dual connect by level <= {?parameter})

(Beware, DO NOT run that statement without the <= clause!)|||thanks for your reply.
actually thats what i did below is current program running,
just asking maybe other solution by not doing this like for loop etc.

SELECT
FROM DUAL
where 1 <= p_noskip
union all
SELECT
FROM DUAL
where 2 <= p_noskip
union all
SELECT
FROM DUAL
where <till 19> <= p_noskip|||So replace those 19 unioned select from dual statements with one single statement:

select * from (select level from dual connect by level <= {?parameter})

Remember to create the parameter in the add command screen, not the field explorer/|||ThanksJagan, it works! I just added connect by level.
select '' from dual connect by level <= <parameter>|||Yeah, that'll work too - you don't need the extra select around the outside if you just want 'n' records as you do.
However, the nice thing about the full statement is that you get an ordered, contiguous set of values from 1..n
As level's a reserved word, I suppose it's more correct to actually write

select x from (select level as x from dual connect by level <= {?parameter})

so that you don't have to select * (literally, the * character)
If you write
select level from (select level from dual connect by level <= {?parameter})
then you find that you get 'parameter' records all with value 0

But hey, this is a Crystal forum not an Oracle one...but someone might find this useful...

Machine Specs

Hello,
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks.
"Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA
|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)

Machine Specs

Hello,
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks."Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>>Hello,
>>I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
>>a white paper or instructions on recommended hardware specs and/or
>>server 2003 tweaks?
>>Thanks.
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)

Machine Specs

Hello,
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks."Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)