abhisheksrivastava85 (6/2/2011)

---

Thanks guys for your help, somehow i managed to find the optimized solution for finding maximum value on column level. The code which is used is as follows:

select max(MAXValue)

...

Brainwave! Have a read about synonyms and see whether that helps you.

For the joining, use a CTE (Common Table Expression). If you do it like this:

;WITH MyCTE AS...

I don't know any way of aliasing like that, but if you run all commands in the context of the one database, you only need dbo.TableName.

As for only returning the...

Don't shrink your transaction log. It needs to be the size it needs to be. Shrinking wastes resources and causes physical fragmentation on your disk.

It sounds as if...

Or you could keep it ISO, and avoid all those joins, with INFORMATION_SCHEMA.PARAMETERS.

John

No. What makes you think it might be?

If you give us more information on what you're trying to do, we may be able to suggest a better way for...

I don't know what differences there are between the sort orders for those two collations - quite possibly none. However, I do know that if you attempt to join...

Harsha

Try this:

http://www.lmgtfy.com/?q=filegroups

Nobody has mentioned filegroups in this thread, so it's not particularly relevant to the problem you've described. However, it certainly won't do you any harm to do a...

Unallocated (ie free) space in the database including log is 1595MB. Log size is 14MB, of which 6% is used. That means log free space is 94%, which...

Harsha

Use sp_spaceused to get the total free space in the database (includes data and log files). Then use DBCC SQLPERF(LOGSPACE) to calculate the amount of free space in the...

Harsha

Every three months? You've barely got six weeks between the first and last dates. Could the database file be not growing because there's sufficient space in the file...

I take it that the CompName column contains the name of the asset? If so, just remove the WHERE clause - you want to return data for all assets,...

stebennettsjb (5/27/2011)

---

Also if i want the file to delete will putting RETAINDAYS = 7 delete the file after 7 days? or does this only count if do backups to the...

I still don't think it'll help. BackupExec backups create backup files, so they'll appear in the backupset table. BACKUP LOG WITH TRUNCATE_ONLY doesn't create any files and so...

There's a username column in the backupset table, but since the...