we use a SP to get the data

here is the SP

USE [365_AppNexus_ODS]

GO

/****** Object: StoredProcedure [dbo].[GetDeliveryReport] Script Date: 03/24/2015 06:59:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE...

Thanks Husain

if i change to default folder does it work ??

which also have read only access to the folder

actually some SP are getting lots of time to execute so if i create a composite cluster index with all columns then it will improve or need to create non...

so can u suggest me to create indexes on that table to improve performance

If we create composite clustered index on all columns does it effect any thing ??

when i run the query it always taking non clustered index scan on execution plan when...

after using where clause also its taking 100% cost ?

any other way to improve ?

thanks

so how to improve performance of the table & when we have 50 million records.

if we create non clustered index like

CREATE NONCLUSTERED INDEX [IDX_APPID_1] ON [dbo].[MASTERFLATFILE]

(

[GEOGID] ASC,

[VARID]...

we created the cluster index so want to check how performance effect on the table

USE [Live_Demo_Redux]

GO

/****** Object: Index [CDX_APPID] Script Date: 10/09/2014 16:41:03 ******/

CREATE CLUSTERED...

yes data base is same ...

how to check the used log space ? any script ?

Thanks

ya its Simple recovery model ... we have a support team who monitors the size

DatabaseSizeUnallocatedSizeAllocatedSizeAvailableSpaceAvailableSpaceIn%MaxSize

2.891299 0.179775 ...

Its around 82 pages