Hi

Suresh: put it in other words, i would like to know what are the methods through which we can determine the RAM capacity for a server.

any links, white papers are...

Hi,

in the performance monitor I've selected Paging file %Usage and %Usage Peak.

how to check page life expectancy?

My maximum Server Memory shows 2147483647 - nothing but 2GB correct?

how to allocate...

Hi All,

Thanks a lot for your inputs.

I'm working on those.

and i have installed performance dashboard reports to find out the time taking queries.

Once i find some significant result,...

Actually my question is can't I use the CTE in further part of the procedure. I found the answer is 'no'. before mentioning the CTE in query we...

Thanks a lot Sabya.

I'm looking into it.

Regards

Anamika

Hi,

while I use cast also i get the same answer.

I repeat my question :

for the date '2/2/2010' i got 40211.

when you use the date functions to get the date I'm...

Hi,

I tried your suggestion. amazing it works well. but still there is one concern.

the date values it is giving as numbers like

31810

39866,,39480

39532,,39115

39866,,40211

for example i entered 2/2/2010 in excel...

Hi Sabya,

thatz what not happening. Eventhough i set the columns as text, as soon as they paste the 'date' data into it the properties are becoming date. and when...

How do you convert to flat file? in my project itz been placed in a folder. the package should pick and do the job automatically.

the files will be uploaded by...

Hi,

I would guess that those 'numbers' you are referring to are the number of days since 1/1/1900 (or 1899, or whatever the base date is) - which is how Excel...

thanks for ur reply.

a new record should be inserted into table SC - criteria -

multiple records having same values of id1 and flag =1 , need to be merged in...

Hi all,

i apologize for not providing data in a consumable format. i'm really sorry.

thanks to Nabha, that is the result set i want.

Saurabh Dwivedy, your query returns only the top...

Email1 modifieddate mergeid1

NULL...

thanks arun,

it works....

regards

anamika

Hi arun,

this works fine.

but the saNumber, what we are comparing is not the same field always.

sometimes it is raNUmber and vaNumber as we are gathering information from various sources.

so i...