I was reading some stuff that CELKO wrote and one of his issues seems to be
that you can almost always create a primary key naturally. That is, most
tables have a field that would naturally be unique and could be used as the
primary key instead of creating another column just for ...

hi, all,
I add some reduplicate data records into a table by using SQL SERVER 2000
"enterprise manager" without any constraints. while I try to delete one or
the reduplicate row(or all the same rows), it prompts failure because this

I posted several hours ago, but did not see it. So I post it again.
Recently, I am moving a database from one server to another server due
to the storage issue. The existing database is about 30G, all tables
are in one filegroup and one primary data file.

I'm a bit green in trying to optimize query performance, so please
bear with me.
I've got a query built in a package that has run well over the past 3
years.  It involves a large table with a left outer join to a

I receive a spreadsheet which has been saved (file, save as in Excel) as an
html file and I need to import it.  Which driver do I select from the import
wizard?  Or is there a better way to do it?
Thanks for your help.

I am working with a database that tracks sector scores for economic
data.  There are five sectors that are scored for geography entities.  A
scoring record is entered for each geo entity for every month.  I need
to find the highest Total Score (=Sect1Score + Sect2Score ... +

Is there a wizard that can create update, insert and delete stored
procedures for chosen Tables?
E.g. creates parameters for all columns and includes a SQL insert statement
etc?

Does anyone have a link to a basic overview of execution plans?  I've
looked in BOL, but must be looking in the wrong place, because  I
can't find the answers I seek.
Some of my questions:

Dear Professional,
I would like to ask one quick question about data import through SSIS
I am using SSIS Package that import 1 million of recrods in CHART database.
I saw the log file size was too large.

I'm thinking about disaster recovery in the context of virtualization.
I have a virtual machine (call it VMWare ESX if it matters) on a host.
The VM is running SQL Server 2005.  The SQL Server in the VM is using a
locally attached SAN for storage.

Question from a beginner:
Could you explain me in simple words what is the meaning of  "surface area"
in the following sentence:
"If you are using SQL Server 2005, you must also change  the surface area

I'm trying to change the field PM.TRANSQTY to '0' if the field
pm.ADDCOST is '3'.
I can change the field PM.ADDCOST to '0' but is there also a way of
changing PM.TRANSQTY?

Hello Professional,
I would like to ask one quick question regarding Maintainance Plan ->
Rebuild Index Task.
I have created Maintainance Plan and in that I used "Rebuild Index Task" to

i'm not sure if this group is NTG for my question, and if so i'm
really sorry...
i don't know much about SQL - just basics: tables, indexes, simple
selects and

I am trying to run "Upgrade to SQL Server 2008" to install SQL Express.  In
"Select Features" two features appear (Shared Features and Redistributable
Features) but both are disabled (i.e. grayed out).  Then when I click on the
Next button I end up with an error saying "There are ...