Are you talking about a "12 GB drive" as you stated, or a RAM memory ?

Locks that are granted to your session can only potentially block other sessions, never your session (if blocked, you are always blocked by other session).

So, the answer is: no.

Join is...

First, we have to somehow group together rows that belong to the same group. So we will add a new column, GroupId, that has ID of the first preceding IR...

You will love DM function sys.dm_db_index_physical_stats.

In DETAILED mode it gives you info about the index, level-by-level (0 = leaf level).

Example:

-- Create HEAP table and insert 10M rows in one step

select...

Command

DBCC CHECKDB('yourdbname') WITH ESTIMATEONLY

will not check your database, but will give you estimation on how much tempdb space will be needed for checkdb.

If you need to track what is happening...

Of course it is slow. For each row you open and close a certificate, insert just one row and overhead of calling procedure adds-up to that.

Use table parameter...

I'm glad to help, you are welcome.

sql crazy kid (6/29/2013)

...

For example a 10M records on clustered table ,to find a particular record sql will use index . This index has many non leaf nodes ,where this...

For a single command (MERGE is a single command) you do not need "begin tran",

each command starts implicit transaction, and commits/rollback implicitly, all the time (if not within larger transaction).

Also,...

If you need just first row of each group:

SELECT ID, col1,col2,col3,col4,col5,col6

FROM

(select *,

Rnr = ROW_NUMBER() OVER(partition by col2, col3, col5 ORDER BY ID)

from Table_2

) t

WHERE t.Rnr = 1

Result:

IDcol1col2col3col4col5col6

1a1AABBa4CCa6

2b1b2b3b4b5b6

Your test preparation code yields errors (you create one table then insert to another).

If I understood you correctly, you need to identify duplicates by subset of columns,

and then display all...

Thank you both for the info, John and Robert.

This one attempt took me almost 1000 km of the flight in each direction (>4h when there is no direct flight), 12km drive from airport to test center, accommodation for...

I just took the knowledge exam in Berlin.

Those questions are so wicked that only a bit twisted minds could come-up with 🙂

Designed to trick, and trick you again with trick...

Congratulations, Uwe!