Gus is right.

I think sp_delete_backuphistory is date specific, not database specific, so you may end up throwing the baby out with the bathwater if you use it.

John

First off, if your numbers are stored as characters, the first thing you need to do is CAST them as an integer data type, otherwise you may get unexpected results...

Krishna

The only thing I would say on this is that the collation you mention is for backwards compatibility. You should use Latin1_General_CI_AS instead. I'm afraid I haven't worked...

Lee Sloan (6/3/2011)

---

My point may be tangential to the purpose of the article, but it nonetheless is valid: why do we build systems and processes that allow individuals to contribute...

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