View EnableAllTriggers.sql
CREATE PROCEDURE [dbo].[EnableAllTriggers] | |
AS | |
DECLARE @string VARCHAR(8000) | |
DECLARE @tableName NVARCHAR(500) | |
DECLARE cur CURSOR |
View tasks.json
// Available variables which can be used inside of strings. | |
// ${workspaceRoot}: the root folder of the team | |
// ${file}: the current opened file | |
// ${fileBasename}: the current opened file's basename | |
// ${fileDirname}: the current opened file's dirname | |
// ${fileExtname}: the current opened file's extension | |
// ${cwd}: the current working directory of the spawned process | |
{ | |
"version": "0.1.0", | |
"command": "cargo", |
View launch.json
{ | |
// Use IntelliSense to learn about possible attributes. | |
// Hover to view descriptions of existing attributes. | |
// For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387 | |
"version": "0.2.0", | |
"configurations": [ | |
{ | |
"name": "Debug", | |
"type": "lldb", |
View sp_helpindex3.sql
USE master | |
GO | |
IF OBJECT_ID('sp_helpindex2', 'P') IS NOT NULL | |
BEGIN | |
DROP PROCEDURE sp_helpindex2 | |
END | |
IF OBJECT_ID('sp_helpindex3', 'P') IS NOT NULL | |
BEGIN | |
DROP PROCEDURE sp_helpindex3 | |
END |
View upgrade-jenkins.sh
#!/bin/bash | |
sudo /opt/bitnami/ctlscript.sh stop tomcat | |
cd /opt/bitnami | |
sudo cp -f apache-tomcat/webapps/jenkins.war apps/jenkins/jenkins.war.bak | |
sudo rm -r apache-tomcat/webapps/jenkins | |
sudo rm -r apache-tomcat/webapps/jenkins.war | |
sudo rm -r apache-tomcat/work/Catalina/localhost/jenkins | |
sudo wget http://mirrors.jenkins-ci.org/war/latest/jenkins.war | |
sudo mv jenkins.war apache-tomcat/webapps/ |
View sp_queryplan.sql
--===================================================== | |
-- Author: Jared Dobson | |
-- Date: 12/22/2010 | |
-- Description: Shows Execution Plan for a given spid. | |
--===================================================== | |
CREATE PROCEDURE sp_queryplan ( @SessionID INT ) | |
AS | |
BEGIN | |
SELECT | |
[DEQP].[query_plan], |