Index build speed depends on rebuild or reorganize, MAXDOP, ONLINE, SORT_IN_TEMPDB and the recovery model. This post times each choice on a million row table and measures the log under each recovery model. It shows which one changes the clock and which changes only the log.
Forwarded Records, Multiple Backup and SSMS – SQL in Sixty Seconds – Feb 2021
This month’s SQL in Sixty Seconds topics were Forwarded Records, Multiple Backup and SSMS. Here are the videos released in Feb 2021.
SQL SERVER – Get Column Names
I Get Column names using a schema-qualified table and a defined column order. The four methods use corrected filters.
Normalisation in Plain Words, and When to Stop
Understand normalisation through one order example, then decide when a reporting copy is worth the cost of keeping duplicated data consistent.
SQL SERVER – Fix: There is already an object named ‘MyFirstTable’ in the database
Recently I had a very interesting scenario with a client when they faced an error about already object named that exist in the database.
AT TIME ZONE Twice: Convert UTC to Local Time in SQL Server
AT TIME ZONE twice converts UTC to local time in SQL Server. The first use labels a plain value as UTC and the second converts it. A demo shows the common one step mistake, stores in three cities, and the missing and repeated hours of daylight saving.
Multiple Backup Copies Stripped – SQL in Sixty Seconds #156
Yesterday I blogged about SQL SERVER – Creating Multiple Backup Copies. I got an amazing response to the blog post. Let us learn it today.
SQL SERVER – Creating Multiple Backup Files – Stripped
Multiple Backup Files can form one striped backup set. A customer wanted several files for a single database backup.
SQL SERVER – Availability Groups Can Propagate Database Compatibility Level
Propagation of Compatibility Level needs verification on the actual availability-group topology. I compare each replica through its own connection.
Escape Text for JSON: Build Valid JSON With STRING_ESCAPE
To escape text for JSON, pass each value through STRING_ESCAPE, so JSON built by hand stays valid. A demo shows which characters it escapes and which it leaves alone. It also shows when JSON_MODIFY and FOR JSON make it unnecessary.