Forum Replies Created

Viewing 15 posts - 6,001 through 6,015 (of 8,753 total)

  • RE: Compare two XML variables

    Quick thought, use either HASHBYTES or CHECKSUM

    😎

    WHERE CHECKSUM(@xml_old) = CHECKSUM(@xml_new)

    March 19, 2015 at 3:42 am

    #1784990

  • RE: Today's Random Word!

    djj (3/18/2015)

    Ed Wagner (3/18/2015)

    crookj (3/18/2015)

    Revenant (3/18/2015)

    whereisSQL? (3/18/2015)

    Ed Wagner (3/18/2015)

    djj (3/18/2015)

    crookj (3/18/2015)

    Ed Wagner (3/18/2015)

    BWFC (3/18/2015)

    djj (3/18/2015)

    SQLRNNR (3/17/2015)

    Ed Wagner (3/17/2015)

    Eirikur Eiriksson (3/17/2015)

    SQLRNNR (3/17/2015)

    skiff

    Floating

    Drift

    wood

    Stove

    Pipe

    Exhaust

    flatulence

    Stinks

    Smells

    Deodorizer

    Fresh

    Prince

    Harry

    Potter

    Simmer

    March 18, 2015 at 1:51 pm

    #1784899

  • RE: Are the posted questions getting worse?

    Classifying any person as inferior based on gender, race, religion, health, physical condition or any other irrelevant aspects or properties is both appalling and unprofessional. Under no circumstances should such...

    March 18, 2015 at 1:21 pm

    #1784891

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (3/18/2015)

    For your discussion: https://medium.com/@sailorhg/coding-like-a-girl-595b90791cce

    Quick thought, do not ever ever ever judge the book by it's cover

    😎

    March 18, 2015 at 12:06 pm

    #1784863

  • RE: Time difference with dates in same column

    thomashohner (3/17/2015)

    Wow that was fast!

    And its faster than my attempt at creating a temp table to build a start and stop time column.

    Amazing 242,139 rows in under 30 seconds

    Hence...

    March 17, 2015 at 4:05 pm

    #1784623

  • RE: Completely New to Availability groups and need help

    Quick suggestion, start by browsing through Brent Ozar's posts/ebooks/posters[/url] on the subject

    😎

    March 17, 2015 at 4:02 pm

    #1784620

  • RE: 2012 Upgrade

    bpowers (3/17/2015)

    We are looking at upgrading our SQL Server 2008 SP4 Standard Edition instances to SQL Server 2012 SP1 Enterprise Edition. Has anyone experienced any issues doing such an upgrade?...

    March 17, 2015 at 4:00 pm

    #1784619

  • RE: How does SSIS lock source tables

    JeeTee (3/17/2015)

    Hi All,

    I'm writing a package to move the bulk of a table from one server to another, which amounts to about 25m rows. I'm not so worried about how...

    March 17, 2015 at 3:53 pm

    #1784616

  • RE: linked server fails with anonymous login

    Denise McMillan (3/17/2015)

    I created a linked server (on SQL 2005) with security mode "be made using login's current security context" to a SQL 2012 instance on another server. We're...

    March 17, 2015 at 3:48 pm

    #1784615

  • RE: Moving data from SQl Server to IBM AS400

    paulze2000 (3/17/2015)

    It looks like I found the problem. When I changed the datetime columns on the SQL side and converted them to Date because that is the data type...

    March 17, 2015 at 3:36 pm

    #1784613

  • RE: Time difference with dates in same column

    Quick suggestion

    😎

    CREATE TABLE #Time ([TimeStamp] DATETIME, TimeDiff INT)

    INSERT INTO #Time (TimeStamp)

    VALUES ('2014-09-02 07:51:02.810'), ('2014-09-02 07:48:09.567'), ('2014-09-02 08:37:09.647')

    , ('2014-09-02 16:16:42.593'), ('2014-09-02 08:06:13.387'),('2014-09-02 14:32:00.113')

    ;WITH...

    March 17, 2015 at 3:27 pm

    #1784611

  • RE: Strange shrink error

    The Redneck DBA (3/17/2015)

    I'm seeing this error pop up occasionally, and am not finding much on the Google about what might be causing it:

    Msg 9020, Sev 16, State 2, Line...

    March 17, 2015 at 2:56 pm

    #1784604

  • RE: tlog backups failing every Sunday

    add2700 (3/17/2015)

    This issue has existed for a long time. SQL Server 2005 SP2 on server 2003.

    First thought is that fixing the ageing OS/SQL Version should be a higher priority than...

    March 17, 2015 at 2:45 pm

    #1784600

  • RE: Snapshot of data, compare previous day

    SQL_Kills (3/17/2015)

    Jeff, The Yesterday_Amount should show the Amount the Amount the ID was for yesterday. Thanks

    Could you elaborate on Dwain's questions please?

    😎

    March 17, 2015 at 2:28 pm

    #1784598

  • RE: Out of control table

    ScottPletcher (3/16/2015)

    CELKO (3/12/2015)

    Since BIGINT is larger than the number of atoms in the universe, we do not use it very often.

    No, not even close. There are at least...

    March 17, 2015 at 2:15 pm

    #1784595

Viewing 15 posts - 6,001 through 6,015 (of 8,753 total)