As a first suggestion, run profiler and capture the T-SQL Batchcompleted and StoredProc:RPC completed events. Run it for an hour or so during one of your busy periods. You can...

Faessler Gilles (3/27/2008)

---

Hi,

Currently on the server there is only a full backup of all dbs once a day. No log backups at all. IfI unterstand it right the logs continues...

Snapshot isolation probably will fix the deadlocks, but you do need to check and make sure it will not break any code. You also have to take the impact on...

IN doesn't parse apart a comma-delimited string. The form with a subquery is equivalent to an inner join

Your query

select * from employee where employee_typ in (select [value] from cfg_elements...

Scott Duncan (3/26/2008)

---

Fiddled about with adding ApplicationNumber to IX_Application2, but if you are only querying on one or the other of ApplicationNumber or DocumentNumber (from studying the usage patterns with...

Looks like you may have duplicate jobs. The code you posted that runs 1pm does all that the integrity check and optimisations do. You may be able to disable one...

Do you mean the profiler trace? Or something else?

If you select save to file, you can have the profiler trace written anywhere. If you don't, I think it just goes...

I'll second Kyle's advice. The only time you should consider shrinking a transaction log is if it's grown excessivly large due to some long running transaction.

In general, what you want...

Points are given for writing posts (1 per post writen) and for answering the Question...

Is the category group stored anywhere? If not, have you considered creating a table for the cateory group and adding a foreign key to the InventoryCategory table?

It will make queries...

Those are table variables. Unlike temp tables, the name that they are given in code has no relation to the name assigned in TempDB.

It's also possible that temp tables created...

What's wrong with just this?

select object_name(a.id),a.name,b.name,a.length

from syscolumns a,systypes b

where a.type = b.type

and a.usertype = b.usertype

order by object_name(a.id)

kgunnarsson (3/26/2008)

---

I was under the asumption that this could be avoided by doing full backup and transaction log backup before...

What you're seeing is an automatic statistics update. Nothing to be concerned about.

Just bear in mind that a log truncation breaks the log chain. You will not be able to restore the database to a time after...