Backups!

We don't need no steenking backups!

Tom.Thomson (2/18/2010)

---

This is a very good article indeed. Something every new DBA or would-be DBA should read and take to heart.

The only thing that doesn't come across clearly is...

I would say that you don't need in-depth application knowledge to tune SQL performance at all.

You do need to figure out why the query is written the way it is,...

This is a crack at it. Not really sure if it's what you need.

Forgive typos & assumptions.

select

i.[Image name]

,a.*

,d.*

from images i inner join ref r on i.ID=r.ID

left join...

I usually use COALESCE but ISNULL is easier to spell.

Thanks!

Good question, btw. lots of people haven't seen this trick and it's incredibly useful for generating D-SQL and...

Nice work on the article.

Very nice.

One of the post-migration steps I always take is to run a full update stats on the DB.

That might help.

Mitch,

It seems like a good first crack at it.

The big resource hogs will be ETL and cube processing sucking up disk and RAM.

Reporting can be a big load, but...

I'd love to help but I'm having a hard time understanding the problem.

Try to create a scenario for us to work with so we can understand the problem.

here are the...

The last command and wait type is WAITFOR

which means the process is using the WAITFOR command and waiting for a specific period of time before it performs its...

Lock pages in memory is not required by x64, but it doesn't hurt to add it.

It will prevent the OS from paging out SQL Server memory when under memory pressure.

This...

DegreeOfParallelism="0" means unlimited parallelism (up to number of procs)

I do also note that parallelism = "false" in the xml of both. Not 100% sure if it means what we...

good call on disk alignment.

I...

despite my moral opposition to soft deletes I think you could maybe use a try catch block to accomplish what you need. We warned It's pure ugly hackery and...

I should mention that you'll need to revoke everything first.

The way I do it, which is admittedly awkward is to run the script on the DB you want to blow...