You can filter memory-optimized tables in SSMS Object Explorer, or find them with one query on sys.tables. The tests here build a database with both kinds of tables, show how durability and memory use appear in the catalog, and list the gotchas.
Schema Change Reports in SQL Server: SQL in Sixty Seconds #078
Schema change reports show which tables, views and indexes were created, altered or dropped recently. The tests here read the default trace behind the SSMS report with T-SQL, show what it misses, and set up an Extended Events session for longer memory.
SQL SERVER – Finding Tables Created Last Week – DBA Tip
A security team wanted a report of tables created last week on production. Here is the simple query I sent my DBA friend instead of building an audit.
SQL SERVER – Filter In-Memory OLTP Tables in SSMS
Need to spot In-Memory OLTP tables among thousands of tables? I show a simple T-SQL query and the SSMS options that list only those tables.
Interview Question of the Week #001 – Script to List Foreign Key Relationships and Constraint Name
List foreign key relationships with schema names, matched columns, referential actions, and trust flags using SQL Server catalogs.
SQL SERVER – UNION With TEXT DataType Returns Error but and UNION ALL Works – Reasons
Why does UNION with TEXT datatype return an error while UNION ALL works? It comes down to how UNION removes duplicate rows. Here is the reason.
SQL SERVER – Fix – Missing “Mirroring” and “Transaction Log Shipping” option in the Database Properties
The Mirroring and Transaction Log Shipping options were missing in Database Properties for my freshly created database. Here is what caused it and the fix.