Forum Replies Created

Viewing 15 posts - 2,791 through 2,805 (of 5,109 total)

  • RE: Windows Server 2012

    yrstruly - Thursday, October 19, 2017 12:17 AM
  • RE: Handling string column with dates

    DesNorton - Wednesday, October 18, 2017 1:04 PM

    GrassHopper - Wednesday, October 18, 2017 12:54 PM

    Thom~

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

  • RE: Select results based on a value within a table

    I think this is what you're after.
    CASE WHEN Tonnage <= 15 THEN [Rate A] ELSE [Rate B] END

    Thom~

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

  • RE: Handling string column with dates

    This is what I have at the moment, but without the logic asked for, this is guess work. It doesn't rely on isdate, but has additional logic to deal with...

    Thom~

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

  • RE: Handling string column with dates

    GrassHopper - Wednesday, October 18, 2017 11:30 AM

    I changed PTL_StartDate_Dt from SmallDateTime to Date.  

    Then, I tried the update again:
    Update...

    Thom~

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

  • RE: Column encryption advice

    It's' worth noting that a Post Code unto itself isn't worth encrypting. You're not liking to identify an individual from that data. It's the combination of that and other data.

    Thom~

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

  • RE: Handling string column with dates

    Get the original source to be correct... If those are the dates you have to deal with there's no point trying to convert it, and it's going to end up...

    Thom~

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

  • RE: Column encryption advice

    if you're aim is to protect your back ups, rather than encrypting data on your Server, have you considered encrypting your backups? There was an article published on this site...

    Thom~

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

  • RE: SSIS : Excel Data source (cloumn names starting in row 11)

    river1 - Wednesday, October 18, 2017 5:36 AM

    Hello,

    Thank you very much for your reply. Yes. My column names are in 11...

    Thom~

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

  • RE: MS-SQL 2016 Eating Memory

    NorthernSoul - Wednesday, October 18, 2017 4:56 AM

    80000 mb is 80gb not 8 gb. This is the reason why sql server...

    Thom~

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

  • RE: MS-SQL 2016 Eating Memory

    dextrous - Wednesday, October 18, 2017 4:51 AM

    Definately locked in at 8gb
    Here's the SCR from the query

    That's not 8GB... That's...

    Thom~

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

  • RE: MS-SQL 2016 Eating Memory

    dextrous - Wednesday, October 18, 2017 4:38 AM

    Sorry - and to add - I do have full access to all platforms and...

    Thom~

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

  • RE: MS-SQL 2016 Eating Memory

    dextrous - Wednesday, October 18, 2017 4:16 AM

    When a server is rebooted - does SQL lose the record of the capped Memory...

    Thom~

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

  • RE: SSIS : Excel Data source (cloumn names starting in row 11)

    You can use a SQL statement instead to tell ACE where you want to get the data from. So, assuming that you column headings are on row 11 and your...

    Thom~

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

  • RE: MS-SQL 2016 Eating Memory

    dextrous - Wednesday, October 18, 2017 3:29 AM

    Here's a SCR of the top memory munchers.
    Yes the server was rebooted...

    Thom~

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

Viewing 15 posts - 2,791 through 2,805 (of 5,109 total)