Forum Replies Created

Viewing 15 posts - 3,871 through 3,885 (of 8,761 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/4/2016)


    Why do you think I'm working on that database?

    Ha!

    I'm pretty sure that's one of Steve's presentations.

    Simply because this is not the BlogsDotRedgate_Dev_Steve database which is on the same...

  • RE: Are the posted questions getting worse?

    For fun (screenshot from a RedGate presentation)

    😎

  • RE: Flag Values Based on Columns

    Sergiy (2/1/2016)


    Eirikur Eiriksson (1/27/2016)


    But it is kind of disappointing when the structure of the solution is there and no one pitches in the final bit.

    😎

    Only thing which was there was...

  • RE: Pivot table

    Quick suggestion

    😎

    SELECT

    D.Domain

    ,D.CaseName

    ,D.Type

    ,D.Stream

    ,SUM(CASE WHEN D.[Status] = 'Passed' ...

  • RE: Retrieve InstallationID from an XML document. Almost there but...

    Quick suggestion, replace the curlies out of the ID

    😎

    $InstID = $XML.DocumentElement | Select InstallationID

    $InstID = -replace "{", ""

    $InstID = -replace "}", ""

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (1/29/2016)


    Apparently got over 15,000 points today. Yay. :w00t:

    +15,000

    😎

  • RE: The Most Common Query Blunders...

    Jeff Moden (1/29/2016)


    GilaMonster (1/29/2016)


    Jeff Moden (1/28/2016)


    Rich Mechaber (1/5/2016)


    You've probably got more material than you need by this point. This one's an old article, but I still find it useful...

  • RE: getting error "The system cannot find the path specified." using xp_cmdshell

    mpepe 21547 (1/27/2016)


    I am having a similar issue:

    EXEC master..xp_cmdshell

    "dir \\fserver1\NextgenRoot\Prod\EMR\Images\ImageSaved\84C06D96-D350-47ED-B26D-BF1A794D93A6.pdf"

    Results:

    Volume in drive \\fserver1\NextgenRoot is Data

    Volume Serial Number is 3CEC-F907

    NULL

    Directory of \\fserver1\NextgenRoot\Prod\EMR\Images\ImageSaved

    NULL

    09/28/2014 01:29 PM ...

  • RE: Flag Values Based on Columns

    Jeff Moden (1/26/2016)


    I'd take some heart in what was said as mean as it sounded. We have quick posts that don't survive the future and people saying they solved...

  • RE: Flag Values Based on Columns

    Quick suggestion, requires SQL Server 2012 or later

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    IF OBJECT_ID(N'dbo.SampleTable') IS NOT NULL DROP TABLE dbo.SampleTable;

    CREATE TABLE [dbo].[SampleTable](

    [ID] [int] IDENTITY(1,1) NOT NULL,

    [Measure1] [float] NULL,

    [Measure2] [float] NULL,

    )

    --Sample Data:

    INSERT...

  • RE: HP Superdome 2 Server

    Microsoft ended the support for the Itanium architecture back in 2010, last versions supported were 2008R2 Windows Server and 2008R2 SQL Server. Superdome X uses the newer Xeon processors, totally...

  • RE: HP Superdome 2 Server

    cheshirefox (1/25/2016)


    Hi -

    I'm beginning the process of planning a physical server migration.

    Due to our wildly volatile environment, we require physical database servers w/ data residing on a flash appliance.

    Is there...

  • RE: RECREATE AN ID OF A ROW AFTER BEING DELETED

    Looks like abdellahmoh2016 has left the building

    😎

  • RE: Date Function

    SumonB,

    have you had a look at the solution posted here?

    😎

  • RE: Convert a Date

    Jeff Moden (1/25/2016)


    Yes. Not because of the low quantity but because someone else in search of code may find it and use it on something larger or something that's...

Viewing 15 posts - 3,871 through 3,885 (of 8,761 total)