Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 5,109 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Tuesday, January 9, 2018 10:19 AM

    I had to tell Kylie about this, she laughed.
    She was the only student...

    Thom~

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

  • RE: Are the posted questions getting worse?

    jasona.work - Tuesday, January 9, 2018 6:33 AM

    Well this is going to be a fun week to patch...
    Security software is saying "PATCH...

    Thom~

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

  • RE: CASE statement slows down query drastically

    What is your reason for using NOLOCK? You know the implications of it, right?

    Thom~

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

  • RE: HTTP command

    Why with a SQL SP? Would you consider using SSIS instead?

    Thom~

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

  • RE: STORED PROCEDURE

    mrplayerplanet - Monday, January 8, 2018 6:56 AM

    sorry for calling you bro, my apology...
    i have change it still the same

    What is...

    Thom~

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

  • RE: STORED PROCEDURE

    Please don't call me "bro", with respect, we aren't that familiar.

    As for your data types, as I said, declare them as what they are; you said yourself that...

    Thom~

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

  • RE: STORED PROCEDURE

    Also, just noticed that @dob_date is an nvarchar as well. If it's a date, it's should be declared as so.

    Thom~

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

  • RE: STORED PROCEDURE

    What is your question?

    Also, you're declaring your parameters @DOLA and @GI as nvarchars, but then comparing them to integers. Why? If someone passes a non-numeric value to these,...

    Thom~

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

  • RE: dynamic filtering in SSRS

    Could you define more complicated/flexible? I've found SSRS to be quite flexible, so it would be good to know what your aim is and why you're struggling.

    Thom~

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

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Friday, January 5, 2018 7:56 AM

    You know, I don't think that it is that the questions are getting worse. ...

    Thom~

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

  • RE: Metldown and Spectre

    We have a SQL Server 2017 and Windows Server 2016 Evaluation VM, which I'm just doing some benchmarking on now. I'll then be patching it and seeing where those same...

    Thom~

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

  • RE: LDAP Authentication - SQL 2017 on Linux

    amitbhatt.sqldba - Friday, January 5, 2018 2:18 AM

    Thom A - Friday, January 5, 2018 2:06 AM

    Thom~

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

  • RE: LDAP Authentication - SQL 2017 on Linux

    Microsoft released a guide on how to do this. A quick Google will find it for you. You can't achieve this without adding the Linux machine to your...

    Thom~

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

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Thursday, January 4, 2018 1:13 PM

    FWIW, a summary page for the Meltdown/Spectre CPU bugs is up:...

    Thom~

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

  • RE: Execute .sql script within a stored procedure without using xp_cmdshell

    What is the .sql file doing? Why are you wanting to execute SQL from a file in a (shared) file path? Is it so that it can be dynamic? Is...

    Thom~

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

Viewing 15 posts - 2,296 through 2,310 (of 5,109 total)