Much appreciated chris, for the prompt responses.

Not common.

To make it simple. Find the below create table script...

ChrisM@Work (6/3/2016)

---

Thanks but that doesn't answer the question. You can determine the split point by eye because you know what to look for. What I'm trying to figure out is...

ChrisM@Work (6/3/2016)

---

p.shabbir (6/3/2016)

---

Ok. I have modified the query like below. But getting error Like "Invalid length parameter passed to the LEFT or SUBSTRING function".

WITH MyData AS (SELECT SRC_ERROR_OUTPUT FROM REJ.FILE_READ_REJECTS...

Ok. I have modified the query like below. But getting error Like "Invalid length parameter passed to the LEFT or SUBSTRING function".

WITH MyData AS (SELECT SRC_ERROR_OUTPUT FROM REJ.FILE_READ_REJECTS WHERE FILE_TAG_ID...

After

"be.wylei.com/3dadf94363998b3bb263e8944efa95b4.smartclick?wid=${Profile.CustomerKey}&wcid=${CAMPAIGN_KEY}&wseg=${VSEG} applynow.chase.com/FlexAppWeb/pricing.do?card=FK6S&page_type=appterms creditcards.chase.com/a1/marriottpremier/200SC-offer-details-May16" value

in the above example the record must be splitted.

Thanks.

ChrisM@Work (6/3/2016)

---

WITH MyData AS (SELECT MyString = '11157243 1224314 20160523 05/22/2016 20160526 GLOB 4,000 16 72 ISASANTAELLA@HOTMAIL.COM c1e1b966-4233-11d4-85dc-080009daf0d2 373294099 XXXXX4099 ISABEL SANTAELLA DE KUBLER ISABEL SANTAELLA DE KUBLER Y...

Alan.B (4/5/2016)

---

Indexing is a complex topic indeed. I huge part of the game is understanding how your server is using them. I always develop SQL with "Include actual Execution Plan"...

ZZartin (4/5/2016)

---

Just to clarify, are you...

Thnx John and all.

No, I don't have a query. I was reading about indexes and suddenly strike into my mind this. And I thought to check with the most talented...

Thnx Gail,

So, finally no use of creating nonclustered index on clustered indexed column since there will be diff in milliseconds for both indexes right?

Appreciate for the prompt response Alan.

I have query like below

Select C1 from mytable where C1 = Somevalue

Which index is used in the above query?

Again Thnx.

Once again thank you guys.

Finally, what I have understood is since "first index defined for a table should be the clustered index" so, microsoft chose clustered index when creating PK.

Correct me if I am...

I was asked by an Interviewer John.:-)

Thank you very much all.

Clustered key? Not understood.

And what is heap index? Does heap index and heap table both are same.

I know if the table does not contain an index...