Step 1 would be to get into the habit of using the 2 part naming convention.  That doesn't have so much to do with performance in this case (although there...

I agree with Phil.  Posting inserts to populate the test table with data will help a whole lot.

Also, the code you posted isn't from SQL Server but, since you posted...

Sorry... second look at the code I posted said it was wrong and took it down.

The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team asking question...

If you are only moving the application databases (not the system databases). You can just detach the databases, move the database files to a different location then...

Just remember... your favorite bloggers may not actually be correct. 😉

My recommendation is this... go to all of the BBFAATT (a "Moden-ism for Books, Blogs, Forums, Articles, AI, Talks, and 'Tubes and is pronounced as "bee-bee-fat" and can be bleated...

As a bit of a sidebar, renaming backup files destroys the ability to use the backup information stored in MSDB for research.  If you want to name something, it should...

My...

I've found out the hard way in my early days that "Moving the Files" <> "Successfully moving the database".

If you are only moving the application databases (not the system databases). You can just detach the databases, move the database files to a different location then just Attach...

Who who or what was it that wrote "Reorganizes or Rebuilds index to optimize data base performance"?  The human author or the AI? 😀

Anyway, thanks for the article, Daniel.  I...

If I am interviewing for a new position, I always ask if I can be shown round the office and see some of the team. Whether existing people are...

Between that and the GENERATE_SERIES()  defeating Minimal Logging (article coming out on that on the 18th) and the DATETIME rounding issues into the next day that started in...

Sorry.  Post deleted.