The Collatz conjuecture is deceptively difficult, that's why it remains unsolved.

Yes, 3n+1 converts an...

would think that being hired at $80k to be a DBA and then paying someone else $40k to be the DBA for you, giving you $40k of profit, would...

This line in the article struck me:

In the context of coursework this is true because the point of coursework isn't...

I don't know of any rule of thumb but the first thing to consider is that if the real data size is 100G then the mdf will need to be...

A good introduction to the alternatives, but I take exception to the statement that "it is impractical to create new views for every query you write." Certainly, you wouldn't...

Tom,

Much clearer. Thanks for the response.

--

JimFive

The difference between 2NF and 3NF is that 2NF does not permit any non-prime attribute to have a dependency on something which is a proper subset of a candidate key,...

Tom,

Thanks for the series, it has been very interesting thus far.

However, I think more distinction needs to be made between 2NF and 3NF. The example seems to be about...

This is a guess based on the Truncate example.

Your Cursor is based on the same table that is being updated in the INSERT and Update statements. The Cursor is...

I just encountered this error.

The steps were

Begin Tran

TRUNCATE Table1

INSERT INTO Table1(Columns...)

SELECT Columns From Table1Backup

This would give the error at the INSERT statement

Changing the Truncate Table to DELETE FROM Table1 ...

When I first read this article I was surprised by the statement that having a list in a column could be 1NF if the database was never asked to process...

- Each backup should have its own unique password.

...

- The method of password generation must not be directly related to...

- Physically unconnected methods should be used for storing the backups...

I've not been responsible for backups for a long time, but here's how I think it should work.

Each backup set gets assigned a strong generated password that applies only to...

Ideas:

1) Are you dumping your results into a text file of some sort? If so, it might be easier to this in a post-processing script on the text file.

1b)...

You can try following scripts to shrink your database which I am using. However I only work with database having one ldf and one log file in MSSQL 2008.

Replace DB...