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...

On a side note, foreign keys are for data integrity. They have little effect on performance. It's indexes that you need to look at to really alter performance.

I can't tell you specifically why truncate is allowed and not delete when you give the alter permission, but you're wrong about rollbacks. Truncate can be rolled back.

Applying hints is absolutely the last step in any tuning process. All you're doing is forcing the processor to only use that index for access, but because of the rest...

The buffer pool is basically all remaining memory. You can't really manage it at all beyond setting the min & max values. Other than that, you manage how data is...

I don't entirely understand the issue. Are you saying that you're running perfmon across the network to collect data? Generally, this is not an approach I use. Instead, I'll run...