This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - Finding Tables Created Last Week - DBA Tip Part II

SQL SERVER – Finding Tables Created Last Week – DBA Tip Part II

January 12, 2015
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Table Operation

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.

Read More
Wooden drawers hold bundles of different sizes, illustrating variable row sizes

Interview Question of the Week #002 – Script to Find Byte Size of a Row for All the Tables in Database

January 11, 2015
Pinal Dave
SQL Interview Questions and Answers

Calculate the byte size of a row carefully, separating declared column limits, actual values, row overhead, and off-row storage.

Read More
SELECT top 3.

SQL SERVER – What is the query used in sp_cursorfetch and FETCH API_CURSOR?

January 10, 2015
Pinal Dave
SQL Tips and Tricks
SQL 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.

Read More
FK table in foreign keys.

SQL SERVER – What is is_not_trusted in sys.foreign_keys?

January 9, 2015
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table

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.

Read More
BimlScript connections.

SQL SERVER – Iterating over Metadata with BimlScript – Notes from the Field #061

January 8, 2015
Pinal Dave
SQL Tips and Tricks
BIML, Notes from the Field, SQL Server Security

Reeves Smith continues his Biml series and shows how iterating over metadata with BimlScript helps automate repetitive SQL Server BI work.

Read More
Gouache painting of blue blocks passing through matching shaped openings while grey blocks remain in a separate compartment.

Filter Memory-Optimized Tables in SSMS: SQL in Sixty Seconds #079

January 7, 2015
Pinal Dave
SQL Video
In-Memory OLTP, SQL in Sixty Seconds, SQL Server Management Studio, SQL System Table

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.

Read More
Gouache painting of an extended wooden house model beside architectural drawings and spare building pieces.

Schema Change Reports in SQL Server: SQL in Sixty Seconds #078

January 6, 2015
Pinal Dave
SQL Video
SQL Extended Events, SQL in Sixty Seconds, SQL Server Management Studio, SQL Trace

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.

Read More
Schema changes history window.

SQL SERVER – Finding Tables Created Last Week – DBA Tip

January 6, 2015
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

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.

Read More
SQL SERVER - Filter In-Memory OLTP Tables in SSMS

SQL SERVER – Filter In-Memory OLTP Tables in SSMS

January 5, 2015
Pinal Dave
SQL Tips and Tricks
In-Memory OLTP, SQL Scripts, SQL Server Management Studio

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.

Read More
Two brass pegs align with two matching sockets in one joint

Interview Question of the Week #001 – Script to List Foreign Key Relationships and Constraint Name

January 4, 2015
Pinal Dave
SQL Interview Questions and Answers
SQL Constraint and Keys

List foreign key relationships with schema names, matched columns, referential actions, and trust flags using SQL Server catalogs.

Read More
Previous 1 … 276 277 278 279 280 281 282 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com