Forum Replies Created

Viewing 15 posts - 16 through 30 (of 355 total)

  • RE: Accept Failure

    phegedusich (2/22/2012)


    Does the end product do what the client wants it to do?

    I've struggled with this many times. The clients give you requirements, you build it exactly as stated...

  • RE: Make Rows As Columns

    Divine Flame (2/21/2012)


    guptaanshulcse (2/21/2012)


    Use Pivot table in sql

    I am not sure how he is identifying the events. I don't see any column which can be used to uniquely identify a...

  • RE: Model Database

    Good question and as others have already pointed out, the documentation is wrong:

    From http://msdn.microsoft.com/en-us/library/ms186388.aspx

    The following operations cannot be performed on the model database:

    Adding files or filegroups.

    ...

  • RE: Accept Failure

    I thought I made an error once but after thorough research, I realized I was mistaken.

  • RE: Hash Join

    To be a little nit picky, when creating a question that you need to select 4 of 5 checkboxes, it's probably more appropriate to reword the question and have the...

  • RE: Stop and Start Services - SQL School Video

    When the passwords are encrypted on the server, you cannot use the restart options or even use the SQL Server Management console to start the services. Stopping the services...

  • RE: How to avoid NOT IN?

    What would happen to your performance if you created a table that contained the 12 to 15 strings you want to include. Then, do a simple join on that...

  • RE: Programmers v Salespeople

    emmchild (2/19/2012)


    Shareholders like quarterly results. If a position is viewed on an annual basis there will be trouble. Executives think quarterly too. If you mention your performance over...

  • RE: Programmers v Salespeople

    emmchild (2/19/2012)


    Internal operations are a cost center. The business view of cost centers is that this functionality can be out sourced.

    I have to respectfully disagree. Developers for a...

  • RE: Programmers v Salespeople

    Dalkeith (2/19/2012)


    Cengland

    In an ideal world yes they would.

    Too often a developer in a non developer organisation will be totally undervalued. It is likely he will have different qualifications and knowledge...

  • RE: Programmers v Salespeople

    emmchild (2/18/2012)


    Sales should be paid based on their ability to bring in new business. If a developer, NOT a programmer, can bring in business then pay them both equally....

  • RE: T-SQL Performance 1

    Hugo Kornelis (2/17/2012)


    cengland0 (2/17/2012)


    I immediately thought of using a hint to force the use of the index. Is that wrong somehow?

    SELECT ID,Col

    FROM FirstTable WITH INDEX(IX_Col)

    WHERE...

  • RE: T-SQL Performance 1

    I immediately thought of using a hint to force the use of the index. Is that wrong somehow?

    SELECT ID,Col

    FROM FirstTable WITH INDEX(IX_Col)

    WHERE Col = @Get;...

  • RE: Programmers v Salespeople

    Started my career as a sales person. Then, became a general IT person (programmer, database admin, web admin, etc).

    I can tell you from experience, it was much easier to...

  • RE: MERGE

    The BOL reference also says:

    The MERGE statement requires a semicolon (;) as a statement terminator. Error 10713 is raised when a MERGE statement is run without the terminator.

    I didn't see...

Viewing 15 posts - 16 through 30 (of 355 total)