This sounds similar to an IT fad of the past, Decision Support Systems.

I remember being at a meeting with the company president where we were asked to introduce ourselves and...

The function on the link below is designed to load a date dimension table for any range of dates that you supply.  It contains over 60 columns of date attributes.

It...

The method I use is to capture at least three different workloads, and look at the index recommendations from each one.  Then I create only the indexes that were recommended...

I tested the methods you suggested under SQL Server 2005 Developer Edition using a table with about 5,000,000 rows of randomly generated datetime values in the range of 1753-01-01...

This link below has my own procedure for generating a somewhat mnemonic password, as well as several others for generating random or semi-random passwords:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78859

It is an interesting problem, because...

This code has a built in assumption that the year 6 is in decade 2000 to 2009.  You didn't really say what your rules are for knowing the decade, so...

The dbcc dbreindex always updates the statistics.  You can confirm this yourself by running this simple test in the pubs database, and looking at the statistics date before and after...

The check constraint is a bad idea.

Even if you fix the obvious bug in the check constraint, the contraint would prevent you from updating a row once the current system date...

One big problem with multiple databases is maintaining referential integrity.  If your Customer table is in one database and another database has a reference to the Customer table, you cannot...

I am aware there are workarounds.  However, this is not a problem that should not be happening.

I post at other forums where I have never seen this happen.  For example, I have never...

Remember that security has a number of aspects.

One is preventing people who shouldn't be able to do things from doing them.

Another is making sure that you have the data and...

I thought the puzzle was BS also and I still do.  Hence, my NZDF answer.

Someone has to have the power to manage the system and the databases, so if they don't trust you or other internal people, maybe they could contract with an...

SQL Server uses last binding, meaning that tables a stored procedure or script references do not have to exist when it is compiled.

You don't need it for the code you showed.  This runs just fine for me:

declare @count int

if exists (select 'x' from sysobjects where name = 'mytable' and type = 'u'...