The Daily Dose

The Prescription for SQL Server

Apr 19

Interesting New String Functions

By Lori Brown | SQL Development , SQL Server

Here are a few new string functions that I cam across while doing some research.  Just goes to show you that you learn something new every day! STRING_AGG (https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql) This function is available starting with SQL 2017. It concatenates values from rows and places your separator in between the values. Here I create a comma […]

Continue reading
Feb 08

Notification for Restored Database

By Ginger Keys | Backup and Restore , Database Mail , SQL Administration , SQL Server

According to best practices for a SQL environment, you should never place your test or development databases on a production server. However sometimes best practices are ignored, sometimes the DBA’s advice is disregarded (ahem…), or sometimes an organization simply does not have the financial resources to spin up separate servers for testing or development. Whatever […]

Continue reading
Dec 14

Rx for Demystifying Index Tuning Decisions – Part 8

By Jeffry Schwartz | Missing Indexes , Performance Tuning , Query Tuning , SQL Administration , SQL Development , SQL Server

Review Due to the holiday week, this part will be shorter than usual. In Parts 1 through 7 of this blog series the author discussed various aspects of SQL Server indices such as: Types of indices and their variations, e.g., clustered, nonclustered, filtered, and covering Physical versus logical index access methods, e.g., seeks, scans, key/RID lookups, […]

Continue reading
1 2 3 18
>