CREATE TABLE tablename

(

id int NULL,

name varchar(50) NULL,

val int NULL

)

insert into tablename VALUES (1 ,'abc' ,100)

insert into tablename VALUES (2 ,'ravi' ,null)

insert into tablename VALUES ('','venu' ,200)

insert into tablename VALUES (3...

CREATE TABLE tablename

(

id int NULL,

name varchar(50) NULL,

val int NULL

)

insert into tablename VALUES (1 ,'abc' ,100)

insert into tablename VALUES (2 ,'ravi' ,null)

insert into tablename VALUES ('','venu' ,200)

insert into tablename VALUES (3...

id int,

name varchar(50),

sal int

With the above datatypes you can not have a table:

,venu ,200

null,fanu ,3600

If the id is an int you can not have both a NULL value and a...

I am doing this out of the top of my head and haven't tried this code, but something like :

change:

set int1 = SUBSTRING (interests,1,PATINDEX ('%,%',interests));

To:

set int1 = SUBSTRING (interests+',empty,empty,empty,empty',1,PATINDEX ('%,%',interests+',empty,empty,empty,empty'));

I...

Thank you,

Using the term uniquifier, on line I found:

[/url]

In books online I could not find the term uniquifier, neither could I...

GilaMonster (6/29/2012)

---

Some behaviour likely changed between SQL 6.5 and SQL 7. Nothing more recent than that though.

WHERE Column IN ('Value1') is completely equivalent to WHERE Column = 'Value1' and WHERE...

GilaMonster (6/29/2012)

---

ben.brugman (6/29/2012)

---

Technically it would be possible to use the information from the clustered key in addition to the extra key, while not using the first part of the clustered...

Thanks for providing the links.

I do understand indexes, both clustered and heap.

I do not always understand behavior of the optimizer combined...

GilaMonster (6/28/2012)

---

When doing updates to index keys, SQL does not do them as inplace updates, they will be converted into a delete/insert pair. This is why one of the guidelines...

Thanks for your anwsers.

At the moment I am trying to convince my organisation that Clustering would solve a lot of the problems we have at the moment and would improve...

Thank you all for the replies.

Now I can convert most tables ON-LINE. Great.

Do you have suggestions for the tables containing LOBS.

Or is there is way to do this on-line by...

GilaMonster (6/15/2012)

---

If you're on Enterprise Edition and there are no LOB columns in the table, then you should be able to create the clustered index online with the ONLINE option...

Thanks for...

Thanks,

this wil help us with planning the...

Grant Fritchey (6/4/2012)

---

When all you have available is the full backup, that's all you're going to get. If you have log backups available, you can restore right to the end...