Forum Replies Created

Viewing 15 posts - 871 through 885 (of 8,731 total)

  • RE: Delete records using Minus command in sql

    Lynn Pettis - Friday, October 27, 2017 1:19 PM

    vijaykumar.s - Friday, October 27, 2017 12:54 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

    October 27, 2017 at 1:33 pm

    #1965609

  • RE: Simple Queries Run Slow

    SKP DBA - Friday, October 27, 2017 9:42 AM

    Dear Experts,

    Simple queries run lot of time in millions record table table have around...

    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

    October 27, 2017 at 10:18 am

    #1965556

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, October 26, 2017 10:43 AM

    Luis Cazares - Thursday, October 26, 2017 10:33 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

    October 26, 2017 at 10:50 am

    #1965360

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, October 26, 2017 9:15 AM

    Steve Jones - SSC Editor - Thursday, October 26,...

    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

    October 26, 2017 at 10:33 am

    #1965358

  • RE: how to validate my string in sql

    kramaswamy - Thursday, October 26, 2017 8:43 AM

    I'd extend that one step further, given that the original query had VARCHAR(10) instead...

    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

    October 26, 2017 at 9:03 am

    #1965329

  • RE: Need help in improving performance of a stored proc which invokes multiple scalar functions on the resultset

    I think that I can convert this into an inline table-valued function. That would at least allow parallelism and won't be called one row at a time.
    I just need...

    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

    October 26, 2017 at 8:43 am

    #1965316

  • RE: Out of memory exception

    planetmatt - Wednesday, October 25, 2017 9:35 AM

    Luis Cazares - Wednesday, October 25, 2017 9:29 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

    October 25, 2017 at 10:06 am

    #1965174

  • RE: Out of memory exception

    Avoid showing the results in the grid and just show them on text. That might help to reduce memory consumption by SSMS.

    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

    October 25, 2017 at 9:29 am

    #1965165

  • RE: Checking SQL code for unused column references?

    palandri - Thursday, October 19, 2017 12:33 PM

    I have a couple long (1000+ lines) queries in development. I tend to use 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

    October 24, 2017 at 12:30 pm

    #1964990

  • RE: Session Scope with Temporary Tables and Dynamic SQL

    Is it basically the same  behavior shown here?
    https://www.brentozar.com/archive/2017/09/ghosts-temp-tables-past/

    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

    October 24, 2017 at 11:34 am

    #1964980

  • RE: How to pivot multiple column?

    For a dynamic approach, check the following article:
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - SQLServerCentral

    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

    October 24, 2017 at 8:41 am

    #1964954

  • RE: How to pivot multiple column?

    For that, you need to unpivot your values and pivot them again.
    I'm not using PIVOT and UNPIVOT operators, although , you could use them. I prefer the alternatives that...

    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

    October 24, 2017 at 7:04 am

    #1964932

  • RE: Session Scope with Temporary Tables and Dynamic SQL

    You can get information about temp tables' scope in here:
    https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql#temporary-tables

    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

    October 23, 2017 at 1:02 pm

    #1964849

  • RE: Challenging string handling in T-SQL

    You seem to be relatively new to the forums, but you should take into account that it's a good courtesy to post your sample data in a consumable format. I'll...

    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

    October 23, 2017 at 7:18 am

    #1964766

  • RE: Trying to speed up this 'GetWorkingDays' function.

    Jason A. Long - Friday, October 20, 2017 12:18 PM

    The plan w/ the new function isn't far too off from...

    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

    October 20, 2017 at 12:25 pm

    #1964568

Viewing 15 posts - 871 through 885 (of 8,731 total)