Forum Replies Created

Viewing 15 posts - 2,446 through 2,460 (of 19,564 total)

  • RE: Restore of db fails

    Markus (7/31/2014)


    Gazareth (7/31/2014)


    Markus (7/31/2014)


    SQLRNNR (7/31/2014)


    I'll try to think on it some more. I'm sure this odd error has you frustrated.

    Yes. I've never seen anything like this before. ...

  • RE: Today's Random Word!

    kanoodling

  • RE: Lock a SQL login account

    Account lockout for SQL Server is enforced by the local machine or domain policy in effect. This applies to SQL logins as well.

    So if you want an account to...

  • RE: how to automate dbcc checkdb

    Skip the Maintenance plan node and go straight down to SQL Server Agent. Expand that node. Right-click on the Jobs node and select New Job from the Context...

  • RE: Performance tuning classes?

    New Born DBA (7/31/2014)


    Grant Fritchey (7/31/2014)

    So, you're employer isn't likely to spring for a trip to Belgium then. Oh well. There's still Connections and PASS Summit.

    Well we do have an...

  • RE: Today's Random Word!

    crookj (7/31/2014)


    Ed Wagner (7/31/2014)


    BWFC (7/31/2014)


    Revenant (7/30/2014)


    SQLRNNR (7/30/2014)


    Sean Lange (7/30/2014)


    Ed Wagner (7/30/2014)


    SQLRNNR (7/30/2014)


    djj (7/30/2014)


    whereisSQL? (7/30/2014)


    Ed Wagner (7/30/2014)


    TomThomson (7/30/2014)


    SQLRNNR (7/30/2014)


    Ed Wagner (7/30/2014)


    Stuart Davies (7/30/2014)


    SQLRNNR (7/29/2014)


    aardvark

    Digger

    Hunting (for antiques)

    Pecheur

    é or ê?

    Tomato

    ketchup

    hot dog

    breakfast

    Dinner

    Bacon

    Pork Belly

    futures

    Markets

    Farmer

    John

    Doe

  • RE: how to automate dbcc checkdb

    cdm33.com (7/31/2014)


    Jason,

    Thanks for your input. I'm looking at the last option where i script the checkdb for each database then. I'm hoping the script will not be long...

  • RE: Today's Humor..

    Sarah Wagner (7/31/2014)


    I hired in to a software company and sad to say we were one of those vendors. Gladly we are not anymore as I rewrote all of our...

  • RE: Restore of db fails

    I'll try to think on it some more. I'm sure this odd error has you frustrated.

  • RE: Restore of db fails

    The error being produced just smells of an issue trying to transfer data across the wire and that there is some sort of transfer issue.

    Is the backend device attached via...

  • RE: T- SQL Constraints

    Thomas Abraham (7/31/2014)


    Why would I use the method in the question when, as the answer showed, I can use:

    SELECT *

    FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS

    I generally use sys.objects for this kind of lookup....

  • RE: HI...Sample INSERT statement script needed to insert 500 million rows into in-memory table sql server 2014

    GilaMonster (7/31/2014)


    Please remember that the point of in-memory is to improve *massively concurrent* inserts, not single inserts of large numbers of rows. If you don't have massive numbers of concurrent...

  • RE: Today's Humor..

    It's very possible the manual and support have been trained on how to handle perf on MySQL as well and might be mis-interpreting it with MSSQL. They are, afterall,...

  • RE: how to automate dbcc checkdb

    Grant Fritchey (7/31/2014)


    cdm33.com (7/30/2014)


    SQLRNNR,

    This code has hundreds of lines to it. I've got no clue what it does. I'm not going to put something like this on a...

  • RE: HI...Sample INSERT statement script needed to insert 500 million rows into in-memory table sql server 2014

    I'm also a bit concerned that the table is 195GB with only 500 million records.

    Could you run the script from here and paste the results for that table? It...

Viewing 15 posts - 2,446 through 2,460 (of 19,564 total)