... source = ' FROM WINDOWS' SET @options = ' WITH ' + @options END ELSE BEGIN SET @source = '' SET @options = ' WITH PASSWORD=''' + @checkmssqlhealth_PASS + ''',' + @options END

PRINT ...

With Excel, I had always found that there was a crual leak with functions : no count distinct !

A simple user function could help to fill the gap.

Here is the code :

Function NbValUniques(laPlage ...

Temperatures taken from this website: https://www.historique-meteo.net/france/rh-ne-alpes/lyon/

This dataset is updated monthly to be updated early september with august temeratures (to be updated ...

... looping over a dataframe and applying a basic (piecewise linear) function: - a "crappy" loop with .iloc to access the data - iterrows() - apply() with a lambda function

But I was a little bit disapointe ...

...  margin: 0.4em; border: none; padding: 0px; background-color: transparent; } div.input_area > div.highlight > pre { margin: 0px; border: none; padding: 0px; background-color: transparent; ...

... multidimensional dataset.

The k-means minimization problem

Let $(x1, ..., xn)$ be a set of $n$ observations with $xi \in \mathbb^$, for $1 \leq i \leq n$. The aim of the k-means algorithms is to find ...

I was glad to see on mssqltips a script to generate column list for table in order to by use in hashbytes function later for table comparison : article with original gethashfield function

But as often ...

... + ' WITH FILE = 1,' SET @vstrExecSQL = @vstrExecSQL + @vstrMoveSQL SET @vstrExecSQL = @vstrExecSQL + ' NOREWIND, ' SET @vstrExecSQL = @v_strExecSQL + ' NOUNLOAD '  ...

... 

   


Calculons maintenant la taille de cet index en colonne :   


   
 

WITH T1 AS ( SELECT OBJECTNAME(i.OBJECTID) tablename, i.name indexname, SUM(css.ondisksize)/(1024.0*1024.0) ...

... 

1 2 3 4 5 6 7 8 9 10 11 12

use with SQLPS.exe

usage sample

C:\"Program Files (x86)\Microsoft SQL Server\100\Tools\Binn"\SQLPS.exe -c D:\shells\ps\EvaluateAvailabilityPolicies.ps1"

  set-location SQLSERVER:\S ...

Sans avoir besoin d'un RAC (Real Application Cluster), d'un grid ou d'un exadata, Oracle fourni en standard un mécanisme de parallelisme très poussé.

Le parallelisme peut se retrouver dans les requêtes ...