Can you post the connection string that you're using please?

Dunno about the login mde. Take a look at the properties of the server in enterprise manager and see what its...

Your stored proc is written to take 3 parameters and you're passing it 4.

Create procedure dbo.IMPEXPFROMDB

@filepath varchar(255), --filepath

@direction varchar(5) , --direction(In/Out)

@tablename varchar(255) --Valid tablename/viewname

as

...

Exec IMPEXPFROMDB 'databaseTest' 'tableNameOne', 'OUT',...

I prefer stored procs, from a point of code encapsulation. If the sql code is in the db, then I'm able to tune it if necessary. If the SQL statements...

I think you'll get schema stability no matter what. The query has to ensure that the table isn't changing while the query's running.

Why's it necessary in your second process to...

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