Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Quick SQL Server Configuration Summary Report

    Script is really helpfull, after some changes it is running now also on case sensitive servers and several times in the same wquery(added drop before create table)

    USE master

    GO

    SET NOCOUNT ON;

    /*...

  • RE: Unpivot

    I mean the difference of Orderid and OrderID, case sensitive systems think, that there are 2 different variables.

  • RE: Unpivot

    After correcting the spelling mistakes ( if you run this query on a case sensitive instance) you will receive 2 rows!

  • RE: SQL Server Performance Base Line Script

    This updated script runs also on a case sensible SQL 2014 version:

    USE [master]

    GO

    if exists(select 1 from sys.sysobjects where name=N'InstanceAnalysis_PerformanceBaseLine' and type=N'P')

    begin

    Drop procedure [dbo].[InstanceAnalysis_PerformanceBaseLine]

    end

    /****** Object: StoredProcedure [dbo].[InstanceAnalysis_PerformanceBaseLine] ...

Viewing 4 posts - 1 through 4 (of 4 total)