Part II of finding tables created last week. Readers asked for an easier way, so here is how to do it from the SSMS user interface without writing a script.
Interview Question of the Week #002 – Script to Find Byte Size of a Row for All the Tables in Database
Calculate the byte size of a row carefully, separating declared column limits, actual values, row overhead, and off-row storage.
SQL SERVER – What is the query used in sp_cursorfetch and FETCH API_CURSOR?
Activity Monitor shows FETCH API_CURSOR instead of the real query? I explain what sp_cursorfetch is and how to find the query running behind the cursor.
SQL SERVER – What is is_not_trusted in sys.foreign_keys?
What does the is_not_trusted column in sys.foreign_keys mean? Books Online is not very clear, so I explain it with a simple example using three tables.
SQL SERVER – Iterating over Metadata with BimlScript – Notes from the Field #061
Reeves Smith continues his Biml series and shows how iterating over metadata with BimlScript helps automate repetitive SQL Server BI work.
Filter Memory-Optimized Tables in SSMS: SQL in Sixty Seconds #079
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.










