There are places that will not consider someone without a bachelor’s degree because a high school diploma is no longer sufficient to demonstrate the most basic of job skills, the...

If you have a whole week to get if from LA to SF, back it up on tape in LA, ship the tape to SF overnight express, and restore it...

You made it too complex....

SELECT TOP 0

*,

[schemaname] = convert(varchar(48),null)

INTO

#sysobjects

FROM

[dbo].[sysobjects]

EXEC('

use master

INSERT INTO #sysobjects

SELECT

*,

USER_NAME(uid)

FROM

[dbo].[sysobjects]

WHERE

[type] = ''U''

')

SELECT [schemaname] FROM #sysobjects

DROP TABLE #sysobjects

You have to update usage to...

It could cause it. What was the size of the largest table that you reindexed?

How about the most common reason? bad application code.

I think one database per user will result in an impossible to administer application and horrible application performance.

You will regret it immediately and every moment after that.

I would ask the developer to explain why this is necessary before proposing a solution.

It doesn’t have the feel of a real business requirement. It sounds more like an...

How about making the backups locally to a tape, and dropping the tape into a FedEx package to ship to a central repository?

The data transfer rate is very high, but...

If you want help with a query, it would help if you posted the actual code of the query.

I think if you look at your case logic, you will realize it did not cover all the conditions. Also, it did not really allow for service that covered...

You should lookat using the new row versioning or snapshot isolation levels in SQL Server 2005 to deal with these problems.

I think you missed the possibility that service start could before the start of the war and service end is after the end of the war.

When checking for date range...

select

[MonthName] = datename(month,a.[Month]),

NumEmp_Curr = sum(case a.CurrentYear when 1 then a.NumEmp else 0 end),

NumEmp_Prior = sum(case a.PriorYear...