Hi....
I need to buy a new server for my MS-SQL... becose frequently appear
deadlock's, and the Disk Times (read and write) are over the 80%... so i have
some questions about that...

Is there any reason to have a row that is the PK/Identity and a row
that is datatype Timestamp in the same table?
Does this in any way help speeding up row updates?
Thanks,

What is the purpose of setting the primary key to not for replication?
thanks.

We have a database with some tables with (what I would
denote as) 'referred field names'.
Like this:
   DataTable1 with fields F1, F2, F3

What are some good strategic approaches to using freeform text fields for
data that needs to be queried? We have a product whose tables we can't
change, and I need to count on a "description" field for storing a value.
Two, actually. I'm thinking of adopting this convention:

My SQL acumen stems from just a couple courses, and everything since from
the trenches. Fun + angst over time.
I'm needing some advice on joins. Though I understand the basics, I'm
having problems abstracting from instances where it's easy to think about

Hi, My application goes through a lengthy data processing phase before
it's ready to run.   During the DP phase I'm mostly inserting records,
afterwards many of my tables will be read only.   Is there anything
wrong with dropping indexes used for the DP and setting up clustered

I am using SQL Server 2000. I have some files with SQL-Statements.
The SQL-Serveragent runs jobs which execute the SQL-Files:
(e.g. osql /E /n /i \\server\d$\lager_pool.sql)
How can I implement an error handling.

I am a newbie. Just started using SQL recently.
My SQL statement adds up monthly sales fields to get a '12MONTH' number. I
then repeat the previous statement and divide by four to get a '90DAY'
supply. Then I take my quantity on hand and subtract the result of the

This is a general question on the best way to import a large amount of data
to a MS-SQL DB.
I can have the data in just about any format I need to, I just don't know
how to import the data. I some experience with SQL but not much.

Same with OpenDataSource.  SQL 2000, logged in as non-SA.
Getting message:
Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been
denied. You must access this provider through a linked server.

I have a question on how to return only some records from my existing query
(shown below).  I want to return only records that occur in both sides of
the union AND have the same tablename.  (Maybe thier is an easier way than
starting with the union, which you may suggest).

How do I prevent SQL Server 2000 from posting successful backup
completion messages to the Windows 2000 Application Event Log?
I have scheduled jobs which backup my transaction logs on 50+ databases
and it always writes to the Windows 2000 application event log upon

I have a table that looks like this
tbl1:
nvchValue nvarchar(100) NOT NULL
biVal1 bigint NOT NULL

I know that this has probably been discussed, but I couldn't find
anything with Google. I have the following problem... I receive a set
of text files that describe a chain of insurance claims. Each claim may
be copied from an older claim and it may be copied to a newer claim. I