The link I supplied is production code in use at my company and I believe a number of others.  If you want some more examples of how it is used,...

The probable reason for wanting you resign is so you can't collect unemployment.  If they lay you off or fire you without cause, you would be eligible to collect unemployment. ...

I think this is a better solution.

It will be faster than a UDF.

It is easier to scale up to as many columns as you need than using a CASE statement,...

I gave two examples where a cross join could be used in my first post.

It is common to have a table with configuration or default information with a single row.  To add...

There is no reason to assume that the amount of SQL Server memory usage is related to the page file usage.

Take a look at the Performance Monitor, Process, Working Set...

Everyone is making this too hard.  Do it this way, it will make it impossible for anyone to be in the database becase it will be offline.

use master 
go
alter...

Cross joins have their place, and are not something that you should avoid.  Like anything else, they should be used when and only when they are needed.  The same is...

I recently had a discussion with a recruiter where I told him I didn’t want to interview a candidate because of the poor English in the resume: misspellings, bad punctuation,...

We follow this naming convention, and actually enforce it.

Table name:
T_entitynameExample: T_ORDER_ITEM

Identity Column Name:
entityname_IDExample: ORDER_ITEM_ID

Primary Key Name (name of the PK constraint, not the column)
PK_tablenameExample: PK_T_ORDER_ITEM

A cross join is used when you need to join without a join condition.  One case would be when you have a table with a single row.

Another case would be...

Lots of developers try to blame the poor performance of their poorly designed and implemented queries on some “black art” or “unknowable mystery” deep within the database engine.

Really, it’s just...

>> Something happened by itself.

That's extremely unlikely.

Who was the database owner before this happened?

It looks like there is no problem; all the tables are empty.

The biggest hole in the Business Intelligence paradigm is that it assumes that there is some consumer for the system who will be able to use the information provided to...

Those error could not have come from the script on that link.

The errors are coming from some create table statements that you must have added.