- generaly it's not a good practise to create userobjects in system databases. (master, msdb, modeldb)

- also when you create a login or grant connect to a server, be sure...

No ! Because :

- you never know when it's going to decide to shrink.

- the shrink operation will have it's impact on the system and for the users

- your database...

If you choose for the 2-column solution put the columns first which has the most unique values ! So it filters on top of the tree

- as long as you keep in mind that identity may leave you some gaps

- when you use objects with identity in parallel (insert with multiple users) you'll see...

- saving the storage from float to int will save you space in the parent table and in de child-tables !

- indexes based on int will be smaler so they...

just my 2ct

- check the queryplan your delete query is using ! If it shows a scan, you're in troubles.

- provide an index on column Expires to support the delete.

-...

- AFAIK there is no "alter database xyz modify filegroup FG3 set offline"

- Did you take a look at "Performing Piecemeal Restores " in books online ?

- in a...

- Check out Try/Catch in Books online (BOL)

- Scan / Seek see BOL "Table and Index Organization", "Reading Pages ", "Nonclustered Index Structures", "Clustered Index Structures",...

- Keep in mind that what you do within a trigger is "in transaction" ! Timeouts, locking,... !!

- keep in mind there may be more than one row involved in the...

just to add to Michael Valentine Jones ' reply  :

don't forget to throw everyone out of the database befor you try to restore...

1) yes

2) that should be quit easy. At install time there are demo alerts created. They are disabled. If you didn't remove them, they should still be present.

One of them...

.... create a schedule task  ....

I'd prefer to use a sqlagent job, because it captures jobinformation.

Maybe you cannot do this because your system's...

...Could not allocate new page for database tempdb....

You may have been running into a file allocation timeout. Sqlserver only waits for a certain time to receive a "file extended" reply...

the growth of you tempdb must be due to usage of your sqlserver !

Someone running huge queries, grouping-sets or sorting. Keep in mind tempdb is not persistent. Whenever sqlserver is...

- it would look like bad code !

- keep in mind you have no control over the availability of the counterparty !