Forum Replies Created

Viewing 15 posts - 8,116 through 8,130 (of 8,731 total)

  • RE: need help on sql script

    The easiest way is to change the order of the tables creation put StudentAccount after Instructor.

    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

    May 31, 2013 at 1:09 pm

    #1620205

  • RE: Simple Doubles Query

    You could use a query like this, but you may want to complete it.

    This will give you the StandIDs in more than one Stadium. To get the ones that are...

    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

    May 31, 2013 at 12:44 pm

    #1620197

  • RE: Problem adding to a query

    I've been doing it for so long, I'm not sure where to look for. Maybe the stairway to T-SQL [/url] on this site can be a good start but I...

    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

    May 31, 2013 at 11:22 am

    #1620179

  • RE: Problem adding to a query

    dwg23 (5/31/2013)

    Here is the code I ended up with and if anyone can explain why adding 'max' to the sub query's made them work I would love to be educated...

    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

    May 31, 2013 at 11:00 am

    #1620171

  • RE: Problem adding to a query

    I'm sorry, my intention wasn't to be rude, I've had a tough week at work (some might have an idea why is that). I'm really interested in helping you, otherwise...

    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

    May 31, 2013 at 8:29 am

    #1620105

  • RE: Add New column and Update column in same script!

    Use a batch separator (a.k.a. GO).

    This will help you unless you're using the query inside a SP.

    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

    May 30, 2013 at 5:32 pm

    #1619939

  • RE: Problem adding to a query

    I'm sorry but I forgot my mindreader cap.

    Could you post the errors you're getting and the DDL involved? Some sample data and expected results will help us to see what...

    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

    May 30, 2013 at 5:31 pm

    #1619937

  • RE: Flagging Records within a table of sequenced numbers

    I'm glad it worked almost fine and even more glad that you tested the code before using it. 🙂

    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

    May 30, 2013 at 3:20 pm

    #1619918

  • RE: Need help with Pseduo code for arequirement

    Could you post DDL (tables structure) and sample data? And define what's a match and what else is involved.

    I'm thinking on using UPDATE... WHERE [NOT] EXISTS( <query to find 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

    May 30, 2013 at 1:41 pm

    #1619865

  • RE: NOLOCK hint.

    I've sent some emails and the answer was that they are aware of the implications of using it but it's a policy and must be followed.

    I'll save that email 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

    May 30, 2013 at 10:56 am

    #1619794

  • RE: Scalar Valued functions

    As general information, user defined scalar valued functions won't allow you to use parallellism in your queries.

    You might find better performance using an inline Scalar Valued Function as called 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

    May 30, 2013 at 10:38 am

    #1619788

  • RE: NOLOCK hint.

    Michael Valentine Jones (5/30/2013)

    Luis Cazares (5/30/2013)

    GilaMonster (5/28/2013)

    WangcChiKaBastar (5/28/2013)

    our database is not financial, our use of NOLOCK hint was to increase concurrency and limit contention (deadlock).

    Use one of the snapshot isolation...

    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

    May 30, 2013 at 10:31 am

    #1619786

  • RE: NOLOCK hint.

    Eugene Elutin (5/30/2013)

    Luis Cazares (5/30/2013)

    GilaMonster (5/28/2013)

    WangcChiKaBastar (5/28/2013)

    our database is not financial, our use of NOLOCK hint was to increase concurrency and limit contention (deadlock).

    Use one of the snapshot isolation levels....

    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

    May 30, 2013 at 9:31 am

    #1619761

  • RE: NOLOCK hint.

    GilaMonster (5/28/2013)

    WangcChiKaBastar (5/28/2013)

    our database is not financial, our use of NOLOCK hint was to increase concurrency and limit contention (deadlock).

    Use one of the snapshot isolation levels. Financial or non-financial, I've...

    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

    May 30, 2013 at 9:17 am

    #1619754

  • RE: List of queries using MAXDOP

    This code can help you to find it within Stored Procedures

    DECLARE @Search_Text nvarchar(128) = 'MAXDOP',

    @Command1 nvarchar(2000)

    SET @Command1 =

    'IF EXISTS( SELECT 1 FROM [?].sys.sql_modules m JOIN [?].sys.procedures p ON m.object_id =...

    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

    May 29, 2013 at 5:36 pm

    #1619525

Viewing 15 posts - 8,116 through 8,130 (of 8,731 total)