Nikhil welcome to SSC. friend 🙂 we need something to tell you something. means post the table defintion along with some sample data , also expected output based on sample...

why so much of data on excel .it would be difficult to analyze it there (difficult to slice and dice) or even to scroll.

from excel too , you can do...

some on instance level ....some database level..some table level.

better google it 🙂

use databasename

go

select * from sys.sysfiles

go

select * from sys.database_files

jitender, are you still experiencing same memory issues ?

Any article reference for this ?

in future try to avoid cursors instead use loop or set based approach. why ???? google it 🙂

Thanks gail for explanation..

try this in your cursor code

DECLARE @sql NVARCHAR(4000);

While

begin

SET NOCOUNT ON

SET @sql = 'CREATE LOGIN ' + @username + ' WITH PASSWORD = ''12345'', DEFAULT_DATABASE=[dbname], DEFAULT_LANGUAGE=[British], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON';

EXECUTE(@SQL);

exec...

thanks gail

sse this link http://sqlserverplanet.com/optimization/using-union-instead-of-or

its happening because of OR usage in first query , yes it is well know performance glitch.

i am not agree you will get this error...

see...

another query

select name,[Phone],[Sms],[Email]

from

(

select name , mode , sum(case

when name = 'AAAAA' then 1

when name = 'BBBBB' then 1

when name = 'CCCCC' then 1...