You have the rights you can enforce in court.

If someone copies your design and uses it as their own, you would have to be able to prove it was your...

The RESTORE command with the MOVE option is documented in SQL Server 2005 Books Online.

http://msdn2.microsoft.com/en-us/library/ms186858.aspx

Always enter character date strings in the form '20070113' (or '20070113 23:59:59.997' if you need date and time), and you will not have any problems due to language settings.

Are you using 32-bit OS or a 64-bit OS?

When you restore database 2, you cannot use the same physical filenames as database 1.

You will have to specify new physical file names for database 2 using WITH MOVE in...

Thes fastest way to get everyone out of the database before restoring over it is to execute this command

alter database MyDatabase set offline with rollback immediate

This will kick everyone out,...

Whenever you run a SQL Server backup or transaction log backup, it will generate a large amount of paging as data is loaded into the file system cache before it...

I use it any place that you might use a number table.  It's fast enough that I see little need for keeping a permanent number table.  I like being able...

I think the tests done already are getting overwhelmed by the overhead of looping.

I used a different methodology to test.  I loaded a table containing a single money column with...

Obviously what Lindsay said in the post you quoted is wrong, he probably meant Dec 31 to Jan 6 is week 14, not Jan 31 to Jan 6.

Maybe they are following a...

Just do this.  It will kick everyone out of the database, and they will not be able to reconnect, because it will not be available.

Alter database MyDatabase set offline with...

Since you didn't supply any rules for how we could determine what the Fiscal Periods are, I gave you the best I could under the circumstances.

I don't understand why it...

Try this:

select
a.[Date_Idx],
[IsLastDayofPeriod] =
case when a.[Date_Idx] = b.[LastDayofPeriod] then 1 else 0 end
from
[dbo].[DimDate] a
join
(
select
bb.[FiscalYear],
  bb.[FiscalMonthOfYear],
  [LastDayofPeriod] = max(bb.[Date_Idx])
 from
   [dbo].[DimDate] bb
 ) b
 on a.[FiscalYear]  = b.[FiscalYear] and
  a.[FiscalMonthOfYear]= b.[FiscalMonthOfYear]

It would be a lot easier to help you if we knew the data structure and contents of the tables you are talking about.

Could you post the DDL for the...

You're welcome, Veteran!