patla4u (8/29/2011)

---

Hello All ,

I am working with 20 tables with Inserting and Deleting database .....

Size almost 25-30 GB.

Now I have check size of database ...so It's go to 30...

kramaswamy (8/29/2011)

---

Short of using replication, you have no option but to use a linked server - your data exists on a remote location, so you need to fetch it somehow....

Hi,

Thanks for your kind attention.I am not a developer so sorry for asking stupid questions.

My query is a follows:

SELECT 11, tmp.AdjustedArrivalDate, sbp.info_Date, datediff(hh, tmp.AdjustedArrivalDate, sbp.info_Date) 'ActualTAT', 32,

case

when dateadd(hh, 32,...

sorry. By read only, I mean...

LutzM (8/25/2011)

---

chandan_jha18 (8/25/2011)

---

...

sorry for not understanding your idea.I apologize. So do you suggest that i should take the select statement with like operator out of the where clause, write it...

LutzM (8/25/2011)

---

chandan_jha18 (8/25/2011)

---

...

you are right about a table variable holding many rows. I will try to switch that into a temp table with some index on it.

I agree that like...

GilaMonster (8/25/2011)

---

chandan_jha18 (8/25/2011)

---

However as you said that it offers no selectivity, can we move it to the end of the where clause because I think doing this we are just...

I am waiting for the monster to come and give her advice. I will combine all everything coming from all 3 of you and try doing something good for me....

LutzM (8/25/2011)

---

There are three major issues that I see:

1) it looks like a catch-all query to cover partial results from a LEFT OUTER JOIN and an INNER JOIN. I would...

Thanks. This page is bookmarked in my browser and will read it again today. For smaller experieced DBA like me who started...

I am posting the part of the query which is causing the issue. Sorry but this is too big to read.

If you go through...

you might have seen a similar execution plan 2-3 days back. But I request you to drill down...

GilaMonster (8/25/2011)

---

You sure about that scan?

An index scan won't have a seek predicates property, only index seeks can have seek predicates.

Seek predicates are what the seek looks for in the...

TST1 (8/25/2011)

---

Hi,

I have this strange login problem where I'm getting login failed even though the service account that the job runs under has sysadmin permission! The schema was created...

Use the DTS exec utility to execute the package and see what errors it gives. you can also take help of output log files as well as profiler on the...