SELECT SQL Select SQL and upgrade your performance

Details

Written by Petr Slaba

Parent Category: MSSQL

Published: 15 June 2017

Last Updated: 15 June 2017

Hits: 17506

When you alter view or stored procedure and you realize, previous version wasn't saved and you need it. Or you want recover SQL script immediately after management studio crash and you were lucky, that you run it at least once. There is a nice tricky way how do to it by SQL script without any 3rd party enhancement. 

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 04 April 2017

Last Updated: 11 April 2017

Hits: 75870

Sometimes it can happen, that you compare two strings, which looks exactly sames, but they are processed as not equal. Also when you use SELECT DISTINCT and still there are rows that looks same, like DISTINCT is not working. Dimensional attribute in OLAP can return errors for duplicities even you used DISTINCT for dimension. This is the right time to search invisible/hidden characters in string.  RTrim and LTrim function not stripping whitespace.

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 03 April 2017

Last Updated: 03 April 2017

Hits: 26563

In case you need create list off all dimensions used in cube on Microsoft SQL server, with list of all dimension attributes. There is easy and simple way how to do it with query.

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 05 January 2017

Last Updated: 03 April 2017

Hits: 31560

If you need calculate week number from date, you can use DATEPART with parameter ISO_WEEK. Unfortunately there is nothing like ISO YEAR parameter. In case you need to show YearWeek value in some report you have to take care about correct value manually.

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 01 February 2016

Last Updated: 01 February 2016

Hits: 17492

Are you looking for simple way, how to get count of distinct values for each column in a table on MS-SQL database? There is a simple script with solution to help you.