proper time to shrink tempdb size?

hi,
working on sql server 2000.
Can you shrink tempdb's log and data file size at any time
during the day on production servers?
Will this impact other user's jobs on the server?
many thanks.
JJPlease don't post independently in multiple newsgroups. You can add the
other newsgroups in the "Newsgroups" section in the header and it will show
up in all those simultaneously as will the answers. See my reply in the
other newsgroup.
Andrew J. Kelly
SQL Server MVP
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:06b201c3a4da$e397ad60$a301280a@.phx.gbl...
> hi,
> working on sql server 2000.
> Can you shrink tempdb's log and data file size at any time
> during the day on production servers?
> Will this impact other user's jobs on the server?
> many thanks.
> JJ|||am I causing any problem this way? What's the difference
between the two ways?
Thanks.
JJ
>--Original Message--
>Please don't post independently in multiple newsgroups.
You can add the
>other newsgroups in the "Newsgroups" section in the
header and it will show
>up in all those simultaneously as will the answers. See
my reply in the
>other newsgroup.
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message
>news:06b201c3a4da$e397ad60$a301280a@.phx.gbl...
>> hi,
>> working on sql server 2000.
>> Can you shrink tempdb's log and data file size at any
time
>> during the day on production servers?
>> Will this impact other user's jobs on the server?
>> many thanks.
>> JJ
>
>.
>|||Hi JJ
There could be problems, or at least wasted time and fewer people getting
answers. If you post INDEPENDENTLY in separate newsgroups, someone could
answer you one place, and someone else could read your question in a
different group, and not know that you had already been answered. The
threads are kept completely separate., A second person could spend time
researcching and responding to a question that had already been answered.
This is wasting time they could have used to help somebody else.
If you list all the newsgroups in the header in one post, then any answer
posted in one newsgroup will be visible to people reading your question in
any of the included newsgroups.
Does that make sense?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:00f501c3a553$5bc5e3b0$a301280a@.phx.gbl...
> am I causing any problem this way? What's the difference
> between the two ways?
> Thanks.
> JJ
> >--Original Message--
> >
> >Please don't post independently in multiple newsgroups.
> You can add the
> >other newsgroups in the "Newsgroups" section in the
> header and it will show
> >up in all those simultaneously as will the answers. See
> my reply in the
> >other newsgroup.
> >
> >
> >
> >--
> >
> >Andrew J. Kelly
> >SQL Server MVP
> >
> >
> >"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:06b201c3a4da$e397ad60$a301280a@.phx.gbl...
> >> hi,
> >>
> >> working on sql server 2000.
> >>
> >> Can you shrink tempdb's log and data file size at any
> time
> >> during the day on production servers?
> >>
> >> Will this impact other user's jobs on the server?
> >>
> >> many thanks.
> >>
> >> JJ
> >
> >
> >.
> >|||Very well put Kalen... Thank you
--
Andrew J. Kelly
SQL Server MVP
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:%23BBKFdVpDHA.1020@.TK2MSFTNGP09.phx.gbl...
> Hi JJ
> There could be problems, or at least wasted time and fewer people getting
> answers. If you post INDEPENDENTLY in separate newsgroups, someone could
> answer you one place, and someone else could read your question in a
> different group, and not know that you had already been answered. The
> threads are kept completely separate., A second person could spend time
> researcching and responding to a question that had already been answered.
> This is wasting time they could have used to help somebody else.
> If you list all the newsgroups in the header in one post, then any answer
> posted in one newsgroup will be visible to people reading your question in
> any of the included newsgroups.
> Does that make sense?
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
> news:00f501c3a553$5bc5e3b0$a301280a@.phx.gbl...
> > am I causing any problem this way? What's the difference
> > between the two ways?
> >
> > Thanks.
> >
> > JJ
> > >--Original Message--
> > >
> > >Please don't post independently in multiple newsgroups.
> > You can add the
> > >other newsgroups in the "Newsgroups" section in the
> > header and it will show
> > >up in all those simultaneously as will the answers. See
> > my reply in the
> > >other newsgroup.
> > >
> > >
> > >
> > >--
> > >
> > >Andrew J. Kelly
> > >SQL Server MVP
> > >
> > >
> > >"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
> > message
> > >news:06b201c3a4da$e397ad60$a301280a@.phx.gbl...
> > >> hi,
> > >>
> > >> working on sql server 2000.
> > >>
> > >> Can you shrink tempdb's log and data file size at any
> > time
> > >> during the day on production servers?
> > >>
> > >> Will this impact other user's jobs on the server?
> > >>
> > >> many thanks.
> > >>
> > >> JJ
> > >
> > >
> > >.
> > >
>|||good to know. thank you for the pointers. never knew
about this until now. where can I go to find out more
tips like this? I think we should make this kind of rules
very visible for people so that there won't be any more
confusions like this.
JJ
>--Original Message--
>Very well put Kalen... Thank you
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Kalen Delaney" <replies@.public_newsgroups.com> wrote in
message
>news:%23BBKFdVpDHA.1020@.TK2MSFTNGP09.phx.gbl...
>> Hi JJ
>> There could be problems, or at least wasted time and
fewer people getting
>> answers. If you post INDEPENDENTLY in separate
newsgroups, someone could
>> answer you one place, and someone else could read your
question in a
>> different group, and not know that you had already been
answered. The
>> threads are kept completely separate., A second person
could spend time
>> researcching and responding to a question that had
already been answered.
>> This is wasting time they could have used to help
somebody else.
>> If you list all the newsgroups in the header in one
post, then any answer
>> posted in one newsgroup will be visible to people
reading your question in
>> any of the included newsgroups.
>> Does that make sense?
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "JJ Wang" <anonymous@.discussions.microsoft.com> wrote
in message
>> news:00f501c3a553$5bc5e3b0$a301280a@.phx.gbl...
>> > am I causing any problem this way? What's the
difference
>> > between the two ways?
>> >
>> > Thanks.
>> >
>> > JJ
>> > >--Original Message--
>> > >
>> > >Please don't post independently in multiple
newsgroups.
>> > You can add the
>> > >other newsgroups in the "Newsgroups" section in the
>> > header and it will show
>> > >up in all those simultaneously as will the answers.
See
>> > my reply in the
>> > >other newsgroup.
>> > >
>> > >
>> > >
>> > >--
>> > >
>> > >Andrew J. Kelly
>> > >SQL Server MVP
>> > >
>> > >
>> > >"JJ Wang" <anonymous@.discussions.microsoft.com>
wrote in
>> > message
>> > >news:06b201c3a4da$e397ad60$a301280a@.phx.gbl...
>> > >> hi,
>> > >>
>> > >> working on sql server 2000.
>> > >>
>> > >> Can you shrink tempdb's log and data file size at
any
>> > time
>> > >> during the day on production servers?
>> > >>
>> > >> Will this impact other user's jobs on the server?
>> > >>
>> > >> many thanks.
>> > >>
>> > >> JJ
>> > >
>> > >
>> > >.
>> > >
>>
>
>.
>|||today I followed your tip and posted one message with
multiple addresses to the group. One person answered me
in one group and also showed in the other, so this part
worked.
But when I answered back in one group, my answer didn't
get automatically posted in the other group. How come? I
sure hope this thing won't cause so much trouble for me.
JJ
>--Original Message--
>Very well put Kalen... Thank you
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Kalen Delaney" <replies@.public_newsgroups.com> wrote in
message
>news:%23BBKFdVpDHA.1020@.TK2MSFTNGP09.phx.gbl...
>> Hi JJ
>> There could be problems, or at least wasted time and
fewer people getting
>> answers. If you post INDEPENDENTLY in separate
newsgroups, someone could
>> answer you one place, and someone else could read your
question in a
>> different group, and not know that you had already been
answered. The
>> threads are kept completely separate., A second person
could spend time
>> researcching and responding to a question that had
already been answered.
>> This is wasting time they could have used to help
somebody else.
>> If you list all the newsgroups in the header in one
post, then any answer
>> posted in one newsgroup will be visible to people
reading your question in
>> any of the included newsgroups.
>> Does that make sense?
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "JJ Wang" <anonymous@.discussions.microsoft.com> wrote
in message
>> news:00f501c3a553$5bc5e3b0$a301280a@.phx.gbl...
>> > am I causing any problem this way? What's the
difference
>> > between the two ways?
>> >
>> > Thanks.
>> >
>> > JJ
>> > >--Original Message--
>> > >
>> > >Please don't post independently in multiple
newsgroups.
>> > You can add the
>> > >other newsgroups in the "Newsgroups" section in the
>> > header and it will show
>> > >up in all those simultaneously as will the answers.
See
>> > my reply in the
>> > >other newsgroup.
>> > >
>> > >
>> > >
>> > >--
>> > >
>> > >Andrew J. Kelly
>> > >SQL Server MVP
>> > >
>> > >
>> > >"JJ Wang" <anonymous@.discussions.microsoft.com>
wrote in
>> > message
>> > >news:06b201c3a4da$e397ad60$a301280a@.phx.gbl...
>> > >> hi,
>> > >>
>> > >> working on sql server 2000.
>> > >>
>> > >> Can you shrink tempdb's log and data file size at
any
>> > time
>> > >> during the day on production servers?
>> > >>
>> > >> Will this impact other user's jobs on the server?
>> > >>
>> > >> many thanks.
>> > >>
>> > >> JJ
>> > >
>> > >
>> > >.
>> > >
>>
>
>.
>|||If the original post was to multiple groups and you use the Reply to Group
feature it should post to all the groups.
--
Andrew J. Kelly
SQL Server MVP
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:067b01c3aa48$46ed2620$a101280a@.phx.gbl...
> today I followed your tip and posted one message with
> multiple addresses to the group. One person answered me
> in one group and also showed in the other, so this part
> worked.
> But when I answered back in one group, my answer didn't
> get automatically posted in the other group. How come? I
> sure hope this thing won't cause so much trouble for me.
> JJ
> >--Original Message--
> >Very well put Kalen... Thank you
> >
> >--
> >
> >Andrew J. Kelly
> >SQL Server MVP
> >
> >
> >"Kalen Delaney" <replies@.public_newsgroups.com> wrote in
> message
> >news:%23BBKFdVpDHA.1020@.TK2MSFTNGP09.phx.gbl...
> >> Hi JJ
> >>
> >> There could be problems, or at least wasted time and
> fewer people getting
> >> answers. If you post INDEPENDENTLY in separate
> newsgroups, someone could
> >> answer you one place, and someone else could read your
> question in a
> >> different group, and not know that you had already been
> answered. The
> >> threads are kept completely separate., A second person
> could spend time
> >> researcching and responding to a question that had
> already been answered.
> >> This is wasting time they could have used to help
> somebody else.
> >>
> >> If you list all the newsgroups in the header in one
> post, then any answer
> >> posted in one newsgroup will be visible to people
> reading your question in
> >> any of the included newsgroups.
> >>
> >> Does that make sense?
> >>
> >> --
> >> HTH
> >> --
> >> Kalen Delaney
> >> SQL Server MVP
> >> www.SolidQualityLearning.com
> >>
> >>
> >> "JJ Wang" <anonymous@.discussions.microsoft.com> wrote
> in message
> >> news:00f501c3a553$5bc5e3b0$a301280a@.phx.gbl...
> >> > am I causing any problem this way? What's the
> difference
> >> > between the two ways?
> >> >
> >> > Thanks.
> >> >
> >> > JJ
> >> > >--Original Message--
> >> > >
> >> > >Please don't post independently in multiple
> newsgroups.
> >> > You can add the
> >> > >other newsgroups in the "Newsgroups" section in the
> >> > header and it will show
> >> > >up in all those simultaneously as will the answers.
> See
> >> > my reply in the
> >> > >other newsgroup.
> >> > >
> >> > >
> >> > >
> >> > >--
> >> > >
> >> > >Andrew J. Kelly
> >> > >SQL Server MVP
> >> > >
> >> > >
> >> > >"JJ Wang" <anonymous@.discussions.microsoft.com>
> wrote in
> >> > message
> >> > >news:06b201c3a4da$e397ad60$a301280a@.phx.gbl...
> >> > >> hi,
> >> > >>
> >> > >> working on sql server 2000.
> >> > >>
> >> > >> Can you shrink tempdb's log and data file size at
> any
> >> > time
> >> > >> during the day on production servers?
> >> > >>
> >> > >> Will this impact other user's jobs on the server?
> >> > >>
> >> > >> many thanks.
> >> > >>
> >> > >> JJ
> >> > >
> >> > >
> >> > >.
> >> > >
> >>
> >>
> >
> >
> >.
> >