if you can afford, change the db access level to "single user" before restore and then restore te db

thanks for the good QOTD and explanation behind it.

i am not sure but if you want to migrate the data including primary keys to production database, you can use set identity insert on and off to explicitly insert...

hi Jason

I am using T-SQL for data transformation. I think i have confused everyone on the forum.

Let me rephrase what i am doing. I have a source table with...

There are total of 5 indexes on this table

- 1 clustered as primary key

- 3 non clustered created on foreign keys

- 1 non clustered created...

Exactly this the point to worry, it is taking 12 milliseconds to insert...

Sorry it is 12 Milliseconds instead of 12 microseconds, the default duration setting done in SQL Profiler.

Jeff Moden (1/26/2010)

You said before that your indexes don't appear to be badly fragmented after the inserts. I think that might not be right. Could you post the...

it takes approximately 50 minutes to rebuild the index.

Fraggle-805517 (1/26/2010)

---

I could be wrong on this, but the issue might not be the indexes, but the statistics. If you statistics start to get out of date, then it...

Navnish Sharma (1/26/2010)

---

As a best practice, you should script out your indexes. Drop them before the load, perform your load and then recreate them. When you talk about millions or...

Thanks Nagaraj. That link answered everything

I used Update trigger to fire the stored proc per record. I was thinking triggers in SQL Server work the same way it does in Oracle but unfortunately i was...

Lowell (1/11/2010)

---

yes Anam, you can...the last post i made with a code example did exactly that...the code was assuming there is a column named recordid, and it was the PK...

i am facing a problem with updates in batches. What i thought earlier and what my understanding is that if i am running an update on a table in batches...