bartread

USE [YOUR_DATABASE_NAME]; -- Substitute for your database name
GO

SELECT TOP 10 -- Change as appropriate
	t.text ,
	s.sql_handle ,
	s.plan_handle ,
	s.total_worker_time / 1000 AS total_cpu_time_millis ,
	s.total_worker_time / s.execution_count / 1000 AS avg_cpu_time_millis ,
	s.total_logical_reads,

bartread

# first:
lsbom -f -l -s -pf /var/db/receipts/org.nodejs.node.pkg.bom | while read f; do  sudo rm /usr/local/${f}; done
sudo rm -rf /usr/local/lib/node /usr/local/lib/node_modules /var/db/receipts/org.nodejs.*

# To recap, the best way (I've found) to completely uninstall node + npm is to do the following:

# go to /usr/local/lib and delete any node and node_modules
cd /usr/local/lib
sudo rm -rf node*

bartread

#!/bin/sh

NODEPROCESSES=$(ps -aux | grep '[s]udo nohup node index.js' | awk '{print $2}')

if [ -n "$NODEPROCESSES" ]; then
	echo "Found node processes $NODEPROCESSES"
else
	echo "No node processes found"
fi

bartread

description "Arcade.ly node.js server"
author      "Bart Read"

# used to be: start on startup
# until we found some mounts weren't ready yet while booting

start on started mountall
stop on shutdown

# automatically respawn

bartread

[Unit]
Description=Arcade.ly Node.js Server
#Requires=After=mysql.service       # Requires the mysql service to run first

[Service]
ExecStart=/usr/bin/node /home/ubuntu/arcade/build/production/index.js
Restart=always
RestartSec=10                       # Restart service after 10 seconds if node service crashes
StandardOutput=syslog               # Output to syslog
StandardError=syslog                # Output to syslog

bartread

#! /bin/sh

# Other deployment actions here. Want to install (or bounce) service last.

if [ -f /etc/systemd/system/arcadely.service ]; then
    sudo systemctl stop arcadely.service
    sudo systemctl disable arcadely.service
else
    sudo \cp -f ./arcadely.service /etc/systemd/system/arcadely.service
fi

bartread

SELECT TOP 30 -- You can alter or ditch this if needs be
	d.[TransactionID],
	MIN(d.[StartTime]) AS StartTime,
	MAX(
		CASE
			WHEN d.[EndTime] IS NULL
				OR d.[StartTime] > d.[EndTime] THEN d.[StartTime]
			ELSE d.[EndTime]
		END) AS EndTime,
	DATEDIFF(

bartread

(function () {
    'use strict';

    pinjector
        .module('starCastle')
        .factory(
            'soundConfiguration',
            [
                'baseAsteroidsStarcastleSoundConfiguration',
                soundConfiguration

bartread

function _initialiseSoundEffects() {
    _loadSounds(soundConfiguration.sounds, true);
    _loadSounds(soundConfiguration.music, false);
}

function _loadSounds(sounds, areSfx) {
    for (var soundIndex = 0, soundCount = sounds.length; soundIndex < soundCount; ++soundIndex) {
        var sound = sounds[soundIndex];

        if (areSfx) {

bartread

function _play(effect) {
    if (!areSfxEnabledFlag || !effect) {
        return;
    }

    var buffer = effect.buffer;
    if (!buffer) {
        return;
    }