I have a mental image of Chewbacca in a bikini

CROSS JOINING? 

Mummy, what's a werewolf?

Shut up and comb your face!

SELECT SUM(Hair)

FROM dbo.AspiringDBA

Produces the same results that it did 15 years ago.  The difference comes when you do

SELECT Location,SUM(HAIR)

FROM dbo.AspiringDBA

GROUP BY Location WITH ROLLUP

..and see NULL against head.

Actually I'm doing...

Do you ever get the feeling that the law is to enrich lawyers and tax law is to enrich accountants?

Someone once wrote that the upper classes make illegal those pleasures...

CHECKPOINT

GO

BACKUP LOG YourDatabase WITH TRUNCATE_ONLY

CHECKPOINT

GO

USE YourDatabase

GO

EXEC sp_helpfile

One you have run the above you should be able to use your DBCC SHRINKFILE on the files listed.

Its a bit off topic but a similar problem exists if you are trying to sell open-source solutions.

Firstly, open-source is mistakenly seens as "free" software.

Secondly, if the software is cheap...

Look on the bright side Frank.  Germans have been voted the most desirable tourists in Europe and British the least!  This means an extra £1,000 on the cost of a holiday...

If you can identify a particular column that will cause a negative result then simply multiply your entire formula by

sign(sign(MyNegativeColumn)+1)

The sign function returns

• LinkedIn Profile