Generally you need to identify those parts of the query that are costing you the most resources. Looking at the estimated cost on the tiop node, and workinmg down branches...

It sounds like there may be some confusion between a "primary key" and a column with the property "identity". These are not the same thing..

If the column is marked as...

The error message states you are running the "Enterprise evaluation edition" - all the eval editions are time restricted. You will need to install a full version to replace it....

You can use a UNC path name fo rthe backup file :

backup database foo to disk='\\myserver\sharenam\foldename\foo.bak'

But frequently it is better to back up to a local disk and then...

This is really an area you need to read the full detail and understand the implications of your decisions.

If you search in BOL for "tail-log" the first hit should...

If I understand the original post correctly the poster is asking how a diff backup can only take changed parts of the db?

As part of each physical db file there...

Before you start the restore sequence take a backup of the current log. this assumes you can get to the log - which is why raid 1 for logs is...

If read your post correctluy you are confirming that you ar ebacking up to the SAME drive daily. If you mean the same drive as the dat athen this...

I would be somewhat worried by a backup time that long for the databs size you are working with. Obviously this depends largely on the disc systems you are working...

I suggest the first thing to check is to see if anyone has created something large in Model, which will then be automatically created in tempdb. Crerating a new empty...

Not sure what you bean by detect the leap year - your code seems to be using a fixed 28 day window rather than anything to do with months (specifically...

When SQL Server was installed one of the options was what account does SQL Server run under. This can be things like "local system", a local Windows account or a...

If possible I would also review the design. Having TWO values in a single column is normally (dare I say always?) not a good thing to do. It would appear...

I think you may be confusing the FULL recovery model with FULL database backups - and switching recovery models back and forth between full and simpl,e is probably not the...

That makes sense - one of the requirments of file./filegroup backups is the availability of the transaction logs to ensure the db is restored to a consistentstae. Thus iof you...