Well if they were in tempDB I could understand that. Are they in a user database?

One other thought... if this table is just used for archiving stuff I would batch this and use bulk insert instead of inserting one row at a time. Even...

Do you have a clustered index on the table? If so which column... and what is the distribution Vs. the order of insertion?

If the clustered index is on a column...

90% of the time I find that poor performance is directly related to poor design of the database, data structures and business logic (stored procedures and application code). The other...

sqlcmd is the (2005) replacement for osql

rockingadmin (10/7/2009)

---

table1:

Custid levelid levelname fromlength tolength

ABC 1 ...

is there is a one to many relationship between custid -----> levelid ? In other words, can a single customer have many levelid's associated with him? You haven't made that...

rockingadmin (10/7/2009)

---

Query 1:

both the tables will have unique values. that's y i make them as primary key.

can i make custid in table2 as primary key and create a composite...

Looks sort of hokey to me. In my opinion, if you are going to have a custid it should be a unique PK in and of itself. Having...

that user is the owner of schemas or other objects in the database. change ownership of those objects to another user and then you should be able to drop that...

If you need to put the new column into a specified position (other than at the end, where it would go in the case of ALTER TABLE ADD COLUMN) then...

You can set up a SQL maintenance task to back up whatever DBs and/or translogs you want. I generally set up my own translog backup procedures for log shipping though.

backup to disk, compress and/or encrypt and then move the files to multiple other disk locations, one of which can be backed up to tape.

You can defrag the drives.

'strategies' for minimizing the need to do this is really just good planning of the disk layout and space allocation. Put your backups on a separate...

As far as your number 2. observation, if Oracle is capable of having multiple instances that are different versions then they may not be able to share anything in the...