The FairTax is not a VAT because it is only charged to the final retail consumer.  Neither manufacturers nor their suppliers would pay federal tax.

To (hopefully) clarify 30% vs 23%:...

There is no exemption under the FairTax, there is a monthly check to refund the tax amount paid on a poverty-level income for your family size.  This check, referred to...

You don't have to provide an email address to read the FAQ section of the http://www.fairtax.org site, and if you want more details the Research and Rebuttals sections.

There is...

Go to http://www.fairtax.org and learn how we can get rid of the IRS.

You are more likely to get optimum execution plans in some situations if varchar fields are declared with expected max values, rather than just using 255 or 8000 or MAX...

Full backups do not affect the transaction logs.  Either a database is in simple recovery mode where log records are released as soon as a transaction completes, the log is...

Sometimes I use the "Check SQL" button to get the table creation SQL, copy that to another editor and play with it.

You can do a global search-and-replace to change all...

These files are just used a templates to create a new distribution database.  If you set up replication it will create a new database with new files, the distmdl files...

I used almost the identical script Kevin posted for comparing the methods, but you have to put one empty loop in to find the baseline time for the incrementing & looping...

It's true that only the actual data is stored, so a row can be defined with many varchar(8000) fields as long as the total row size fits in 8060 bytes,...

I was originally going to suggest a WAITFOR DELAY '01:00:00' step in the package, but the amount of scripting you have to do in DTS to get it to go...

I did some testing on our oldest, slowest server and found the datediff/dateadd method squeaks past the floor(cast as float) method by 1 microsecond (3 microsec vs 4 microsec), while...

You could use sp_update_jobschedule to add an hour and exit if there was no new file, then after a successfull download reset the schedule to 5:30.

I assign database rights based on domain groups, but I rarely see SQL Server admit that anyone new belongs to the domain group.  I think the SQL server is using...

The solution you have is reasonable, but there are many variations.  I usually cast the date to a float, truncate it, and cast back to a date.

SELECT CAST(FLOOR(CAST(@x AS FLOAT))...