swaters86

 select count (*)
  --update aa
  --set aa.Sist_endret = cast(aa.dato as datetime),
      aa.Opprettet = cast(aa.dato as datetime)
  from web.dbo.Artikkler_hode aa
    left join web.dbo.Artikkler_status (nolock) bb
      on (bb.Avis =aa.Avis and bb.Dato=aa.Dato and bb.Kategori=aa.Kategori and bb.Lopenr=aa.Lopenr)
  where bb.Avis='DA' and bb.CreatedBy='mfxfeeder' and convert(varchar(8), aa.Opprettet, 112) > aa.dato
    and aa.Dato <> '99999999'

swaters86

package calculatewindchillindex;
import java.util.Scanner; 

public class CalculateWindChillIndex {
    
    public static void main(String[] args) {

        Scanner input = new Scanner(System.in); 

        // GETTING USER INPUT 

swaters86

/*
First Pane
----------------------------
background -   processes running in the background 
runnable   -   processes currently running - this number shouldn't get to high 
sleeping - processes that are sleeping 
suspended - processed that are suspended because of the runnable processes - This number shouldn't get to high 


Second Pane

swaters86

-- Get CPU Utilization History for last 256 minutes (in one minute intervals)
-- This version works with SQL Server 2008 and SQL Server 2008 R2 only
DECLARE @ts_now bigint = (SELECT cpu_ticks/(cpu_ticks/ms_ticks)FROM sys.dm_os_sys_info); 

SELECT TOP(1024) SQLProcessUtilization AS [SQL Server Process CPU Utilization], 
               SystemIdle AS [System Idle Process], 
               100 - SystemIdle - SQLProcessUtilization AS [Other Process CPU Utilization], 
               DATEADD(ms, -1 * (@ts_now - [timestamp]), GETDATE()) AS [Event Time] 
FROM ( 
   SELECT record.value('(./Record/@id)[1]', 'int') AS record_id, 

swaters86

http://www.troyrecord.com/new-york-troy

Navigation Profile: 4004092

<!-- exec custom.dbo.GetStoriesForTop @Sites='TR,ZZ', @DataSite='TR', @Count=5, @Days=30, @ExcludeGUIDS = '', @Position='sectiontop5', @DynamicRootProfile = 4004124, @PublicationTaxonomy = 102413, @GeoTaxonomy = 'N/A', @Frontpage = 0; -->



http://www.troyrecord.com/news

swaters86

set clustercode=%1

set environments_string=%2

for /f "tokens=*" %%a in (%environments_string%) do (

	 set environments=%%a

) 

swaters86

/*
truncate table shared.dbo.cachestorage_JRC_BM
update shared.dbo.CacheStorage_JRC_BM_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_DC
update shared.dbo.CacheStorage_JRC_DC_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_DF
update shared.dbo.CacheStorage_JRC_DF_permanent set [Timestamp] = DATEADD(d, -30, getdate())

truncate table shared.dbo.cachestorage_JRC_DL
update shared.dbo.CacheStorage_JRC_DL_permanent set [Timestamp] = DATEADD(d, -30, getdate())

swaters86

/*

============ Start 3 ===================

truncate table shared.dbo.cachestorage_mn1_LA

update shared.dbo.CacheStorage_MN1_LA_permanent
set [Timestamp] = DATEADD(d, -30, getdate())

swaters86

/*
update aa 
set aa.Sist_endret = cast(aa.dato as datetime), 
aa.Opprettet = cast(aa.dato as datetime) 
*/
select count (*) 
from web.dbo.Artikkler_hode aa 
left join web.dbo.Artikkler_status (nolock) bb 
on (bb.Avis =aa.Avis and bb.Dato=aa.Dato and bb.Kategori=aa.Kategori and bb.Lopenr=aa.Lopenr) 
where bb.Avis='WC' and bb.CreatedBy='mfxfeeder' and convert(varchar(8), aa.Opprettet, 112) > aa.dato 

swaters86

@echo off 

set clustercode=%1

set environments_string=%2

set sitecodes_string=%3

for /f "tokens=*" %%a in (%environments_string%) do (