From my past experience on bulk insert, the account under which the sql service is running on source should have full access (or atleast bulk import access) on the db...

GilaMonster (2/10/2011)

---

sqldba_icon (2/10/2011)

---

Gail thanks for reply. I apologize for asking this question, but is there a way i can just email you the details just because it has some confidential...

GilaMonster (2/10/2011)

---

Post the table definition, index definition, query and execution plan (both seek and scan).

There is a recompile hint, but please don't start using hints unless you know what's causing...

pankushmehta (2/7/2011)

---

I generally use

select percent_complete, estimated_completion_time/60000.0 'EstimatedMinutesRemaining'

, *

from sys.dm_exec_requests

where command like 'backup%'

However, the Estimated_Completion_Time is not an accurate figure. It does give me a close enough figure on how long...

Thank Sushant. This doesn't give what i need.I need to findout how much more...

From one of the Microsoft sessions which i recently attended, i was told that Microsoft doesn't recommend more than 30 databases per instance to be setup for mirroring.

Grant Fritchey (2/9/2011)

---

Not seeing the code, I'm guessing, but I'll bet one or more of your queries are dynamic using EXEC or sp_executeSQL. That would explain why you have two...

Thanks Grant. We are actually using UDF's inside the procedure. There is a table scan going inside the UDF. How do i fix that?

TheSQLGuru (2/9/2011)

---

a) parameter sniffing as cause:

1) run your query on both servers with HARD-CODED input values instead of parameters.

2) run query on both servers...

Grant Fritchey (2/8/2011)

---

sqldba_icon (2/8/2011)

---

Two updates on the same question,

i) In my proc i have the following options set up

Set ANSI_NULLS ON

go

SET QUOTED_IDENTIFIERS ON

go

Set Transaction isolation level read uncommitted

SET NOCOUNT ON

ii)...

Two updates on the same question,

i) In my proc i have the following options set up

Set ANSI_NULLS ON

go

SET QUOTED_IDENTIFIERS ON

go

Set Transaction isolation level read uncommitted

SET NOCOUNT ON

ii) This article ...

Grant Fritchey (2/8/2011)

---

Assuming you're getting an actual execution plan from the trace or through management studio, they're the same because they're coming from identical sources. Neither does anything that the...

actually i think it is more of data related. Because when i run my tests against two days old data it does seek and if i do it against current...

Thanks Gail. The exec plan has all the table names and database names. I am little hesistant to send it that way. What do you suggest?

I just copied a recent full backup and still the same index is used but one does index scan and other does index seek? How can that be possible...