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
A fitted drawer belongs to one cabinet while a neighboring cabinet has an empty recess.

SQL Puzzle – Schema and Table Creation – Answer Without Running Code

October 15, 2019
Pinal Dave
SQL Puzzle
Schema, SQL Scripts, SQL Server, SQL Table Operation

This Table Creation puzzle asks for an explanation before you run its code. I suggest examining the batch separators carefully.

Read More
Gouache painting of a wooden kitchen pass-through with an empty tray on one side and a tray with a teapot coming back, a vermilion towel on the sill.

MySQL OUT Parameter: IN, OUT and INOUT in Stored Procedures

October 14, 2019
Pinal Dave
SQL Tips and Tricks
MariaDB, MySQL, SQL Scripts, SQL Stored Procedure

A MySQL OUT parameter lets a stored procedure hand a value back to the caller through a variable. This post tests IN, OUT and INOUT on a small table, shows the error you get when you pass a literal, and compares the syntax with SQL Server.

Read More
A narrow bridge directs the route across a small stream

How to Know If Index is Forced on Query? – Interview Question of the Week #246

October 13, 2019
Pinal Dave
SQL Interview Questions and Answers
Query Hint, SQL Index, SQL Performance, SQL Scripts, SQL Server

Question: How to Know If Index is Forced on Query?

Answer: Let me tell you a brief story so you understand the context of the question.

Read More
Gouache painting of a grid of stacked market crates with one tall vermilion stack

Box Selection in SSMS: Four Edits With the ALT Key

October 12, 2019
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Shortcut

Box selection in SSMS selects vertical text: hold the ALT key and drag the mouse across the text. This post shows four edits that the box makes quick: typing on many lines at once, deleting a column, pasting a column into a column, and moving lines with the arrow keys. Each result is a query that runs.

Read More
Gouache painting of a loom with pale vertical threads and one vermilion thread

Select Vertical Text in SSMS: Alt Shift and Arrow Keys

October 11, 2019
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Shortcut

To select vertical text in SSMS, hold Alt and drag with the mouse, or hold Alt and Shift and press the arrow keys. This post explains what a vertical selection does, how to edit many lines at once and how to turn a pasted column into an IN list. It also shows a T-SQL alternative for long lists.

Read More
Gouache painting of a vase under a glass dome fastened with a vermilion clasp next to an unfinished clay pot

SCHEMABINDING View: What You Can Change in the Table

October 7, 2019
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Table Operation, SQL View

A SCHEMABINDING view locks the columns it uses and leaves the other columns of the table free. This post tests which changes SQL Server blocks, shows the messages and lists the bound columns with a query. It also shows how to change a bound column inside one transaction.

Read More
A hammock depends on two firmly connected supporting trees

What is SCHEMABINDING in SQL Server Views? – Interview Question of the Week #245

October 6, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Table Operation, SQL View

SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition. 

Read More
Previous 1 … 60 61 62 63 64 65 66 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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