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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.