... 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 ...

... duit lorsqu'il il a deux jeux de processus parallèles.

PCWP Parallel Combined With Parent Un opération qui est exécutée en parallèle par les mêmes processus qui s'executent sur l'opération mère (dan ...