Lynn Pettis (4/28/2010)

---

Brandie Tarvin (4/27/2010)

---

For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets...

Nope. I'm not seeing that.

I was thinking the same thing, plus, how the heck big are the transaction logs?

Check the TSQL to see the execution plans & tune as needed. Validate that the SSIS package is not performing scripts or operations that prevent the pipeline from acting in...

Concur. That sounds like a serious problem.

Yeah, I figured updateusage was a total waste of time, but it was niggling at my head, so wrote it down.

If consistency is good.... it's the OS or the SAN...

Personally, I'd say yes, use the APPLY operation, but, as with all things, you should test both, look at the execution plans, the performance time, and then make the determination...

Depending on the data types, of course a few million records could produce a difference of 20gb. Actually, the data types involved must be quite small for several million records...

d.srikanth50 (4/28/2010)

---

Hi we are running fullbackups on every sunday at 2a.m.and transactional log backups

on monday to saturday at 3:30a.m.i have to schedule diferential backups also on everyday.

please guys let me...

Will do. I was being lazy with the link and got caught. Sorry :crying:

Although, again, I'd suggest a quick query against sys.dm_exec_query_stats. Order by physical/logical reads or physical/logical writes and you'll see the queries currently in cache that are hitting the system hard...

Ninja's_RGR'us (4/28/2010)

---

From instinct here...

Assuming this job has already run succesfully in the past :

1 - Either the permissions changed (NTSF or sql login)

2 - You're out of space on...

GilaMonster (4/28/2010)

---

Part 1: http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

p.s. In SQL 2005, you cannot force an index seek. You can force an index to be used but you have no control over how it will...

The fact is that data is neither stored nor retreived in precise order. Without the ORDER BY, that I'm not telling you to use, you have no guarantee how the...

Have you run consistency checks on the databases? I'd be quite concerned about that. Also, you could try DBCC UPDATEUSAGE. I don't think it'll help, but it's the first thing...