I have tested it.

The page compression on Table reduces the size of table as well as size of Clustered Index without any change in size to NonClustered Index.

Now My next...

I am doing page level compression on table using wizard which does :

ALTER TABLE [SchemaName].[Tablename] REBUILD PARTITION = ALL

WITH

(DATA_COMPRESSION = PAGE

)

Hence I guess, it always rebuilds while compressing.

Since the...

Thanks Champion,

I didn't notice it.

In my Config File a semicolon was missing after password field.

Hi,

Kindly check the screenshot attached

Thanks Gail,

So if I am correct for parameterized proc. SQL creates a plan depending on table size as parameter values are not known till compile time.

Since in my case Table...

I have gone through various articles but still not very clear.

I would like to summarize my question below:

When we are creating a Parameterized SP and running it for the first...

Thanks All,

It was parameter sniffing and I overcame by creating local variable within stored procedure and assigning values

of @BatchId and @claimtype to @Batchid_local and @claimtype_local respectively.

and used @batchid_local and...

Because of some security reasons I am not posting exact column names, but below is the the query that I am using.

On Table1 , I have following Indexes:

Nonclustered index on...