I wrote the function in the code below to quickly generate number tables.

It executed this code to load a table with 1,000,000 numbers in 6.780 seconds.  When I ran it to...

I think the wording in the article may be wrong.

It should say that the fill factor should be LOWERED, for example from 95% to 70%.

You said "I still think there are better ways to do this than your above example".  You didn't provide the example of something that would duplicate the function of F_TABLE_NUMBER_RANGE from my...

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?