Forum Replies Created

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

  • RE: Foreign Keys: Essential or Academic?

    GilaMonster (2/12/2014)

    Essential. Absolutely essential.

    I can't understand why he claims implementing relationships manually in the application (hence writing code to do so) could possibly be easier or less time consuming than...

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

    February 13, 2014 at 4:34 am

    #1688666

  • 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.

    February 12, 2014 at 9:15 am

    #1688445

  • 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.

    February 12, 2014 at 7:11 am

    #1688338

  • 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.

    January 31, 2014 at 2:50 am

    #1684959

  • 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.

    January 29, 2014 at 6:31 am

    #1684278

  • 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.

    January 24, 2014 at 2:54 pm

    #1683277

  • 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.

    January 24, 2014 at 2:45 pm

    #1683272

  • 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.

    January 24, 2014 at 9:07 am

    #1683166

  • 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.

    January 24, 2014 at 8:52 am

    #1683155

  • 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.

    January 24, 2014 at 5:38 am

    #1683091

  • 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.

    December 2, 2013 at 3:23 pm

    #1670239

  • 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.

    December 2, 2013 at 3:21 pm

    #1670237

  • 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.

    December 2, 2013 at 3:03 pm

    #1670234

  • 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.

    December 2, 2013 at 2:50 pm

    #1670232

  • 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.

    December 2, 2013 at 2:33 pm

    #1670231

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