A Haynes manual is a maintenance guide for a car based on a complete strip down of a vehicle.

In theory you could buy a Haynes manual and completely rebuild your...

I would put the SELECT and FROM part of the query in a view so that your SQL string is as small as possible.

sp_ExecuteSQL does at least grant the possibility...

You could convert the date to a number first

SELECT * from dbo.MyTable ORDER BY SIGN(@sortOrder)*CAST(MyDate AS REAL)

I'm not sure about strings.  I have a feeling that your options are to...

Cool, hip, stylish and VERY dangerous.

I have a friend who restored one of the original FIAT 500s and those have the fuel tank under the dash!  Free cremation with every...

Sorry Frank, is it also the former Trabant or are they still made?

I am not a fan of MS Press books.

It may be an obsolete prejudice but I see the existence of 3rd party books as proof that the manufacturers own manuals...

Not sure what will happen to your existing stored procedures if you follow the renaming route.  I suspect that every stored procedure using your table will recompile so there could...

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