A quick query on sys.tables with SCHEMA_NAME() that lists the schema name and table name of every table in a database, in bracketed form.
SQL SERVER – 2008 – SSMS Feature – Multi-server Queries
SSMS 2008 lets DBAs run one query against many servers from one window. Here is how multi-server queries work, a tip from my TechEd India session.
SQL SERVER – Effect of Normalization on Index and Performance
Normalization organizes data dependencies, while indexes support access paths. I evaluate their performance effects through the actual workload.
SQL SERVER – 2008 – Customize Toolbar – Remove Debug Button from Toolbar
SQL Server 2008 brought the debugger back, and its button sits right next to Execute. Here is how to customize toolbar buttons and remove the debug button.
Preventing Overbooking When Two Sessions Grab the Last Seat
Learn preventing overbooking through a last-seat race, an atomic update, update locks, and a database constraint that rejects oversold inventory.
Errors TRY CATCH Cannot Catch: Compile, Name and Severity Errors
Learn which errors TRY CATCH cannot catch, test execution scopes safely, and pair transaction cleanup with caller timeout handling.
Your First Extended Events Session
Build your first Extended Events session for slow SQL calls, choose a bounded ring buffer or file target, and read the captured result.