Appropriate Index

I have a table where data is deleted, inserted and updated. What kind of
index is appropriate for the column
where data is deleted ?
where data is inserted ?
where data is updated ?
Thanks for any input."DXC" <DXC@.discussions.microsoft.com> wrote in message
news:945F0AE5-AB17-4D18-8A35-312F4DB6E16F@.microsoft.com...
> I have a table where data is deleted, inserted and updated. What kind of
> index is appropriate for the column
> where data is deleted ?
> where data is inserted ?
> where data is updated ?
> Thanks for any input.
This depends on many things. If you post some DDL, we can help you out.
Read up on Indexes in the BOL for some tips on which columns are good
candidates for indexes and which ones are not.
Rick Sawtell
MCT, MCSD, MCDBA

Appropriate Index

I have a table where data is deleted, inserted and updated. What kind of
index is appropriate for the column
where data is deleted ?
where data is inserted ?
where data is updated ?
Thanks for any input.
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:945F0AE5-AB17-4D18-8A35-312F4DB6E16F@.microsoft.com...
> I have a table where data is deleted, inserted and updated. What kind of
> index is appropriate for the column
> where data is deleted ?
> where data is inserted ?
> where data is updated ?
> Thanks for any input.
This depends on many things. If you post some DDL, we can help you out.
Read up on Indexes in the BOL for some tips on which columns are good
candidates for indexes and which ones are not.
Rick Sawtell
MCT, MCSD, MCDBA

Appropriate Index

I have a table where data is deleted, inserted and updated. What kind of
index is appropriate for the column
where data is deleted ?
where data is inserted ?
where data is updated ?
Thanks for any input."DXC" <DXC@.discussions.microsoft.com> wrote in message
news:945F0AE5-AB17-4D18-8A35-312F4DB6E16F@.microsoft.com...
> I have a table where data is deleted, inserted and updated. What kind of
> index is appropriate for the column
> where data is deleted ?
> where data is inserted ?
> where data is updated ?
> Thanks for any input.
This depends on many things. If you post some DDL, we can help you out.
Read up on Indexes in the BOL for some tips on which columns are good
candidates for indexes and which ones are not.
Rick Sawtell
MCT, MCSD, MCDBA

Anyway to recover delete stored proc?

Folks.

I screwed up big time, I deleted a very long and smart stored proc (pls
don't ask how).

Is there anyway I can recover it?

Any advice appreciated.

Tada.KoliPoki (rayone@.gmail.com) writes:
> I screwed up big time, I deleted a very long and smart stored proc (pls
> don't ask how).
> Is there anyway I can recover it?

Do you have a backup of the database? Or do you run the database with
full or bulk-logged recovery? In that case you might be able to.

If you don't have any backup and run with simple recovery, the procedure
has left for outer space.

Generally, all source code should be under version control. See the
database as the place where you have the binary representation of
the source.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Anyway to find informatoin on how a record is deleted?

Hi,
One record, linked by a key tid, is deleted from several tables in the
database. Is there anyway to find information on when and who deleted the
recrod from SQL server?
Thanks,
AlphaYou can use a log viewing tool, such as:
Apex SQL Log
http://www.apexsql.com/index.asp?PageId=apex_sql_log&TitleID=products
Lumigent Log Explorer
http://www.lumigent.com/products/le_sql.html
Log P.I.
http://www.logpi.com/
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:B6572BE4-B0FE-4034-976F-EA21D1C5CC8F@.microsoft.com...
> Hi,
> One record, linked by a key tid, is deleted from several tables in the
> database. Is there anyway to find information on when and who deleted the
> recrod from SQL server?
> Thanks,
> Alpha

Anyway to find informatoin on how a record is deleted?

Hi,
One record, linked by a key tid, is deleted from several tables in the
database. Is there anyway to find information on when and who deleted the
recrod from SQL server?
Thanks,
Alpha
You can use a log viewing tool, such as:
Apex SQL Log
http://www.apexsql.com/index.asp?Pag...tleID=products
Lumigent Log Explorer
http://www.lumigent.com/products/le_sql.html
Log P.I.
http://www.logpi.com/
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:B6572BE4-B0FE-4034-976F-EA21D1C5CC8F@.microsoft.com...
> Hi,
> One record, linked by a key tid, is deleted from several tables in the
> database. Is there anyway to find information on when and who deleted the
> recrod from SQL server?
> Thanks,
> Alpha

Anyway to find informatoin on how a record is deleted?

Hi,
One record, linked by a key tid, is deleted from several tables in the
database. Is there anyway to find information on when and who deleted the
recrod from SQL server?
Thanks,
AlphaYou can use a log viewing tool, such as:
Apex SQL Log
http://www.apexsql.com/index.asp?Pa...itleID=products
Lumigent Log Explorer
http://www.lumigent.com/products/le_sql.html
Log P.I.
http://www.logpi.com/
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:B6572BE4-B0FE-4034-976F-EA21D1C5CC8F@.microsoft.com...
> Hi,
> One record, linked by a key tid, is deleted from several tables in the
> database. Is there anyway to find information on when and who deleted the
> recrod from SQL server?
> Thanks,
> Alpha