Forum Replies Created

Viewing 15 posts - 2,536 through 2,550 (of 5,109 total)

  • RE: Restore DB in different instance

    89netanel - Monday, November 20, 2017 7:14 AM

    Hello,
    I have 2 instances.
    1 for production and 1 for QA.
    i backed up 1 of my...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Query taking long time

    ekknaveen - Monday, November 20, 2017 5:43 AM

    It is oracle query. need to find where it is taking long time and how...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Not able to get any links to find ebbok for sql 2016 MCSA certification

    GilaMonster - Monday, November 20, 2017 4:43 AM

    Hahahahahaha

    Oh, they have. So many times.

    No, I refuse to believe it!!! :blink:

    Next we'll...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Amount of RAM in server

    tfeuz - Friday, November 17, 2017 3:19 PM

    Just curious  - how much RAM do you have in your SQL server?

    256GB on the...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Scripts

    jagjitsingh - Sunday, November 19, 2017 10:30 PM

    Hi

      In 1 Database i have 2 or more companies . Can i generate all...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Not able to get any links to find ebbok for sql 2016 MCSA certification

    Jeff Moden - Sunday, November 19, 2017 6:40 PM

    Heh... I've got the sneaking suspicion that the OP means something for free.

    p.s....

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Combine 3 SQL queries

    You say there is "no relationship", however, what defines that KidID 20 appears on the same line as ComplainID 4 and SuggestionID 3? Is it just "random"?

    This is...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Combine 3 SQL queries

    Then what is you're aim? You should supply DDL, sample data and expected outputs for T-SQL questions, could you do so please? You can see how to by the link...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: One of my sql database

    Eirikur Eiriksson - Sunday, November 19, 2017 5:27 AM

    She must be living in an English speaking country, my English has drastically...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Combine 3 SQL queries

    Without any DDL, and little explanation, this a bit of a guess, however, have a look at UNION and UNION ALL.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: One of my sql database

    Eirikur Eiriksson - Saturday, November 18, 2017 9:14 AM

    Jeff Moden - Friday, November 17, 2017 5:24 PM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Not able to get any links to find ebbok for sql 2016 MCSA certification

    sej2008 - Sunday, November 19, 2017 2:58 AM

    Hi I want to do certification in sql 2016.I tried to search ebooks on net...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Add New Column Based on Criteria

    Why are they wrong..? You said that 1-10 is 1, 11-20 is 2. Ergo this would mean:
    1 - 10 = 1
    11- 20 = 2
    21 - 30 =...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Search with Date Range

    VegasL - Saturday, November 18, 2017 11:06 AM

    Also how can I get to

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Add New Column Based on Criteria

    Try:
    ALTER TABLE #test_table ADD [Page] AS CONVERT(int,((CP - 1) / 10) + 1);
    In regards to the date format, it's best to do that in your presentation layer, rather...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 2,536 through 2,550 (of 5,109 total)