You cannot remove guest from either master or tempdb.

If you remove it from MODEL then it won't appear in any future databases that you add to the system. MODEL...

I start with the assumption that I need a TEMPDB three times the size of my largest table.

If I have to do a large sort or reindex TEMPDB grows...

If you don't specify otherwise a primary key will be clustered. If the columns that you are proposing to become primary keys are not naturally ordered then having them...

Read http://www.sqlservercentral.com/columnists/dpeterson/lookuptablemadness.asp

If you use foreign keys then I can see the potential for performance issues when it comes to deleting records.

If you look at the execution plan of a...

I've reached the age when I time things with a calendar.

There is a great story about one of the old British colonies where the accuracy of the town clock was...

I can't see a better way around the need to have a field per table.

If your database design allows there to be a "common properties" table then your UpdatedDate field...

My SQL Script File is as follows

use master

go

------------------------------------------------------------------------------------

-- If the backup device already exists then drop it and recreate it

------------------------------------------------------------------------------------

IF EXISTS(SELECT 1 FROM sysdevices WHERE name='epos_Backup')

exec sp_dropdevice 'epos_Backup'

GO

exec sp_addumpdevice 'disk','epos_Backup','D:\Epos\BACKUP\DW_EPOS.BAK'

GO

--...

The roles that can DROP a table are DBO, DDL_Admin, obviously the SA login and other members of the SysAdmin role.

Provided your user is not a member of such roles...

I think you also need to consider the @@DATEFIRST setting which determines which day of the week is considered DAY 1.

For example US English Sunday is Day 7. For...

Innovasys DocumentX and Apex SQL Doc both do it.

If you are only interested in SQL the Apex SQL Doc is the most detailed.

If you want something that also does Access,...

Just as a matter of interest SQLBill do you use the straight SQL Backup or do you use a tool such as SQL Litespeed?

Why not

SELECT CAST(CAST(GETDATE() AS INT) AS DATETIME)

The advice to backup the database after doing a truncate_only is because truncate_only removes checkpointed transactions from the log and therefore you have lost your ability to restore to a...

Sam, I'm with you on this but I would say there is one over-riding cause of all project failures and that is a break-down in communication.

It doesn't matter if it...

I've lost count of the number of times I've sat through a recording of a TV show, adverts and all and then had either one of two thoughts

a) Hang on...