Forum Replies Created

Viewing 15 posts - 211 through 225 (of 1,079 total)

  • RE: sp_clean_db_free_space

    Lynn Pettis - Thursday, January 19, 2017 3:25 PM

    Does anyone know at what level J1,J2,J3,K1,M1,M2,M3,N1,N2,N3,P1,P2,P3,R1,S1,S2,T1,T2,T3,W1,W2,W3') AS [Location]

    Location
    19

    SELECT CHARINDEX('A2,R1,T3,D1', '01,02,03,04,05,A1,A2,C1,C2,C3,D1,D2,
    J1,J2,J3,K1,M1,M2,M3,N1,N2,N3,P1,P2,P3,R1,S1,S2,T1,T2,T3,W1,W2,W3') AS [Location]

    Location
    0

    Why A2,R1,T3,D1 return 0? A2,R1,T3,D1 is Exists...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    January 18, 2017 at 8:00 am

    #1923435

  • RE: Need help with a sql query

    Nluvwocean - Wednesday, January 18, 2017 6:25 AM

    I have to do this problem for an interview and I can't figure out how to...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    January 18, 2017 at 6:54 am

    #1923407

  • RE: DECLARE multiple vars with default value

    Back to basics, thanks for the question.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    January 16, 2017 at 6:03 am

    #1922956

  • RE: perform an activity on each database on the server

    thanks for the question, trusty old gem used countless times.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    November 30, 2016 at 6:48 am

    #1915151

  • RE: INSERTing datetimeoffsets

    Nice question, technically both:

    1. INSERT dbo.TimeZoneOffsetTest (mytime) CAST(SELECT '20161015 08:15 -4:25' as DATETIMEOFFSET)

    and

    2. INSERT dbo.TimeZoneOffsetTest (mytime) SELECT '20161015 08:15 2:00'

    are invalid, option 1 contains an invalid sub-query SELECT. Remove...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    November 2, 2016 at 12:58 am

    #1910043

  • RE: Agent Job

    Sounds like a bug, are you on the latest Service Pack for 2012?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    October 11, 2016 at 11:55 pm

    #1906026

  • RE: Trailing

    I'll admit, this one got me. :hehe:

    Thanks for the question.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    October 10, 2016 at 10:25 pm

    #1905812

  • RE: Storing In-Memory OLTP tables

    good one, thank you

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    October 6, 2016 at 12:46 am

    #1905088

  • RE: SQL Server license requirements

    Best to speak to your license partner, if Standard, you'll need to review the rules of licensing the host and additional vCores, or just the vCores of the VM by...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    October 5, 2016 at 7:32 am

    #1904904

  • RE: SQL Server license requirements

    You license SQL per server, not database.

    So yes, you can add more databases to an existing licensed instance.

    ....you say virtual...is this also Web, or STD or ENT?

    It...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    October 4, 2016 at 2:05 am

    #1904601

  • RE: Invoke-BpaModel "SQL2012BPA"

    Thank you for the suggestion, although I've tried all variants, including yours, and it appears that it doesn't accept anything beyond a standalone name.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    September 29, 2016 at 9:06 am

    #1903976

  • RE: SQL Server 2014 BPA?

    Pity, thanks for the feedback

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    September 20, 2016 at 2:38 am

    #1901809

  • RE: SQL Server 2014 BPA?

    Dammit - wonder if there's any replacement tool for BPA.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    July 13, 2016 at 11:33 am

    #1889927

  • RE: SQL Server 2014 BPA?

    Sorry to resurrect this thread, has 2014 BPA been released? Can't find it anywhere.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    July 13, 2016 at 11:12 am

    #1889923

Viewing 15 posts - 211 through 225 (of 1,079 total)