SQL in Sixty Seconds hits its 50th episode and a full hour of play time. To celebrate, get a free SQL Server Interview Questions and Answers sample chapter.
SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script
How do I return a few chosen rows at the bottom of the entire resultset, in my own order? A T-SQL script on AdventureWorks shows how to do it.
SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049
Old server names clutter the SSMS Connect dialog. This SQL in Sixty Seconds video shows how to remove cached login entries in SQL Server 2012 and earlier.
CROSS APPLY and OUTER APPLY in Everyday Queries
Use CROSS APPLY and OUTER APPLY for per-row functions, reusable expressions, VALUES unpivoting, DMV text, plans, and latest rows.
geometry STArea: Measure the Polygon Interior
geometry STArea measures polygon interior rather than its outline. These local planar shapes show equal areas with different perimeters, a hole subtraction and zero-area instances.
SQL SERVER – Enable SQLCMD Mode in SSMS – SQL in Sixty Seconds #048
Enable SQLCMD mode in SSMS and use sqlcmd right inside SQL Server Management Studio, for example to switch between servers in one script.
SQL SERVER – Fix : Error: 257 Implicit conversion from data type datetime to int is not allowed.
Implicit conversion from data type datetime to int is not allowed. I hit this error with ISNULL and a date, and the fix is right in the message: use CONVERT.