Forum Replies Created

Viewing 15 posts - 436 through 450 (of 631 total)

  • RE: Schema design for immutable FK data vs user created FK data

    If the only difference is that some rows may have certain data elements updated and others can't, I'd say they belong in the same table (there are bound to be...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: TempDB datafiles

    peter.cox (2/12/2014)


    sorry - my bad. Meant there was no extended jobs. I'll have a read on Extended events (I've come from a SQL 2005 environment, so still not 100% au...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Software Patents

    Eric M Russell (1/30/2014)


    djackson 22568 (1/30/2014)


    Software code should not be able to be patented. A copyright is more appropriate. There is little difference between me writing a book...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Trigger

    crazy_new (1/29/2014)


    There are multiple line in the Invoice line table with the same ID, that's why I joined the Invoice ID and Invoice header.

    I have to move them across from...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Uncontrolled Code

    But users shouldn't necessarily have to choose between strongly typed schema versus spreadsheets. It's conceptually possible to overlay schema on a column/record/cell based spreadsheet.

    Good god man, it's hard enough...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Uncontrolled Code

    Jim P. (1/24/2014)


    andrew gothard (1/24/2014)


    Do you not mean http://en.wikipedia.org/wiki/Jude_the_Apostle ?

    If you read the St Simeon link he is considered the patron saint of fools.

    Indeed.

    St Jude is the Patron Saint of...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: SCUD?

    Jeff Moden (1/24/2014)


    andrew gothard (1/24/2014)


    netmikem (1/23/2014)


    Thanks for the feedback.

    The job ad definitely says SCUD. Here is the particular qualification statement ...

    "Must have minimum eight years' experience with SQL, coding queries,...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Uncontrolled Code

    Jim P. (1/23/2014)


    It is us in IT whose responsibility is to highlight how a solution can be provided with as many of the risks mitigated without stripping the users of...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: SCUD?

    netmikem (1/23/2014)


    Thanks for the feedback.

    The job ad definitely says SCUD. Here is the particular qualification statement ...

    "Must have minimum eight years' experience with SQL, coding queries, SCUD, stored procedures and...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    GilaMonster (11/27/2013)


    Anyone want to handle this one?

    'A server which sends custom alerts is sending notifications that an offline database is offline. Why would it do that?'

    http://www.sqlservercentral.com/Forums/Topic1518022-146-1.aspx

    I *Want* to ... but...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    jasona.work (11/26/2013)


    /rant mode on

    Frickin' bloody pain in the tuckus idiotic mindless rules drones! Gotta go in early tomorrow because it's entirely possible a SQL server and a couple Oracle...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    LutzM (11/23/2013)


    Greg Edwards-268690 (11/23/2013)

    We had SQL Server, DB2, Sybase, and Oracle. But we moved the application from Oracle to SQL Server. And DB2 was for the ERP System, and moved...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    When I said half I was looking at just these two lines:

    Eight to ten years database programming experience using two or more of the following databases; MS SQL Server, Oracle,...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/22/2013)


    Revenant (11/22/2013)


    Jeff Moden (11/22/2013)


    I'm, very thankfully, not currently in a postition like Lynn where I need to find a job because I wouldn't even consider working for a...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: CHECKDB Error

    This should be able to be fixed by dropping and recreating the index.

    http://www.sqlskills.com/blogs/paul/teched-demo-nonclustered-index-corruption/

    however, the question of why the index has become corrupted is also an issue. Do you have...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

Viewing 15 posts - 436 through 450 (of 631 total)