Forum Replies Created

Viewing 15 posts - 46 through 60 (of 2,894 total)

  • RE: Alter table performance

    Use ALTER TABLE

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 19, 2015 at 4:01 am

    #1771067

  • RE: If Else logic

    --Requirement : If i pass 0 then it has to get the rows corresonding to (IsSalaryApproved = 0) else it has to bring all the records.

    You can do:

    select * ...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 14, 2015 at 10:15 am

    #1770171

  • RE: How to get a consecutive count based on the first value

    Stephanie Giovannini (1/14/2015)

    Even if it's readable, I wouldn't suggest using Stephanie's code. It reads the table 7 times which can become a nightmare on large tables.

    Agreed. The other two candidate...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 14, 2015 at 8:56 am

    #1770155

  • RE: wait for delay inside a fuction

    Why would you want it in function? Whatever reason, it would be highly unrecommened.

    However you can use dummy loop:

    declare @dtStart datetime=getutcdate()

    ...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 14, 2015 at 7:56 am

    #1770127

  • RE: ROW_NUMBER() OVER (PARTITION BY *** ORDER BY ***) excluding NULL values

    "CASE WHEN"-less query also possible for ColC of string type:

    SELECT [ID]

    , ColC

    , LEN(ColC)-LEN(ColC)+ROW_NUMBER() OVER(PARTITION BY NULLIF(ISNULL(colC,''), colC) ORDER BY [ID])

    FROM #test1

    ORDER BY...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 14, 2015 at 7:42 am

    #1770119

  • RE: ROW_NUMBER() OVER (PARTITION BY *** ORDER BY ***) excluding NULL values

    With a given data type of your ColC column, you can do the same without any CASE WHEN:

    SELECT [ID]

    , ColC

    , ColC-ColC+ROW_NUMBER() OVER(...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 14, 2015 at 7:26 am

    #1770109

  • RE: "Best Practices" Questions

    I think this list is missing one extremely important "Best Practices" point:

    #7 Never connect to SQL SERVER by any means and never try to run any query against it as...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 14, 2015 at 6:45 am

    #1770089

  • RE: Read dynamic XML

    You should be able to modify the following as per your requirements:

    declare @p xml = '<root>

    <DOCTOR.SSN>

    <OldValue />

    <NewValue>111111111</NewValue>

    <DisplayName>Social Security Number</DisplayName>

    </DOCTOR.SSN>

    <DOCTOR.EMAILADDRESS>

    <OldValue>abc.com</OldValue>

    <NewValue>Julietest@yahoo.com</NewValue>

    <DisplayName>Email Address</DisplayName>

    </DOCTOR.EMAILADDRESS>

    ...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 13, 2015 at 7:27 am

    #1769810

  • RE: Read dynamic XML

    What kind of output do you want?

    Your output example doesn't represent recordset...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 13, 2015 at 7:06 am

    #1769800

  • RE: query/script/stored procedure which will return a single table with three columns

    Try this first:

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    or wait for someone who will do it for you...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 13, 2015 at 4:38 am

    #1769753

  • RE: Add Auto Incrementing column to my SELECT statement

    You can generate number on fly without using identity:

    SELECT CONVERT(VARCHAR(6), GETDATE(), 12) + 'GP' +

    RIGHT('00000' + CAST(ROW_NUMBER() OVER (ORDER BY (SELECT...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 13, 2015 at 4:35 am

    #1769752

  • RE: Multiple Condition CASE Statement or Sub-Queries

    sclayton 889 (1/12/2015)

    I will try this. Seems more understandable the multiple case statement one of my colleagues suggested.

    The conditions are not really too complicated here and I would recommend...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 12, 2015 at 10:25 am

    #1769572

  • RE: Multiple Condition CASE Statement or Sub-Queries

    1. to ignore(not delete) records that have an enterDate equal to either a conversiondate of '2010-01-01' OR a termDate of '2001-01-01'; If they do, use the processDate to select instead...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 12, 2015 at 9:35 am

    #1769552

  • RE: tempdb blocking

    Adam Bean (12/11/2014)

    After some more digging and testing, it would seem that a SELECT INTO does indeed lock some of the system tables.

    We're now starting to dissect performance between SELECT...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 11, 2014 at 10:20 am

    #1764152

  • RE: growth above normal log database!

    I would recommend this for reading:

    http://www.brentozar.com/archive/2013/09/index-maintenance-sql-server-rebuild-reorganize/

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 11, 2014 at 9:28 am

    #1764138

Viewing 15 posts - 46 through 60 (of 2,894 total)