Thanks for clarifying Gail and Steve 🙂

I am bit confused here,

For a regular table without any index ( a Heap), the statistics get created on firing any query with some filter.

However, on the table with clustered...

Table locking is default behavior when I...

True, POC's are usefull.

But most of the companies today don't give that much time to developers to try something new or an alternative approach and come up with POC's.

They follow...

If it's less than 30 try to reorganize and if greater than 30 just rebuild.

This query should be more appropriate for you and will give you the command as well

SELECT...

Thanks all for your comments and feedback 🙂

create table dbo.SSC1(CustNumber int, Name varchar(20), location varchar(10), division varchar(10))

insert into dbo.SSC1(CustNumber,Name,location,division)

VALUES

(1, 'Test1', 'MA', 'E'),

(2, 'Test2', 'ME', 'E'),

(2, 'Test2', 'ME' ,'G'),

(3, 'Test3', 'CA', 'E'),

(3, 'Test3', 'CA', 'G')

;with cte as(

select ROW_NUMBER()...

I agree with John,however there is a third party tool from cozyrock that has various flavours of DFT tasks.

http://www.cozyroc.com/

Great Jacob, you got it correct.

Thanks!!!

Alter the column to non-nullable

Alter the table to add primary key on the...

Nice explanation Hugo and with this link that even I gone through yesterday, tells that Index structure are B+ and not Btree.

Yes, we may call BTree as Balanced, though it is not official.

However the index structure is not a BTree, it's actually B+Tree.

When we see the difference between BTree and B+Tree,...

Thanks Gail,

My doubt is clarified

Thanks Gail for the clarification but I guess even in Sql 2000 bookmark lookup refers to either key Or RID

Check this link:

https://technet.microsoft.com/en-us/library/aa178418(v=sql.80).aspx

Thanks All 🙂