Forum Replies Created

Viewing 15 posts - 196 through 210 (of 8,731 total)

  • RE: The SQL Joke Thread

    Brandie Tarvin - Friday, March 1, 2019 11:44 AM

    3 DBAs walk into a diner. The first grabs a menu, the second scans...

    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

    March 1, 2019 at 11:54 am

    #2023333

  • RE: datetime - with 01/01/1000 date

    I'm wondering if that value should be a NULL. Otherwise, it wouldn't make sense to have information from the Middle Age or Mayan civilization.

    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

    March 1, 2019 at 10:55 am

    #2023319

  • RE: How to determine what percent of a varchar column is a valid numeric?

    Here's an example on how to get a percentage of data that is not numeric. It can also help with all the conversion to numeric columns that has been suggested...

    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

    February 27, 2019 at 1:17 pm

    #2023125

  • RE: WHERE Clause exclusions, best practices.

    Have you tried creating persisted computed columns that would serve as flags to identify valid rows? Just one column per table could give you the functionality and won't 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

    February 26, 2019 at 12:51 pm

    #2023003

  • RE: WHERE Clause exclusions, best practices.

    Thom A - Tuesday, February 26, 2019 10:01 AM

    pietlinden - Tuesday, February 26, 2019 9:54 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

    February 26, 2019 at 10:12 am

    #2022995

  • RE: Totals up to a specific date

    patrickmcginnis59 10839 - Monday, February 25, 2019 2:33 PM

    Here's another example with two different styles that produce equivalent parsed trees:

    SELECT COLUMN1...

    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

    February 25, 2019 at 2:48 pm

    #2022924

  • RE: Totals up to a specific date

    patrickmcginnis59 10839 - Monday, February 25, 2019 1:27 PM

    Technically the semicolon IS following the previous statement %^)

    Exactly, following the previous statement,...

    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

    February 25, 2019 at 1:39 pm

    #2022912

  • RE: Totals up to a specific date

    drew.allen - Monday, February 25, 2019 10:37 AM

    Luis Cazares - Monday, February 25, 2019 8:35 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

    February 25, 2019 at 10:56 am

    #2022869

  • RE: Slow running Stored Procedure when using Date Parameters

    dukesbrent - Monday, February 25, 2019 8:56 AM

    I have a SP as follows:

    CREATE PROCEDURE dbo.MyProcedure @StartDate Datetime, @EndDate Datetime, @ReportingPeriod varchar(254)
    As
    ...

    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

    February 25, 2019 at 9:25 am

    #2022858

  • RE: SQL Server Database Administrator Interview Questions

    Jeff Moden - Monday, February 25, 2019 8:17 AM

    Brandie Tarvin - Monday, February 25, 2019 4:49 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

    February 25, 2019 at 8:49 am

    #2022854

  • RE: Totals up to a specific date

    lukaszpiech - Monday, February 25, 2019 3:31 AM

    Hello,
    it would be great if someone could help me with the following problem.
    I need to...

    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

    February 25, 2019 at 8:35 am

    #2022847

  • RE: Identifying SQL Injection possabilities with dapper -spExecute and IS this sp open to SQL injection

    By the way, an INSERT INTO...VALUES won't have problems with Parameter Sniffing, so you don't need to use RECOMPILE.
    Have you considered not having lots of tables with uniqueidentifiers as...

    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

    February 22, 2019 at 7:18 am

    #2022652

  • RE: Identifying SQL Injection possabilities with dapper -spExecute and IS this sp open to SQL injection

    lazynewt - Friday, February 22, 2019 6:20 AM

    Hi can anyone offer input on the below code. Assuming the below SP is...

    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

    February 22, 2019 at 7:13 am

    #2022651

  • RE: Window Function

    If that query returns the correct result, I would just suggest to change the scalar UDF into an Inline Table-Valued Function. There's an explanation on how to do it in...

    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

    February 20, 2019 at 12:32 pm

    #2022502

  • RE: Unpivot query

    as1981 - Tuesday, February 19, 2019 12:49 PM

    Hello,

    Thank you. That gives me the result I need.

    Thanks

    That's good to know, but do you...

    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

    February 19, 2019 at 1:28 pm

    #2022425

Viewing 15 posts - 196 through 210 (of 8,731 total)