Forum Replies Created

Viewing 15 posts - 676 through 690 (of 3,221 total)

  • RE: User DB ended up in the drop down list of "System Databases" in SSMS

    One possibility

    Using SSMS

    1. Right clicked on System Databases

    2. Selected the Restore option

    And then entered the information for a user DB

    Now I have not tested the above, not...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 7:31 pm

    #1445365

  • RE: Where to start for a 100% SQL Server 2008 R2 Newb?

    Discusman (2/9/2012)

    bitbucket-25253 (2/9/2012)

    Rather than use the Express Edition, which is extremely limited I would suggest purchasing the DEVELPER EDITION available from Amazon.com for less than $50 U.S. Dollars. It...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 7:20 pm

    #1445364

  • RE: SQL Parse Function always returning the same data - why?

    Our thanks to you to let us know we did assist even if in some small fashion.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 5:40 pm

    #1445354

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (2/9/2012)

    Revenant (2/9/2012)

    L' Eomot Inversé (2/9/2012)

    MysteryJimbo (2/9/2012)

    HowardW (2/9/2012)

    MysteryJimbo (2/9/2012)

    Interesting fact: Historically, it used to be in the UK that people drank more beer than water as it was sterile...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 1:34 pm

    #1445274

  • RE: SQL Parse Function always returning the same data - why?

    Sean Lange (2/9/2012)

    My guess is you have something else in your code that is running slow. I have used his parsing function in all sorts of ways and places and...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 1:31 pm

    #1445272

  • RE: SQL Parse Function always returning the same data - why?

    Rather than fuss with your splitter code why not use an excellent splitter developed by Jeff Moden and tested by many and know to work.

    May I suggest reading this:

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 10:38 am

    #1445196

  • RE: Are the posted questions getting worse?

    jcrawf02 (2/9/2012)

    Seems timely on the heels of Lynn's news, a big THANK YOU to everyone who sent good thoughts my way a few weeks ago, I was nervous because....we're having...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 10:00 am

    #1445177

  • RE: Where to start for a 100% SQL Server 2008 R2 Newb?

    Rather than use the Express Edition, which is extremely limited I would suggest purchasing the DEVELPER EDITION available from Amazon.com for less than $50 U.S. Dollars. It is equivalent...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 8:51 am

    #1445132

  • RE: financial length of stay by each month

    SQLKiller

    I really aplogize to everyone out there, i am a newbie to this community i just gone to the links you mentioned i felt so bad about my request.

    i...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 7:44 am

    #1445075

  • RE: Using SP_

    BudaCli (2/9/2012)

    Tricky & i think it's better than not knowing at all.:cool:

    I had hoped that the question would make people aware of the "hidden problems/dangers" that can occur when using...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 6:37 am

    #1445029

  • RE: HASHBYTES

    At first figured that either "you cannot add a salt", or the correct answer. Flipped a coin and well ... lost the point ... teach me not to gamble.

    In...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 6:30 am

    #1445027

  • RE: Very unwise customer with "suspect" db

    GilaMonster (2/9/2012)

    Link does not work

    Thanks .. I hope it is now corrected

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 9, 2012 at 6:16 am

    #1445022

  • RE: financial length of stay by each month

    I would suggest, to get a tested answer to your question, that you post the table definition(s) along with sample data and required results in a readily consumable format. ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 8, 2012 at 5:19 pm

    #1444842

  • RE: Very unwise customer with "suspect" db

    ronmoses (2/8/2012)

    I work for a small software company whose desktop app runs off a small SQL Server 2005 backend. Typically 2005 Express is installed on the user's machine. We...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 8, 2012 at 5:01 pm

    #1444838

  • RE: Using SP_

    john.arnott (2/8/2012)

    bitbucket-25253 (2/8/2012)

    sathishkumar.k (2/8/2012)

    Great question... Is that mean when any object with SP_ prefix used in combination with if (as in this case) would be searched in the current DB...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    February 8, 2012 at 10:26 am

    #1444656

Viewing 15 posts - 676 through 690 (of 3,221 total)