Grammar Time With Jen

Kevin Feasel

2016-04-08

Syntax

Jen McCown explains the different between backup and back up:

Let it be known that the word “backup” is a noun (it refers to a thing), and “back up” is a verb (it refers to an action.

  • I’m going to back up the database.

  • It will produce a backup.

  • I’ll save that backup until we back up the database three more times.

Now back up a moment here; I need to come up with a backup plan…

Related Posts

Testing Maximum Rows in Table Value Constructors

Solomon Rutzky dives into how big a table value constructor can be in terms of rows: On 2019-05-08, a helpful individual, Michael B, commented on my answer saying that the 1000-row limit only existed when using a TVC as the VALUES clause of an INSERT statement. And, that there was no limit when using a TVC as a derived table. […]

Read More

T-SQL Tips Regarding Subqueries

Itzik Ben-Gan provides quality information on working with subqueries in SQL Server: In this plan you see a Nested Loops (Left Semi Join) operator, with a scan of the clustered index on Customers as the outer input and a seek in the index on the customerid column in the Orders as the inner input. You […]

Read More

Categories

April 2016
MTWTFSS
« Mar May »
 123
45678910
11121314151617
18192021222324
252627282930