Forum Replies Created

Viewing 15 posts - 5,941 through 5,955 (of 49,571 total)

  • RE: & 1 > 0 -- syntax help

    Firstly, never be too embarrassed to ask your colleagues. Everyone started from no where and you'll probably find that a couple of them also don't know what the predicate does...

  • RE: strange messages in sql error log

    Resolve what? It's an informational message, not an error.

  • RE: Are the posted questions getting worse?

    Tom Brown (5/14/2015)


    even Sci-Fi authors/books - on amazon click through, (I'm sure I remember picking up book recommendations from your site in the past)

    That's kinda been there for...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (5/14/2015)


    An alternative is a "tipping jar" that some sites use (such as paypal link), or connecting up to Patreon (which some of the webcomics use).

    Neither of which serve...

  • RE: Slow Query

    Please post query, table definition, index definitions and actual execution plan (saved as a .sqlplan file and attached)

  • RE: Advantages Over SQL SERVER Always on over Clustering

    To start, Always On is not a feature. It's a marketing term. The two features which fall under that marketing terms are Failover Clustering and Availability Groups. Which are you...

  • RE: Are the posted questions getting worse?

    Question for the people here...

    Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I started...

  • RE: splitting row into multiple rows - Urgent

    aaron.reese (5/14/2015)


    If the data contains MR, Mr or Mr. and it contains MRS, Mrs or Mrs. then it is two people

    Careful, that makes large assumptions. What about

    Prof and Mrs?

    Mr and...

  • RE: splitting row into multiple rows - Urgent

    It is a nightmare and it's going to be near-impossible to do correctly in all cases.

    What you can do is list all the valid titles that you have in the...

  • RE: unusual syntax - is this deprecated

    There aren't multiple ON clauses in a join there, it's not allowed. What's there is a rather badly formatted mess. It is NOT equivalent to a single join with ANDs,...

  • RE: Alternative to DBCC CHECKDB

    Thanks Paul.

  • RE: Alternative to DBCC CHECKDB

    Grant Fritchey (5/13/2015)


    GilaMonster (5/13/2015)


    Grant Fritchey (5/13/2015)


    Because you can have physical corruption that doesn't get backed up or restored.

    How?

    I keep hearing this advice, but the problem is it doesn't bear out....

  • RE: Alternative to DBCC CHECKDB

    Grant Fritchey (5/13/2015)


    Because you can have physical corruption that doesn't get backed up or restored.

    How?

    I keep hearing this advice, but the problem is it doesn't bear out. Backups are a...

  • RE: Alternative to DBCC CHECKDB

    Grant Fritchey (5/13/2015)


    If you offload it to another server, you'll still want to run a PHYSICAL_ONLY check on the first server.

    Why?

  • RE: Alternative to DBCC CHECKDB

    You can offload the work to a second server, restore a backup of the production DB and check that. You can break CheckDB down and run its pieces, that's CheckAlloc,...

Viewing 15 posts - 5,941 through 5,955 (of 49,571 total)