Basically all your tables relate on the accountId field.

So tblBorrowerAddress.AccountID = tblAccount.AccountID and tblAccount.AccountID = tblBorrower.AccountID

A human being will infer that tblBorrowerAddress can be linked to tblBorrower but a computer...

Put SET DATEFORMAT YMD at the beginning of your procedure

I'm not sure that switching to 'Simple' mode would have the desired effect.

All activity is logged, all simple mode does is truncate the log by removing checkpointed transactions.  I would...

Think of it as a parent/child relationship if that isn't too Freudian.

An employer is a parent the child is the employee.

The customer is the child of contact 4.

Your tbl_relationship table...

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.