Forum Replies Created

Viewing 15 posts - 8,596 through 8,610 (of 8,731 total)

  • RE: True/False MAX VS SELECT Top 1

    This way is easier for everyone

    http://www.johnsansom.com/performance-comparison-of-select-top-1-verses-max/

    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 14, 2012 at 8:56 am

    #1525578

  • RE: How should i free up the space from the BACKUP Drive whcih is increasing Rapidly

    I know it's been said that there are no magical solutions, but how about upgrading the server to use backup compression?

    PS. Could you avoid sms language?

    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 14, 2012 at 8:17 am

    #1525547

  • RE: Crazy Interviews

    Scott D. Jacobson (8/14/2012)

    Now if you really need the gig, you could always do as Luis suggests. Suck it up and take it. Try to be patient and...

    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 14, 2012 at 7:47 am

    #1525524

  • RE: How do you use a sub query in a join?

    Is REF_DOC a unique value? Or do you have it several times in ztb_Carrier_Delivery_Metrics?

    As I see it, this is a problem with your data.

    EDIT: Could you show us your code...

    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 14, 2012 at 7:37 am

    #1525512

  • RE: Crazy Interviews

    Scott Arendt (8/14/2012)

    I just don't get the "shock" interview mentality. My boss did this to one of my co-workers. He brought him in for an interview and about half way...

    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 14, 2012 at 7:07 am

    #1525489

  • RE: What is meant by set based programming?

    From what I remember, The Matrix trilogy is about a loop and a conditional BREAK. So they wouldn't be set-based. I would call them simple RBAR. :-D:-P

    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 14, 2012 at 7:01 am

    #1525487

  • RE: Print The Calender 2

    timothy.shawley (8/13/2012)

    One issue - the Leap Day calculation is missing one constraint - February does not have 29 days in Centuries not divisible by 400, ie 2100 will be 28...

    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 13, 2012 at 3:11 pm

    #1525304

  • RE: Help designing a patent database

    The main advantage is the storage 4bytes against 20bytes.

    Another advantage would be the ease of creation for new identities (SQL Server will create them automatically).

    However, there's a constant debate on...

    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 13, 2012 at 2:10 pm

    #1525267

  • RE: Error Handling: TRY...CATCH

    You should use an IF...ELSE... statement if you want to evaluate a condition.

    With your query you're assigning the value to the variable, not comparing. It should be like this.

    IF @CurrentDay...

    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 13, 2012 at 1:31 pm

    #1525250

  • RE: SQL Tool that integrates into Notepad++

    I like Notepad++ very much, but I can't figure out why would you be interested in buying a software to run queries in it instead of doing it in SSMS.

    I'm...

    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 13, 2012 at 8:38 am

    #1525076

  • RE: Default value gets changed

    I can't try it in here, but have you tried to assign the default value to REPLICATE( '0', 15)?

    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 10, 2012 at 1:45 pm

    #1524648

  • RE: I need to write a very bad query

    I have an idea, but could you please post DDL before I start working on it?

    Have you seen Jeff Moden's articles on Hidden RBAR?

    Hidden RBAR: Triangular Joins

    [/url] Hidden RBAR: Counting...

    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 10, 2012 at 1:23 pm

    #1524632

  • RE: record count top 5 then other

    SQL_NuB (8/10/2012)

    my query looks something like this (I can't show the actual ddl or query)

    But you could change the names of the table and columns and post some DDL and...

    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 10, 2012 at 1:15 pm

    #1524628

  • RE: record count top 5 then other

    Just guessing...

    ;WITH Top5 AS(

    SELECT TOP 5

    state,

    COUNT( DISTINCT customer) AS customers

    ...

    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 10, 2012 at 1:11 pm

    #1524624

  • RE: How do you use a sub query in a join?

    You could also consider using CTEs.

    WITH Notifications AS (

    SELECT sales_order_number

    , count(sales_order_number) as Notification_cnt

    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

    August 10, 2012 at 11:51 am

    #1524586

Viewing 15 posts - 8,596 through 8,610 (of 8,731 total)