is there any sql script or stored proc running under it ? POst it

Thanks Paul

@paul-2 : thanks for this informative description. 🙂

Selecting all data means either you have clustered index scan or table scan.see the execution plan , picture will be clear to you

Yes its working with ISNULL

Grant Fritchey (8/10/2010)

---

I think this does what you need.

--test table

CREATE TABLE OrderTest

(id INT,

parentid INT NULL)

--test data

INSERT INTO OrderTest

VALUES

(1, NULL),

(2, NULL),

(3, NULL),

(4, 1),

(5, 1),

(6, 2),

(7, 2),

(8, 3),

(9, 3)

--query

SELECT *

FROM OrderTest

ORDER...

refer this

http://technet.microsoft.com/en-us/library/cc966419.aspx

Ok agree but see the below case with exec plan

truncate table email_destination_bk

insert into email_destination_bk

select ut_stub,acct_id...

Sorry difficult play :-P, but desperate to see the reply

One of my Senior DBA told me that if we have "order by" clause according to source table then there would be page split during insertion as the data is...

removed

thanks

Then in which case , "order by" will be relevant for insert statement.

thanks a lot

use cast or convert function

basically your query SELECT Name FROM dbo.users will be executed in msdb database thats why you are not getting results