Forum Replies Created

Viewing 15 posts - 556 through 570 (of 2,894 total)

  • RE: problem in select command

    Sergiy (3/18/2013)

    Eugene Elutin (3/18/2013)

    :w00t::w00t::w00t::w00t::w00t:

    "extra words" is a greatest argument to declare a "code" winner I'have ever seen.

    Did you find anything else different?

    Anything?

    If you missed it - I responded on this...

    _____________________________________________
    "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]

    March 18, 2013 at 5:09 pm

    #1598227

  • RE: Help with XML Explicit and nesting

    Welcome to the forum!

    Unfortunately , details provided with your question are not sufficient enough to make any helpful suggestions - only guesses, which quite often will be irrelevant. Therefore, I...

    _____________________________________________
    "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]

    March 18, 2013 at 11:37 am

    #1598124

  • RE: sql agent job output file to different server has error

    Your MGH\sqlagent should have full-control access to the folder on your "different server".

    Also, check if you can ping your "different server" from the SQL one.

    _____________________________________________
    "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]

    March 18, 2013 at 11:28 am

    #1598123

  • RE: Read Committed_Snapshot

    Grant Fritchey (3/18/2013)

    Eugene Elutin (3/18/2013)

    Grant Fritchey (3/18/2013)

    ... or two as well.

    Googled out the second one (surprisingly to me - based on "stock management":

    http://www.jimmcleod.net/blog/index.php/2009/08/27/the-potential-dangers-of-the-read-committed-snapshot-isolation-level/

    OK. For a lock control system...

    _____________________________________________
    "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]

    March 18, 2013 at 11:13 am

    #1598119

  • RE: sql pages out before hitting low memory

    What is current settings of your SQL Server (max server memory)?

    _____________________________________________
    "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]

    March 18, 2013 at 10:40 am

    #1598109

  • RE: Read Committed_Snapshot

    Oops, too many windows. Post edited!

    Actually, the code version you have seen for window 2, was a good code example, which would work properly with any isolation level...

    _____________________________________________
    "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]

    March 18, 2013 at 10:14 am

    #1598102

  • RE: Read Committed_Snapshot

    Grant Fritchey (3/18/2013)

    ... or two as well.

    Googled out the second one (surprisingly to me - based on "stock management":

    http://www.jimmcleod.net/blog/index.php/2009/08/27/the-potential-dangers-of-the-read-committed-snapshot-isolation-level/

    _____________________________________________
    "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]

    March 18, 2013 at 10:10 am

    #1598099

  • RE: Read Committed_Snapshot

    Grant Fritchey (3/18/2013)

    opc.three (3/18/2013)

    Eugene Elutin (3/18/2013)

    If you enable READ COMMITTED SNAPSHOT in the database, it becomes the default isolation level.

    For clarity READ_COMMITTED_SNAPSHOT is just a mode of the READ_COMMITTED isolation...

    _____________________________________________
    "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]

    March 18, 2013 at 10:02 am

    #1598095

  • RE: First and Last number

    kapil_kk (3/18/2013)

    Eugene Elutin (3/18/2013)

    SELECT TransactionID, MIN(VoucherNo) , MAX(VoucherNo )

    FROM yourtable

    GROUP BY TransactionID

    can you plz explain me how Min, MAX is working with alphanumeric values like 'VB00001'

    In the same way 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]

    March 18, 2013 at 6:16 am

    #1598023

  • RE: problem in select command

    I really liked it, so my second response !

    Sergiy (3/17/2013)

    Lynn Pettis (3/17/2013)

    Really, CTEs are

    complex? I find them to make writing queries easier as you don't have to...

    _____________________________________________
    "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]

    March 18, 2013 at 6:05 am

    #1598019

  • RE: problem in select command

    ...

    Derived table wins as it does not contain extra words ";WITH MyData AS ".

    ...

    :w00t::w00t::w00t::w00t::w00t:

    "extra words" is a greatest argument to declare a "code" winner I'have ever seen.

    Extra typing always makes...

    _____________________________________________
    "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]

    March 18, 2013 at 5:58 am

    #1598018

  • RE: First and Last number

    SELECT TransactionID, MIN(VoucherNo) , MAX(VoucherNo )

    FROM yourtable

    GROUP BY TransactionID

    _____________________________________________
    "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]

    March 18, 2013 at 5:42 am

    #1598012

  • RE: Read Committed_Snapshot

    If you enable READ COMMITTED SNAPSHOT in the database, it becomes the default isolation level.

    So, it can break some of your application functionality which would depend on default behavior under...

    _____________________________________________
    "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]

    March 18, 2013 at 5:07 am

    #1598004

  • RE: Stop large queries from running

    akberali67 (3/18/2013)

    Hi,

    I have a query window with a lot of code but I do not want to run it entirely in error, is there something I can place in the...

    _____________________________________________
    "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]

    March 18, 2013 at 3:24 am

    #1597988

  • RE: Custom sp_who

    ... but I don't want to grant view server state permissions and all that it exposes...

    What exactly are you afraid of? What dangerous things does it expose other than ability...

    _____________________________________________
    "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]

    March 18, 2013 at 3:13 am

    #1597985

Viewing 15 posts - 556 through 570 (of 2,894 total)