Good workaround, but that will help me for 1 table only (or small amount of tables).

Suposse I have Table01, Table02, ..., Table99 (99 tables).

I wanna be able to have a...

Thanks Calvin Lawson. The data is not stored sequentially. That is why I prefered to create a NON-clustered index with FILLFACTOR=50 so...

Yes, I agree with what you said; that is why I am using a different fliegroup located in a different container. I was not sure if it will behave as...

I was able to extract most of the tables.

I had problems with 5 of them, were they had the primary key clustered in a different filegroup (NDF). When I execute...

MDF, NDF & LDF files were copied and then we tried to reattach the database. It did not work.

I created a database with the exact filenames in my local machine,...

Thanks fellows.

Frank, I will buy the book, but I am more confortable searching the web. I have started to maintain 5 SQL Server machines with not much time to read...

After further RTFM (thanks jxflagg... i didnt know I was referring to pages) I learned that SQL Server will split the pages and move one of them into an empty...

Oh I forgot.

sp_lock will let me know the locks. How can I se which one is enqueued? (waiting for alocked resource)?

Thanks alpha3300,

We could not commit before executing the stored proc because the transaction was opened at the top of the vb, and in case of error it will rollback...

SQL92 and T-SQl give the same explain plan. Nested loop against the driving table (which is b).

Thanks all for your help

Thanks, I will try that.

The SIDs i am referring are the Session IDs on the database and their sql stamements.

Just a note, that query will not use any indexes; so if your table is big, it will hit the performance with a full table scan instead of index scan....

Guaranteed Range scan on col (if indexed)

SELECT col FROM tab WHERE col >= GETDATE() - 365

Join update did the trick

UPDATE a

SET a = b.a,

b = b.b,

c = b.c,

d = b.d

FROM a,b

WHERE a.id = b.id

Thanks Frank Kalis.

I really didnt think on that either. The article is clear with "not supported" clause.