I'm guessing that the tiff file...

TheSQLGuru (6/25/2013)

---

mayurkb (6/25/2013)

---

TheSQLGuru (6/25/2013)

---

I would have nonclustered indexes on the requisite fields required to find the aged records (some date field on all parent tables I would presume). Child...

TheSQLGuru (6/25/2013)

---

I would have nonclustered indexes on the requisite fields required to find the aged records (some date field on all parent tables I would presume). Child tables would...

That's what I was thinking. I do have a prototype ready with this kind of approach. The design is stored proc getting called from .net application hosted in windows scheduler....

Thanks for the reply Sean.

1. The other applications won't be using that data, since it is old data. So it does not impact them.

2. There won't be millions of records....

Yeah, how did I overlook that? Thanks Sean.

You will have to remove all where clauses having aggregate functions like AVG and put them into HAVING clause.

Consider normalizing these tables in future.

For now, Check if this works:

Update POTable

set Buyer = PO.Name

FROM POTable PO inner join BuyerTable BT

ON PO.Buyer = BT.Buyer

"OPTION optimize for" if not the only way to resolve sniffing issues. There are multiple ways to resolve it.

The thing that I am trying to say is first we...

ARITHABORT doesn't really do anything. It is just a setting, you can set it off from the tools->Options. Once you do that you will see the same plan that you...

It depends on the options that are selected and the sniffed parameters of the query. SQL Server caches the same query in the plan cache for different options.

Generally, the distinction...

Glad I could help.

We were also having some CPU issues with our virtual servers running on vSphere. We did not see those issues while running on hyperv.

Also, keep in mind...

1. Are these all columnnames on the table?

2. You dont need alias name here.

Look at this sample I created:

create table dbo.tbltemp

(

houseNumber int not null,

Modifier nvarchar(20),

comp as CAST(houseNumber...

Couple more things to check:

1. Statistics are updated or not. Update them with sp_Updatestats

2. How much data is there in this server compared to other server?

3. The SQL Server does...

Are both the servers running on the same version of the SQL Server? Initial look at the plan shows that slow execution is taking lot of time to compile a...