Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 6,401 total)

  • RE: Table sysfiles out of date

    sys.sysfiles is only included in the product for backwards compatibility.

    You should be using sys.database_files.

    Does the new system view still show the old FTC?

    November 17, 2015 at 5:44 am

    #1840290

  • RE: Today's Random Word!

    Ed Wagner (11/17/2015)

    anthony.green (11/17/2015)

    Ed Wagner (11/16/2015)

    eccentricDBA (11/16/2015)

    crookj (11/16/2015)

    Ed Wagner (11/16/2015)

    ZZartin (11/16/2015)

    Luis Cazares (11/16/2015)

    DonlSimpson (11/16/2015)

    Ed Wagner (11/16/2015)

    anthony.green (11/16/2015)

    djj (11/16/2015)

    anthony.green (11/16/2015)

    Ed Wagner (11/16/2015)

    Sith

    Dark

    Chocolate

    Bean

    Coffee

    Java

    Jabba

    Slave

    Drive

    Zip

    tar

    Compression

    algorithm

    Equation

    Complex

    November 17, 2015 at 5:43 am

    #1840289

  • RE: Date Difference

    Others may come up with other solutions

    DECLARE @dayOfBirth datetime = '19850723'

    DECLARE @today datetime, @thisYearBirthDay datetime, @years int, @months int, @days int

    SELECT @today = GETDATE()

    SELECT @thisYearBirthDay = DATEADD(year, DATEDIFF(year, @dayOfBirth,...

    November 17, 2015 at 5:41 am

    #1840287

  • RE: select string between two ',' symbols

    Number of ways to do it

    create table #test(HID varchar (50))

    insert into #test values

    ('12,3,16'),

    ('16,10,256'),

    ('2,150,110,200'),

    ('5,70,4'),

    ('2,100,110,150,200,123,159602,1568')

    select

    hid,

    charindex(',',reverse(hid)) AS RightMostCommaPosition,

    left(hid,len(hid)-charindex(',',reverse(hid))) AS NewHID,

    charindex(',',reverse(left(hid,len(hid)-charindex(',',reverse(hid))))) AS NowRightMostCommaPosition,

    right(left(hid,len(hid)-charindex(',',reverse(hid))),charindex(',',reverse(left(hid,len(hid)-charindex(',',reverse(hid)))))-1) AS Result

    from #test

    ;with cte as

    (

    select * from #test

    cross...

    November 17, 2015 at 4:40 am

    #1840259

  • RE: select string between two ',' symbols

    Just in relation to this value

    '2,150,110,200'

    Why 110 and not 150,110?

    If you had '2,100,110,150,200,123,159602,1568'

    What would the correct answer be?

    November 17, 2015 at 4:14 am

    #1840253

  • RE: Sync Tables

    Sounds like merge replication may be the best option

    November 17, 2015 at 3:42 am

    #1840250

  • RE: Sync Tables

    How often does the tables need to be merged?

    November 17, 2015 at 3:23 am

    #1840245

  • RE: Services failed start in cluster

    Has the SSL certificate expired?

    Are you even using SSL to encrypt the connections to the server? If not remove it from Config Manager

    November 17, 2015 at 2:35 am

    #1840234

  • RE: Today's Random Word!

    Ed Wagner (11/16/2015)

    eccentricDBA (11/16/2015)

    crookj (11/16/2015)

    Ed Wagner (11/16/2015)

    ZZartin (11/16/2015)

    Luis Cazares (11/16/2015)

    DonlSimpson (11/16/2015)

    Ed Wagner (11/16/2015)

    anthony.green (11/16/2015)

    djj (11/16/2015)

    anthony.green (11/16/2015)

    Ed Wagner (11/16/2015)

    Sith

    Dark

    Chocolate

    Bean

    Coffee

    Java

    Jabba

    Slave

    Drive

    Zip

    tar

    Compression

    algorithm

    November 17, 2015 at 2:06 am

    #1840224

  • RE: How does SQL Server host communicate with Client - what ports on both machines?

    The client uses the RPC port range, so anything between TCP 1024 and 65535 to communicate to SQL on, its random as it depends what ports are already in use...

    November 17, 2015 at 2:00 am

    #1840221

  • RE: Today's Random Word!

    djj (11/16/2015)

    anthony.green (11/16/2015)

    Ed Wagner (11/16/2015)

    Sith

    Dark

    Chocolate

    Bean

    November 16, 2015 at 8:46 am

    #1839982

  • RE: Today's Random Word!

    Ed Wagner (11/16/2015)

    Sith

    Dark

    November 16, 2015 at 8:08 am

    #1839968

  • RE: Today's Random Word!

    Ed Wagner (11/16/2015)

    anthony.green (11/16/2015)

    Ed Wagner (11/16/2015)

    anthony.green (11/16/2015)

    crookj (11/13/2015)

    Ed Wagner (11/13/2015)

    anthony.green (11/13/2015)

    DonlSimpson (11/13/2015)

    anthony.green (11/13/2015)

    Ed Wagner (11/12/2015)

    DonlSimpson (11/12/2015)

    anthony.green (11/12/2015)

    Ed Wagner (11/12/2015)

    Bill

    Overbeck

    Sadler

    Sandler

    Pixels

    Pixies

    Debaser

    Acidity

    Tartness

    Pungency

    Strong

    The Force

    Jedi

    Light

    November 16, 2015 at 6:34 am

    #1839938

  • RE: Today's Random Word!

    Ed Wagner (11/16/2015)

    anthony.green (11/16/2015)

    crookj (11/13/2015)

    Ed Wagner (11/13/2015)

    anthony.green (11/13/2015)

    DonlSimpson (11/13/2015)

    anthony.green (11/13/2015)

    Ed Wagner (11/12/2015)

    DonlSimpson (11/12/2015)

    anthony.green (11/12/2015)

    Ed Wagner (11/12/2015)

    Bill

    Overbeck

    Sadler

    Sandler

    Pixels

    Pixies

    Debaser

    Acidity

    Tartness

    Pungency

    Strong

    The Force

    November 16, 2015 at 5:39 am

    #1839921

  • RE: Today's Random Word!

    crookj (11/13/2015)

    Ed Wagner (11/13/2015)

    anthony.green (11/13/2015)

    DonlSimpson (11/13/2015)

    anthony.green (11/13/2015)

    Ed Wagner (11/12/2015)

    DonlSimpson (11/12/2015)

    anthony.green (11/12/2015)

    Ed Wagner (11/12/2015)

    Bill

    Overbeck

    Sadler

    Sandler

    Pixels

    Pixies

    Debaser

    Acidity

    Tartness

    Pungency

    November 16, 2015 at 1:59 am

    #1839887

Viewing 15 posts - 1,726 through 1,740 (of 6,401 total)