Forum Replies Created

Viewing 15 posts - 1,051 through 1,065 (of 8,731 total)

  • RE: When to use a clustered and/or non-clustered index

    This is also a good place to start.
    http://www.sqlinthewild.co.za/index.php/2011/11/11/sql-university-advanced-indexing-indexing-strategies/

    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

    August 3, 2017 at 9:54 am

    #1954002

  • RE: When to use a clustered and/or non-clustered index

    itmasterw 60042 - Thursday, August 3, 2017 9:23 AM

    Hi,

    I have been looking all over the net...

    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

    August 3, 2017 at 9:45 am

    #1954000

  • RE: Are the posted questions getting worse?

    I just got an email containing this:

    Luis,
    Do you have any update on adding the indexes on production.

    •   Task # 1

    • Add more...

    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

    August 3, 2017 at 9:29 am

    #1953993

  • RE: Using PATINDEX To Determine If A String Is Alpha

    Or you could use LIKE.


    SELECT *
    FROM YourTable
    WHERE YourColumn NOT LIKE '%[^a-zA-Z ]%';

    There's a double negative there. It mentions to get the...

    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

    August 3, 2017 at 8:10 am

    #1953977

  • RE: Best way to encrypt credit card information?

    You can propose them to use ROT-5 encoding and even using it twice for improved security.
    Then, you can let them know that they shouldn't be taking shortcuts on data...

    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

    August 3, 2017 at 7:17 am

    #1953962

  • RE: Update NULL values - SQL Help

    Here's an option on how to do it. I'm not sure if it's the optimal way.

    --Using SELECT
    SELECT *
    FROM #ACT o
    OUTER APPLY (SELECT...

    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

    August 2, 2017 at 12:58 pm

    #1953838

  • RE: Update NULL values - SQL Help

    kishoremania - Wednesday, August 2, 2017 11:47 AM

    Hello Everyone, 

    Need some help in updating one column, I come up with some sample data.

    Create...

    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

    August 2, 2017 at 12:15 pm

    #1953831

  • RE: how to deploy 10 T-SQL scripts across 200 databases

    Jeff Moden - Wednesday, August 2, 2017 8:42 AM

    premkumardr - Tuesday, August 1, 2017 5:26 PM

    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

    August 2, 2017 at 10:17 am

    #1953814

  • RE: How to I convert this code from Oracle to SQL Server?

    Or you could remove the REPLACE altogether with a different format code.
    SELECT CONVERT (char(10), GETDATE(), 101) AS DOB

    But I agree with leaving the formatting 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

    August 2, 2017 at 6:19 am

    #1953755

  • RE: Are the posted questions getting worse?

    Sean Lange - Tuesday, August 1, 2017 2:06 PM

    Ed Wagner - Tuesday, August 1, 2017 2:00 PM

    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

    August 2, 2017 at 6:13 am

    #1953753

  • RE: Are the posted questions getting worse?

    Sean Lange - Tuesday, August 1, 2017 1:08 PM

    So our person who is the lead person on the help desk is helping...

    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

    August 2, 2017 at 6:08 am

    #1953752

  • RE: How can I improve performance of this query further?

    I'll repeat it.
    You're querying too many rows. The estimates show about 12M rows.
    That said, I wonder what would happen if you add a JOIN hint. Try adding the...

    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

    August 1, 2017 at 11:03 am

    #1953636

  • RE: How can I improve performance of this query further?

    The issue is that you're selecting all the rows. To be able to take full advantage of an index, you need to limit the results.
    You're obfuscating the query by...

    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

    August 1, 2017 at 10:22 am

    #1953631

  • RE: The Floor

    Christoph Muthmann - Monday, July 31, 2017 2:06 AM

    Hi Steve,
    in your solution the Group by is missing.

    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

    July 31, 2017 at 9:27 am

    #1953409

  • RE: Changing type from INT to BIGINT why so slow?

    I'm not sure if this would work (I've never tried it), but you might want to test it.
    Rebuild the clustered index with a fill factor that allows enough room...

    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

    July 31, 2017 at 9:14 am

    #1953406

Viewing 15 posts - 1,051 through 1,065 (of 8,731 total)