is it possible to re-build index without logging?

nt5, sql2k
i have a vendor application on one of my sql servers.
this application has many tables, and each tables have many indexes. it's
very write intensive (because when a record is inserted, it's insereted to
many many other tables, and that behavior can't be changed). the problem is
page split happened often, but when i tried to reindex tables once a week,
the log file run out of space.
can anyone offers some good solutions to my problem?
thank you!!
Steve
You can try changing the recovery mode to Bulk Logged or Simple and see if
that helps. Do only a few tables at a time and backup the log in between.
Andrew J. Kelly SQL MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:#otAPXEGEHA.3288@.TK2MSFTNGP12.phx.gbl...
> nt5, sql2k
>
> i have a vendor application on one of my sql servers.
> this application has many tables, and each tables have many indexes. it's
> very write intensive (because when a record is inserted, it's insereted to
> many many other tables, and that behavior can't be changed). the problem
is
> page split happened often, but when i tried to reindex tables once a week,
> the log file run out of space.
>
> can anyone offers some good solutions to my problem?
> thank you!!
>
> Steve
>
|||as i said, the database is write intensive. so simple recovery mode might be
too risky. is there a way to run a scheduled re-index job as a non-logged
operation?
thank you so much for the help.
steve
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:ujUS9aFGEHA.2876@.TK2MSFTNGP09.phx.gbl...
> You can try changing the recovery mode to Bulk Logged or Simple and see if
> that helps. Do only a few tables at a time and backup the log in between.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:#otAPXEGEHA.3288@.TK2MSFTNGP12.phx.gbl...
it's
to
> is
week,
>
|||Checkout DBCC INDEXDEFRAG, which does online defragmentation. You can look
in BOL for details. There's also an excellent whitepaper at
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
which will give you a bunch of details, hints, and explanations - including
working out whether you even need to bother getting rid of fragmentation,
based on your workload.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:eDkxfqPGEHA.3324@.TK2MSFTNGP09.phx.gbl...
> as i said, the database is write intensive. so simple recovery mode might
be
> too risky. is there a way to run a scheduled re-index job as a non-logged
> operation?
> thank you so much for the help.
> steve
> "Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
> news:ujUS9aFGEHA.2876@.TK2MSFTNGP09.phx.gbl...
if
between.
> it's
insereted
> to
problem
> week,
>

is it possible to re-build index without logging?

nt5, sql2k
i have a vendor application on one of my sql servers.
this application has many tables, and each tables have many indexes. it's
very write intensive (because when a record is inserted, it's insereted to
many many other tables, and that behavior can't be changed). the problem is
page split happened often, but when i tried to reindex tables once a week,
the log file run out of space.
can anyone offers some good solutions to my problem?
thank you!!
SteveYou can try changing the recovery mode to Bulk Logged or Simple and see if
that helps. Do only a few tables at a time and backup the log in between.
Andrew J. Kelly SQL MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:#otAPXEGEHA.3288@.TK2MSFTNGP12.phx.gbl...
> nt5, sql2k
>
> i have a vendor application on one of my sql servers.
> this application has many tables, and each tables have many indexes. it's
> very write intensive (because when a record is inserted, it's insereted to
> many many other tables, and that behavior can't be changed). the problem
is
> page split happened often, but when i tried to reindex tables once a week,
> the log file run out of space.
>
> can anyone offers some good solutions to my problem?
> thank you!!
>
> Steve
>|||as i said, the database is write intensive. so simple recovery mode might be
too risky. is there a way to run a scheduled re-index job as a non-logged
operation?
thank you so much for the help.
steve
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:ujUS9aFGEHA.2876@.TK2MSFTNGP09.phx.gbl...
> You can try changing the recovery mode to Bulk Logged or Simple and see if
> that helps. Do only a few tables at a time and backup the log in between.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:#otAPXEGEHA.3288@.TK2MSFTNGP12.phx.gbl...
it's
to
> is
week,
>|||Checkout DBCC INDEXDEFRAG, which does online defragmentation. You can look
in BOL for details. There's also an excellent whitepaper at
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
which will give you a bunch of details, hints, and explanations - including
working out whether you even need to bother getting rid of fragmentation,
based on your workload.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:eDkxfqPGEHA.3324@.TK2MSFTNGP09.phx.gbl...
> as i said, the database is write intensive. so simple recovery mode might
be
> too risky. is there a way to run a scheduled re-index job as a non-logged
> operation?
> thank you so much for the help.
> steve
> "Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
> news:ujUS9aFGEHA.2876@.TK2MSFTNGP09.phx.gbl...
if
between.
> it's
insereted
> to
problem
> week,
>sql

Is it possible to merge continuously between 8am and 5pm?

I have servers in a merge scenario that replicate every ten minutes. When
changes occur, they need to replicate fairly quickly (within 30 minutes),
but changes may not occur in every hour.
I think it would be most efficient to run continuous rather than every 10
minutes. However, I would really like replication to not be running at all
outside of the 8am-5pm window. Is it possible to have continuous
replication, but only from 8am to 5pm? The SQL Enterprise Manager does not
seem to allow for it.
Rob Kraft
Sure. Add a job that runs at 8AM and again at 5PM. What does this job do?
It changes the schedule on the replication job.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
sql

is it possible to grab data from 2 different databases

Hello-

I have a chart I am producing in .net and I need to values. The problem is the values (sums) i need are on 2 different servers. Is there any where to combine the query using two databases? Does anyone have any suggestions?

thanksYou may try to use something like:

"SELECT a.*, b.* FROM DB1..TableA a INNER JOIN DB2..TableB b ON a.WhatID = b.WhatID"

Regards,|||but they are on two different servers.. How would I set up the connection string for that?|||With that scanerio, what I have done is issued a sp_addlinkedserver from SERVER1 to link to SERVER2. Then you can access SERVER2 through SERVER1 by using a fully qualified table name: SELECT * FROM Server2.Database2.dbo.Table1.

Terri|||what is a sp_addlinkedserver and how do i set this up?

thanks|||Looks like we straightened this out in another thread:view post 458481

Terrisql

Is it possible to build a cluster with two independent sets of hard drives on each server

Hi,
I have two identical servers. I want to put Win 2003 Enterprise and SQL
Server Enterprise on both of them.
The data will be written to and read from the database.
Is it possible to build a cluster with two independent sets of hard drives
on each server (Server1 with his own hard drives in Raid1, and Server2 with
its own hard drives in Raid1)? As I mentioned the data will be written into
the database continuously. I wanted to check that with you guys because I
have looked into some books about clustering and the only configuration
picures I saw were with a shared array of hard drives between cluster nodes.
Thank you for your help.
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:Dqadney4k-V_6ubcRVn-sg@.comcast.com...
> Hi,
> I have two identical servers. I want to put Win 2003 Enterprise and SQL
> Server Enterprise on both of them.
> The data will be written to and read from the database.
> Is it possible to build a cluster with two independent sets of hard drives
No.

> on each server (Server1 with his own hard drives in Raid1, and Server2
with
> its own hard drives in Raid1)? As I mentioned the data will be written
into
> the database continuously. I wanted to check that with you guys because I
> have looked into some books about clustering and the only configuration
> picures I saw were with a shared array of hard drives between cluster
nodes.
> Thank you for your help.
>
>

Is it possible to acces 2 sql servers at the same time?

I was wondering if it is possible to access 2 different
databases on 2 different sql servers (7 and 2000) located
in to different locations?
Thanks
CK
I've done this using linked servers. Never done it between 7 and 2000 but
it should work. Your query would look something like this.
Select a.col1, b.col1
from server7.db1.dbo.tablea a join server2000.db2.dbo.tableb b
on a.id=b.id
Here server7 and server2000 are your link server defined for you two
different servers.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"CK" <anonymous@.discussions.microsoft.com> wrote in message
news:94a601c485fd$49c0d1d0$a601280a@.phx.gbl...
>
> I was wondering if it is possible to access 2 different
> databases on 2 different sql servers (7 and 2000) located
> in to different locations?
> Thanks
> CK
|||Sure. See if this helps: http://vyaskn.tripod.com/programming_faq.htm#q14
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"CK" <anonymous@.discussions.microsoft.com> wrote in message
news:94a601c485fd$49c0d1d0$a601280a@.phx.gbl...
I was wondering if it is possible to access 2 different
databases on 2 different sql servers (7 and 2000) located
in to different locations?
Thanks
CK

Is it possible to acces 2 sql servers at the same time?

I was wondering if it is possible to access 2 different
databases on 2 different sql servers (7 and 2000) located
in to different locations?
Thanks
CKI've done this using linked servers. Never done it between 7 and 2000 but
it should work. Your query would look something like this.
Select a.col1, b.col1
from server7.db1.dbo.tablea a join server2000.db2.dbo.tableb b
on a.id=b.id
Here server7 and server2000 are your link server defined for you two
different servers.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"CK" <anonymous@.discussions.microsoft.com> wrote in message
news:94a601c485fd$49c0d1d0$a601280a@.phx.gbl...
>
> I was wondering if it is possible to access 2 different
> databases on 2 different sql servers (7 and 2000) located
> in to different locations?
> Thanks
> CK|||Sure. See if this helps: http://vyaskn.tripod.com/programming_faq.htm#q14
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"CK" <anonymous@.discussions.microsoft.com> wrote in message
news:94a601c485fd$49c0d1d0$a601280a@.phx.gbl...
I was wondering if it is possible to access 2 different
databases on 2 different sql servers (7 and 2000) located
in to different locations?
Thanks
CK

Is it possible to acces 2 sql servers at the same time?

I was wondering if it is possible to access 2 different
databases on 2 different sql servers (7 and 2000) located
in to different locations?
Thanks
CKI've done this using linked servers. Never done it between 7 and 2000 but
it should work. Your query would look something like this.
Select a.col1, b.col1
from server7.db1.dbo.tablea a join server2000.db2.dbo.tableb b
on a.id=b.id
Here server7 and server2000 are your link server defined for you two
different servers.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"CK" <anonymous@.discussions.microsoft.com> wrote in message
news:94a601c485fd$49c0d1d0$a601280a@.phx.gbl...
>
> I was wondering if it is possible to access 2 different
> databases on 2 different sql servers (7 and 2000) located
> in to different locations?
> Thanks
> CK|||Sure. See if this helps: http://vyaskn.tripod.com/programming_faq.htm#q14
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"CK" <anonymous@.discussions.microsoft.com> wrote in message
news:94a601c485fd$49c0d1d0$a601280a@.phx.gbl...
I was wondering if it is possible to access 2 different
databases on 2 different sql servers (7 and 2000) located
in to different locations?
Thanks
CK

Is it MS SQLServer or something else?

I am using a tool called AppDetective to identify database servers and
then to scan them for vulnerabilities.

I've just been handed a list of machines and have been asked to
determine which ones are actually MS SQLServer. (AppDetective says
that all of the systems on the list have MS SQLServer).

Does MS SQLServer make use of the same engine/port arrangements for
its other applications such as MS Access?

I've also heard that the engine (Jett?) is also used in some other
Windows components, which is why the AV systems had such problems with
Slammer last year. Is this true?

Thanks in advance"Byrocat" <bdealhoy@.sympatico.ca> wrote in message
news:b47d3acf.0502090633.251c12da@.posting.google.c om...
>I am using a tool called AppDetective to identify database servers and
> then to scan them for vulnerabilities.
> I've just been handed a list of machines and have been asked to
> determine which ones are actually MS SQLServer. (AppDetective says
> that all of the systems on the list have MS SQLServer).
> Does MS SQLServer make use of the same engine/port arrangements for
> its other applications such as MS Access?
> I've also heard that the engine (Jett?) is also used in some other
> Windows components, which is why the AV systems had such problems with
> Slammer last year. Is this true?
> Thanks in advance

I don't know how AppDetective identifies an MSSQL installation, but if it's
reporting machines which you don't believe have MSSQL, it may be that they
have MSDE instead - it's a throttled version of MSSQL for small
applications. If any of the apps listed here are installed, that may be why
they appear in AppDetective:

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=31

Some people installed these apps without realising that they included MSDE,
so they did get hit by Slammer, despite believing that they had no MSSQL
installations. As of SP3a, network access to MSDE is disabled by default, to
prevent attacks on MSDE installations which are only used locally.

The Jet engine is used by Access, which doesn't listen on any ports since it
isn't a server.

Simon