Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 8,731 total)

  • RE: can someone point me to an AdventureWorks instance that actually can be imported

    DSNOSPAM (4/19/2016)

    I can see SQL Server 2014 in my programs list, but can't seem to find an instance of it to connect to from SSMS

    Check the services (in Administrative Tools)...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2016 at 10:32 am

    #1873128

  • RE: can someone point me to an AdventureWorks instance that actually can be imported

    DSNOSPAM (4/19/2016)

    version is:

    Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2016 at 10:26 am

    #1873123

  • RE: can someone point me to an AdventureWorks instance that actually can be imported

    John Mitchell-245523 (4/19/2016)

    It may be because AdventureWorks has some Enterprise-level features in it, and you are attempting to restore on Express edition. You can use this link for a...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2016 at 10:03 am

    #1873110

  • RE: Learning more about Database Design

    Have you gone to the books section[/url] on this site?

    The SQL Server Hardware by Glenn Berry and Troubleshooting SQL Server: A Guide for the Accidental DBA by Jonathan Kehayias and...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2016 at 9:20 am

    #1873100

  • RE: Are the posted questions getting worse?

    GilaMonster (4/19/2016)

    And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?

    That would be too easy for them. Just keep...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2016 at 6:35 am

    #1873028

  • RE: Deleting All Characters before 2 Set Characters

    This might work for you.

    PATINDEX is available in SQL Server 2005.

    DECLARE @yourTable TABLE (someString varchar(100));

    INSERT @yourTable

    VALUES ('DDR Return PP12345'),('DDR Resturns PP12356'),('DDR Retunrs PP12367'), ('This one does not have a...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2016 at 7:17 am

    #1872742

  • RE: SQL Help Please

    jsalzm1 (4/18/2016)

    Thanks guys, I and a few classmates figured it out.

    Luis, you don't need to be so rude. I actually have a great job lined up and I am...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2016 at 7:09 am

    #1872737

  • RE: SQL Help Please

    Were you really so lazy that you couldn't even copy the problem? That won't get you anywhere.

    If you don't have anything to test your answers, then build something. Download SQL...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2016 at 6:51 am

    #1872728

  • RE: Getting index columns

    This is clearly an error on how the questions and answers were posted.

    I want my zero points back. :hehe:

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2016 at 6:42 am

    #1872724

  • RE: Need to update stats when CPU is high for a particular Query

    Alan.B (4/15/2016)

    nagkarjun1 (4/15/2016)

    Hi Folks,

    I need some suggestions on doing this task. A query was catching a bad plan and keeping CPU and no of reads very high.

    Updating/defrag Stats and rebuilding...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 15, 2016 at 2:10 pm

    #1872518

  • RE: BULK INSERT seems not to recognise line terminators

    Mark Dalley (4/15/2016)

    Man, it worked. I could have sworn I'd already tried that.

    A slight twist though, and an extra confusing factor - the original file was actually Unix format, with...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 15, 2016 at 1:52 pm

    #1872510

  • RE: Need to update stats when CPU is high for a particular Query

    nagkarjun1 (4/15/2016)

    Hi Folks,

    I need some suggestions on doing this task. A query was catching a bad plan and keeping CPU and no of reads very high.

    Updating/defrag Stats and rebuilding indexes...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 15, 2016 at 1:50 pm

    #1872509

  • RE: Today's Random Word!

    DonlSimpson (4/15/2016)

    Hugo Kornelis (4/15/2016)

    Grumpy DBA (4/15/2016)

    crookj (4/15/2016)

    Revenant (4/15/2016)

    Ed Wagner (4/15/2016)

    Shipwreck

    Exxon

    spill

    Drunk

    Scotch

    Irish

    Beer

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 15, 2016 at 1:22 pm

    #1872499

  • RE: BULK INSERT seems not to recognise line terminators

    Remove the "backslash r" and keep only "backslash n".

    EDIT: To remove quotes, you need a format file. Check this thread for an example: http://www.sqlservercentral.com/Forums/FindPost1777839.aspx

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 15, 2016 at 1:08 pm

    #1872495

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/15/2016)

    Eirikur Eiriksson (4/15/2016)

    jeff.mason (4/15/2016)

    Eirikur Eiriksson (4/15/2016)

    Phil Parkin (4/15/2016)

    Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!

    Quick fix in three steps

    1. Drop procedure

    2. Drop...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 15, 2016 at 12:28 pm

    #1872484

Viewing 15 posts - 3,016 through 3,030 (of 8,731 total)