In short, yes. The first it two seeks against the table (assuming appropriate indexes), the second is a join between two tables, might be a loop join, might not.

The difference...

Not offhand, but you can get a quick and dirty check by copying large files from one say the backup drive to the data drive and see how long it...

You're not going to get the desired output with a join, left or right.

I don't know what bo universe is, If it accesses SQL server, can you put the code...

Version probably not much of a difference. Backup and restore are IO-bound operations. Test the kind of IO throughput you get on the VM, compare to the physical server.

Backup and restore times are mostly a function of IO throughput. Do the VMs and the physical server have the same IO capabilities?

You can't just change an APPLY to a JOIN and expect the same results, you won't get them.

An APPLY runs the query once for each row of the outer query,...

It's the plan 'shell' for the SELECT, it's not a complete plan. It's kinda a pointer to the parameterised form of the plan.

http://daleburnett.com/2011/08/forced-parameterization/

nadersam (3/30/2016)

---

yes you are right off...

Varchar(max) is a very different data type. It's got additional overheads because it's off-row data, It's definitely not something you'd use on all columns.

Hugo Kornelis (3/29/2016)

---

I am currently involved in several projects where data is converted from one system to another, and you won't believe the cr*p I encounter. City names in the...

Won't change things much. Rebuild still creates the new index and drops the old. The only thing that moves to TempDB is the sort space required.

Aggregate function.

https://msdn.microsoft.com/en-us/library/ms173454.aspx

GROUP BY isn't an aggregate, it's a clause in the statement that defines what columns the aggregates are computed by.

The first of the month.

01-Jan-15 is a valid date. Jan-15 is not.

With a cast to DATE in the middle

DECLARE @halfDate NVARCHAR(6) = 'Dec-15'

SELECT DATEname(MONTH, CAST('01-'+@halfDate AS DATE)) + ' ' + CAST(YEAR(CAST('01-'+@halfDate AS DATE)) AS VARCHAR(4))

Not sure if it's cleaner though.

Neither of those statements are true.

Using AdventureWorks

Valid:

SELECT CustomerID, SUM(TotalDue) FROM Sales.SalesOrderHeader

GROUP BY CustomerID, SalesOrderNumber, TerritoryID

Valid:

SELECT CustomerID, LEFT(SalesOrderNumber,5), SUM(TotalDue) FROM Sales.SalesOrderHeader

GROUP BY CustomerID, SalesOrderNumber, TerritoryID

Any column referenced in the...