When we say it is read only what happens if I insert fresh rows into the table having columnstore index? And provided hint to use columnstore index, would it use...

Thanks.....Jared

for pointing out small yet effective point to improve the performance, it improved performance up to 40%

Thanks again

No, I can not use other predicate. I can only see one option of adding those columns to the table

Tables:

CREATE TABLE [dbo].[GEN_PRODUCT_XREF](

[ROW_KEY] [int] NOT NULL,

[ITEM_KEY] [int] NOT NULL,

[ITEM_STATUS] [tinyint] NOT NULL,

[ITEM_STATUS_ALLPOINTS] [tinyint] NULL,

[ITEM_CURRENT_FLAG] [bit] NOT NULL,

[UPC] [varchar](25) NULL,

[UPC_CHECK_DIGIT] [varchar](1) NULL,

[SKU] [int] NOT NULL,

[SKU_PARENT] [int] NULL,

[DIVISION_ID] [tinyint] NULL,

[QTY_PHYSICAL] [int] NULL,

[NAME]...

It's perfect...Thanks for your help.

Hey..Gail,

I just wanted to know something from you is that can we use database snapshot or replication as development server?

My manager told me that now onward they will provide me...

How can we say from our execution plan that the specific part is allocated with less space? As you told me that hash join is occupied with less memory.

this...

Here is the plan and stats for update query.

how can I get it for a particular query?

Do I need to write a query for that?

I did ask for wait_type and he sent me this file. But, I never had experienced this before.....How can I read this.

I mean, how can I say for sure that...

The update query is the main query. we are using in that query and joining those tables within that update statement. Again I do not have permission to SQL profiler....

This is the task we are performing....sometimes it takes 40 to 45 minutes.....and sometimes it just takes 1 minutes...

I am also attaching actual execution plan on production...it did not take...

can you please explain this further...I did not get it.... "In SQL 2005 or later you can use include as well and add get_suborders.site_id and gen_suborders.suborder_received_date to an index on...

I do not have access to execution plans. This is what my manager sent me.

Hi Jack,

How can we decide what object should we use? Just like, you said in this case you will go with function instead of stored procedure.

Thanks