How big are these image files?

If someone is uploading a huge image file then that will impact on other users.

Do you have some form of created or updated date on...

TRUNCATE TABLE dbo.YourTable

However, the user needs to be in the DDL_Admin role or higher and you can't GRANT permissions for TRUNCATE.

The small chunks example works well and is good for...

If you have a parameter whose sign determines the sort order then you can eliminate the case statement altogether.

select top 10 * from Employee order SIGN(@SortOrder)*job_id

Kalen Delaney's Inside SQL Server 2000 is a good one.

I don't think there is any particular problem with what you have written unless the tables are huge.

I may have this wrong but I'm pretty sure that SQL joins the...

I also dropped all indices before importing data.

The difference in performance is very noticeable. If time allowed I also used to stop MSSQLSERVER and SQLSERVERAGENT and run a disk...

This one caught me out a few times.

When I first switched from SQL 6.5 to 7/2000 I kept on using the sp_addalias procedure to get around this.

However, best practice is...

Well no matter how much I would like to look like Aragorn from Lord of the Rings I just know that I will end up looking like Yoda eventually.

I'm just...

See SQL Server Central's most popular article http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp

Try IS NULL rather than = NULL unless you want to SET ANSI_NULLS OFF

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