It is completely normal for SQL Server to consume all the memory on the box.

More than likely, the reason for the freeze is the other application running on the box....

A slightly cynical point of view with a lot of truth and insight about human nature.

"...Upon this a question arises: whether it be better to be loved than feared or...

A complete list of servers would be handy.

Make sure you have sysadmin access to all the servers.

A list of the databases on each server, what they are used for, and...

Why can't you run a full backup?

Hans Munkwitz (2/25/2008)

---

...My opinion of the cause for this 'discrepancy' is that Microsoft just did not do a full and thorough test of its software (as is the case with...

If they are currently working, why not just continue to run the DTS packages under SQL 2005?

DTS 2000 runtime is included with SQL Server 2005 to run DTS 2000 packages...

"Table-valued parameters are a new parameter type in SQL Server 2008. Table-valued parameters are declared by using user-defined table types. You can use table-valued parameters to send multiple rows of...

Of course, there is probably a check or FK constraint on the column already to make sure it is a valid year, but it doesn't hurt to verify that. 🙂

You may want something like this to make sure the number is a valid SQL Server year.

select case when XYX between 1753 and 9999 then dateadd(yy,XYX-1900,0) else null end

You can't change the maint plan file name.

It's fairly easy to have your restore procedure do a directory comand from xp_cmdshell to find the latest file name to use.

This is a better way to do the WHERE clause to select data for the current year because:

1. It does not have to apply a function to each row of...

You might try creating the index I suggested as non-unique to cover the query. It lets SQL Server treat the index like a table without a bookmark lookup.

As an...

I would go with a check constraint on a column with unique constraint to make sure there can only be one row.

Add a instead of delete trigger to prevent deleting...

Here are a couple of suggestions you could try.

Change the query in your fucntion to this. I think is is also logically better, because it prevents the possibility of...

DHeath (2/15/2008)

---

Hey MVJ,

Not sure if this is asking too much but are those scripts something you have available and willing to share or are they something that i would need...