Do you have files stored in your SQL Server database and need to see what they are. Here is a way using my favorite add-in SSMSBoost.
Here is an easy way to get (extract) all of the characters before a special character in a string. In our example we have a listing of email addresses and we want to get the name before the @domain.
Starting with SQL Server 2012, Microsoft has included analytic functions within the database. A couple that I use often, Lag and Lead, are very handy when you need to reference a previous or next row in a table without having to use self-joins or having to create a complicated sql statement.
Here is a useful technique to know. We have a delivery service and we want to know what hour of the day is most popular for completed deliveries. Using the DATEPART function, this can be easily calculated.