Viewing 15 posts - 1,471 through 1,485 (of 2,462 total)
Thanks Paul
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 10, 2010 at 9:42 pm
@paul-2 : thanks for this informative description. 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 10, 2010 at 9:39 pm
Selecting all data means either you have clustered index scan or table scan.see the execution plan , picture will be clear to you
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 10, 2010 at 6:58 am
Yes its working with ISNULL
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 10, 2010 at 6:53 am
Grant Fritchey (8/10/2010)
--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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 10, 2010 at 6:44 am
refer this
http://technet.microsoft.com/en-us/library/cc966419.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 10, 2010 at 6:17 am
GilaMonster (8/10/2010)
In the initial post, neither of the order by statements matched the clustered index
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 10, 2010 at 4:49 am
Sorry difficult play :-P, but desperate to see the reply
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 10, 2010 at 2:22 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 10, 2010 at 2:03 am
removed
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 10, 2010 at 1:59 am
John Mitchell-245523 (8/9/2010)
This doesn't guarantee that the rows will be inserted in that order.
thanks
Then in which case , "order by" will be relevant for insert statement.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 9, 2010 at 6:41 am
thanks a lot
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 9, 2010 at 6:38 am
use cast or convert function
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 9, 2010 at 5:55 am
basically your query SELECT Name FROM dbo.users will be executed in msdb database thats why you are not getting results
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 9, 2010 at 5:53 am
mirravi (8/6/2010)
@copy_recipients = '345@abc.com;444@abc.com'
i am sure your email address list will be huge.So better to add a distribution list in exchange server and add that it in "@copy_recipients" parameter.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 9, 2010 at 5:14 am
Viewing 15 posts - 1,471 through 1,485 (of 2,462 total)