Pages

▼
Showing posts with label SQL Server 2017. Show all posts
Showing posts with label SQL Server 2017. Show all posts
16 February 2025

💠🛠️🗒️SQL Server: Columnstore Indexes [Notes]

›
Disclaimer: This is work in progress intended to consolidate information from various sources. It considers only on-premise SQL Serve...
20 October 2023

💎🏭SQL Reloaded: Extended LTrim/RTrim in SQL Server 2022 (Before and After)

›
In SQL Server 2022, the behavior of LTrim (left trimming) and RTrim (right trimming) functions was extended with one more string parameter...
19 November 2022

💎🏭SQL Reloaded: Tricks with Strings via STRING_SPLIT, PATINDEX and TRANSLATE

›
Searching for a list of words within a column can be easily achieved by using the LIKE operator: -- searching for several words via LIKE (...
30 October 2018

💠🛠️SQL Server: Administration (Troubleshooting Login Failed for User)

›
    Since the installation of an SQL Server 2017 on a virtual machine (VM) in the Microsoft Cloud started to appear in the error log records...
26 October 2018

💎🏭SQL Reloaded: Trimming Strings (Before and After)

›
One of the annoying things when writing queries is the repetitive lengthy expressions that obfuscate in general the queries making them more...
18 June 2017

💠🛠️SQL Server: Administration (Database Recovery on SQL Server 2017)

›
I installed today SQL Server 2017 CTP 2.1 on my Lab PC without any apparent problems. It was time to recreate some of the databases I used ...