To show a smiley in SSMS, type the emoji inside an N-prefixed string and run the query. This post explains how SQL Server stores each emoji as two characters, why two different emoji can compare as equal, and how to find them in a column. It also shows what happens when an emoji is part of a database name.
AUTOGROW_ALL_FILES: What Replaced Trace Flags 1117 and 1118
AUTOGROW_ALL_FILES and MIXED_PAGE_ALLOCATION replaced trace flags 1117 and 1118, which once made tempdb grow its files together and use whole extents. This post checks the flags on a server, reads the settings that replaced them and demonstrates both on a demo database. It also says what to do with a startup parameter that still names them.
How to Forecast the Size of Restore of Backup in SQL Server? – Interview Question of the Week #265
Question: How to Forecast the Size of Restore of Backup in SQL Server?
Answer: Recently, I had discussed this in consulting engagement:
Last Query Cost in MySQL: Read It With SHOW STATUS
The last query cost in MySQL is a number the optimizer computes for the last query it compiled, and SHOW STATUS LIKE ‘Last_query_cost’ returns it. This post shows the command on a Sakila query, explains what the number means and where it misleads. It also points to EXPLAIN FORMAT=JSON for the cost of each part of a plan.







