Yes, you are right , i am looking for indian page.

clicking on below url suggest for https://www.microsoft.com/learning/en-us/default.aspx on which for 70-461 it shows no web page found.

http://www.pearsonvue.com/microsoft/

Query:1

DELETE Top(100000) FROM [dbo].[EncounterSignOff]

FROM [dbo].[User] INNER JOIN [dbo].[EncounterSignOff] ON [User].[UserID] = [EncounterSignOff].[UserId]

WHERE [User].PracticeID = '55';

your above query has two from clause, i think it will show error

--First run to check records

SELECT E.*

FROM [dbo].[EncounterSignOff] E

INNER JOIN [dbo].[User] U ON E.userID = U.UserID

WHERE U.practiceID = 55

--Run delete

DELETE E

FROM [dbo].[EncounterSignOff] E

INNER JOIN [dbo].[User] U ON...

Create table test

(project varchar(50),

descripation varchar(50)

)

Insert test

SELECT 'chocolate' ,'white'

UNION ALL

SELECT 'chocolate' ,' black'

UNION ALL

SELECT 'chocolate' ,' brown'

UNION ALL

SELECT 'sugar' ,' black'

UNION ALL

SELECT 'vinegar' ,'yellow'

SELECT DISTINCT project,

STUFF(...

Thanks a lot Kutang Pan ..

ok..Thank you Mark

In normal result set column value won't affected with column name provided, is this specific to xml?

I just want to understand logic behind it ,is it converting datatype ?

You can read below link article , split function DelimitedSplit8K is there.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

DECLARE @p_str varchar(max)

SET @p_str = 'Pawar, Ramesh S.'

SET @p_str= REPLACE(@p_str,',','')

SELECTpvtTable.[1] AS LastName,

pvtTable.[2] AS FirstName,

pvtTable.[3] AS MidddleName

FROM [dbo].[DelimitedSplit8K](@p_str,'')

PIVOT

(MAX(item)FOR...

Something like this, i couldn't find any other way .

CREATE TABLE #temp

(

ID INT IDENTITY(1,1),

txt varchar (max)

)

DECLARE @txt1 varchar (max)

DECLARE @txt varchar (max)

SET @txt1 = 'john asfasdf 535 summit ave franklin...

Thank you Grant and Gail..

I have used dmv sys.dm_os_waiting_tasks and by using below query found that session_id which are in waiting tasks are of system process, as all records...

GilaMonster (12/10/2014)

Could be...

Also i can see wait type PAGEIOLATCH_SH and wait time increasing ,while query is running.

Thanks..GilaMonster and Grant for guidance

i was able to get query plan from sys.dm_exec_query_plan using plan handle.However i have cancelled query as it was taking too long.

I found only CompileMemory...

ok..i will try to find out those counters..

Thank you GilaMonster

check below article

http://www.sqlservercentral.com/articles/Tally+Table/72993/