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.
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.
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.
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.