Skip to content

How to Remove Leading and Trailing Spaces with TRIM Function?

'TRIM Function has haunted SQL DBA for ages. If you have been using SQL Server for a while, you will totally agree with me over here. In this blog post we will see how the new feature TRIM of SQL Server 2017 works in few simple words.

SQL Server DBAs and Developers have always dealt with SQL Strings and the leading and trailing spaces often makes them crazy. Well, personally, I am big believer of data quality and often leading and trailing spaces around strings are not useful.

In the earlier times developers used to two different functions LTRIM and RTRIM around the string to get necessary results. However now in SQL Server 2017 we have a new feature introduced which is TRIM(). This function works just like LTRIM and RTRIM together.'...

https://blog.sqlauthority.com/2018/01/10/sql-server-2017-remove-leading-trailing-spaces-trim-function/

Who is Consuming my TempDB Now?

'Off late my love for TempDB and writing on topics of tempDB has been a great learning experience. The more I work with tempDB, the more fascinated I am. TempDb is being used by a number of operations inside SQL Server, let me list some of them here:

  • Temporary user objects like temp tables, table variables
  • Cursors
  • Internal worktables for spool and sorting
  • Row Versioning for snapshot isolation
  • Online Index rebuild operations
  • MARS (Multiple Active Resultsets)
  • AFTER Triggers and more

'...

https://blog.sqlauthority.com/2015/01/23/sql-server-who-is-consuming-my-tempdb-now/

Silent, Offline Installation for SSDT 15.5 for Visual Studio 2017

'The 15.5 release of SQL Server Data Tools for Visual Studio 2017 is the first release to support SSRS, SSAS, and SSIS in VS 2017. The command line below shows how to install all SSDT components in the only installation of VS 2017 on a machine:

1

SSDT-Setup-enu.exe /install INSTALLALL /quiet /norestart

To work offline, you’ll need to create a layout folder first (just like in previous versions). Use the /layout parameter and specify the folder path where you want the components to be downloaded:

1

SSDT-Setup-enu.exe /layout .\offline

The command above would download the components in a folder called offline. The folder will be created if it doesn’t already exist, and the SSDT-Setup-enu executable will be copied into that folder as well.'...

https://svenaelterman.wordpress.com/2018/01/01/silent-offline-installation-for-ssdt-15-5-for-visual-studio-2017/