You can change to like this. YY

select dbo.fn_FormatDate(@dateS,'yy/mm/dd')

This function is so flexible to format any date. you can see the example in the function too.

Can you let us know what is the error.

If it's a distributed query then you may need to check the remote link and also the account which remote link...

Try to use the following function.

You need to convert your int date to varchar and then try following function.

for example

declare @dateI int

declare @dateS varchar(10)

set @dateI =20060101

set @dateS = convert(varchar(10),@dateI)

select dbo.fn_FormatDate(@dateS,'yyyy/mm/dd')

create...

Here you go.

--To get the stored procedure started with sp_

select name from sys.sysobjects where name like '%sp_%' and xtype='p'

--To get the list of tables without clustered index

SELECT DISTINCT

=...

I think I should be more clear.

I wanted to restore Analysis Cubes from one server to another server automatically, I am thinking if it can be done through sql job...

I just came to know that we should not rely on task manager when checking memory problem. Task manager sometimes does not give proper information on Itanium server.

We should use...

Thanks a lot Tim,

I will surely look into this document and make necessary changes.

The only thing I know that I posted a question and I got response very fast and that is what I need.

It's not a matter of laziness, it is...

Alex.. I was thinking of the same thing. I will remove and add some more thoughts so that users should understand easily. I really don't want to put technical...

Hi Tim,

I am a DBA and I know my DBA job. I think you misunderstood the questiion. I can develop this demo but it will take some hours and I...

That looks great. That exactly i need.

you saved my lots of hours.

Thanks a lot.

Thanks man,

I think it's fine now, some system process were running and taking lots of CPU. I will see tomorrow if there is any improvement because there will be some...

After doing all the changes and rebooted the server, it is now taking 100 CPU but paging size is very low. Before the changes, CPU was very little but paging...

Thanks,

I will surely do that.

This SQL box has 6 GB of total memory.

Mininum memory is 0 and maximum memory is 2147483647 MB which is default.

Should I change maximum memory to 6000 MB and what...