How big are the tables in question? How many pages do the indexes take up (visible in sys.dm_db_index_physical_stats)

Edit: btw, a separate update statistics is not necessary (and may even be...

I usually just grab the login time for session_id 1. iirc it's the resource monitor. It will always be there.

Chad: How do the CPU_BUSY and IDLE relate to real time...

No. They're the equivalent of shared and exclusive locks for the table structure. Sch-S...

Not directly, but you can get the login time of any of the system processes from sys.dm_exec_sessions. Since all the system processes start when the instance starts the login time...

What kind of queries are they? If they're deadlocking, I assume some form of data modification (since readers don't block readers) Data modification (insert, update, delete) will always take locks....

I haven't seen any book that does 'query tuning in 24 hours' or...

It's your site. You can do...

First thing I'd suggest it normalise your tables 🙂

If you have a table of users, then finding the unique users is much simplified. Perhaps a table for the questionaires (or...

What does the query look like now? From a quick glance

AND tb4.ID NOT IN (SELECT DISTINCT tb7.ID

FROM Tbl_Tmp_Trace tb7

WHERE tb7.Estadoid = 3094610094

AND tb7.Tipo = N'Chamadas')

should go to

AND NOT EXISTS (SELECT...

The backups might be safe to compress. The data and log files are another matter.

Only read-only filegroups can be placed on compressed drives and transaction log files should never be...

Looking good.

You may want your tran log backups more often. Maybe once every 2-12 hours, depending how many transactions there are. How often are your full/diff backups.

Once the log has...

And they have security implications. Dynamic SQL has its place, but it has a number of downsides.

Is the database in full recovery mode? Do you have any transaction log backups running?

Full backups don't truncate the inactive portion of the log. Only a transaction log backup does...

Looks like you're trying to use SQL authentication to a server that's configured for windows authentication only.

Can we see the table schema, indexes and the full execution plan please. Is nearly impossible to say anything for sure without those.

Since you're on SQL 2005 (I assume so...