Forum Replies Created

Viewing 15 posts - 5,161 through 5,175 (of 8,761 total)

  • RE: REPLACE & PATINDEX issue

    Lynn Pettis (5/29/2015)

    < friendly rant >

    Eirikur, really, ;; and then the WITH for the CTE?? Semicolons are terminators not begininators. Microsoft documentation in BOL is WRONG to...

    May 29, 2015 at 12:39 pm

    #1801696

  • RE: REPLACE & PATINDEX issue

    TJT (5/29/2015)

    OK I tried the example below and I get 'Invalid object name 'dbo.DelimitedSplit8k''

    USE tempdb;

    GO

    SET NOCOUNT ON;

    ;WITH SAMPLE_DATA(IP_ADDR) AS

    ( SELECT * FROM (VALUES

    ('132.135.3.100, fe90::bu54:e9z5:61a9:5003')

    ,('132.235.219.113, fe80::28d9:l69a:5bbd:gr2f')

    )...

    May 29, 2015 at 12:37 pm

    #1801694

  • RE: REPLACE & PATINDEX issue

    Quick suggestion, use dbo.DelimitedSplit8K on the comma

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    ;WITH SAMPLE_DATA(IP_ADDR) AS

    ( SELECT * FROM (VALUES

    ('132.135.3.100, fe90::bu54:e9z5:61a9:5003')

    ,('132.235.219.113, fe80::28d9:l69a:5bbd:gr2f')

    ) AS X(IP_ADDR)

    )

    SELECT

    SP.Item

    FROM ...

    May 29, 2015 at 12:17 pm

    #1801686

  • RE: Today's Random Word!

    DonlSimpson (5/29/2015)

    Ed Wagner (5/29/2015)

    TomThomson (5/29/2015)

    Revenant (5/29/2015)

    Ed Wagner (5/29/2015)

    cunningham (5/29/2015)

    Ed Wagner (5/29/2015)

    hughmanning (5/29/2015)

    Centipede

    Millipede

    arthropod

    Management (Couldn't resist :-D)

    disaster

    recovery

    Restore

    Habitat

    Boundries

    May 29, 2015 at 11:31 am

    #1801669

  • RE: Today's Random Word!

    Ed Wagner (5/28/2015)

    TomThomson (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    Ed Wagner (5/28/2015)

    crookj (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    Ed Wagner (5/28/2015)

    TomThomson (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    djj (5/28/2015)

    Revenant (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    crookj (5/28/2015)

    Ed Wagner (5/28/2015)

    djj (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    session

    Server

    SQL:-D

    Performance

    Recital

    Piano

    Guitar

    Tune

    Engine

    Running

    Races

    Horse

    Mouth

    Mister (Ed)

    Misses

    Hits

    Charts

    Course

    Lost

    May 28, 2015 at 2:08 pm

    #1801398

  • RE: Today's Random Word!

    Ed Wagner (5/28/2015)

    crookj (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    Ed Wagner (5/28/2015)

    TomThomson (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    djj (5/28/2015)

    Revenant (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    crookj (5/28/2015)

    Ed Wagner (5/28/2015)

    djj (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    session

    Server

    SQL:-D

    Performance

    Recital

    Piano

    Guitar

    Tune

    Engine

    Running

    Races

    Horse

    Mouth

    Mister (Ed)

    Misses

    Hits

    May 28, 2015 at 12:44 pm

    #1801365

  • RE: The Scientific Method: a call to action

    Lynn Pettis (5/28/2015)

    meilenb (5/27/2015) ...

    Oh and we don't need to sit here and sling insults. You've got 2 under your belt.

    Only problem here, I haven't slung ANY insults. ...

    May 28, 2015 at 12:37 pm

    #1801361

  • RE: Are the posted questions getting worse?

    Ed Wagner (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    Brandie Tarvin (5/28/2015)

    Well, unless someone used DBCC Timewarp() on it, the last I checked there was only one. But then again, someone did say DBCC Timewarp()...

    May 28, 2015 at 12:26 pm

    #1801357

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (5/28/2015)

    Well, unless someone used DBCC Timewarp() on it, the last I checked there was only one. But then again, someone did say DBCC Timewarp() was outdated and being...

    May 28, 2015 at 12:09 pm

    #1801346

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (5/28/2015)

    Is there just one? If there's a separate one for VS Online, pass it over.

    "There can be only one" although AlwaysOn might come in handy...

    May 28, 2015 at 12:04 pm

    #1801344

  • RE: Today's Random Word!

    Ed Wagner (5/28/2015)

    TomThomson (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    djj (5/28/2015)

    Revenant (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    crookj (5/28/2015)

    Ed Wagner (5/28/2015)

    djj (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    session

    Server

    SQL:-D

    Performance

    Recital

    Piano

    Guitar

    Tune

    Engine

    Running

    Races

    Horse

    Mouth

    May 28, 2015 at 11:54 am

    #1801338

  • RE: Are the posted questions getting worse?

    ChrisM@Work (5/28/2015)

    Ed has the crystal ball today, plus nerves of steel and the patience of a person with a tent guarded by a hippo..

    We need to get a GPS tracker...

    May 28, 2015 at 11:53 am

    #1801336

  • RE: SUSPEND_FROM_RESTART

    Did you check out this: Resume an Availability Database (SQL Server)?

    😎

    May 28, 2015 at 11:42 am

    #1801333

  • RE: SUSPEND_FROM_RESTART

    Quick thought, search for "AlwaysOn Availability Groups data movement for database 'XXXXXXXXX' has been suspended"

    😎

    Edit: typo

    May 28, 2015 at 10:43 am

    #1801322

  • RE: Today's Random Word!

    djj (5/28/2015)

    Revenant (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    crookj (5/28/2015)

    Ed Wagner (5/28/2015)

    djj (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    session

    Server

    SQL:-D

    Performance

    Recital

    Piano

    Guitar

    Tune

    Engine

    Running

    May 28, 2015 at 10:38 am

    #1801321

Viewing 15 posts - 5,161 through 5,175 (of 8,761 total)