Forum Replies Created

Viewing 15 posts - 15,451 through 15,465 (of 19,560 total)

  • RE: Foreign key constraints...WHY??

    sumit.joshij (4/2/2010)

    instead of you can use it in the Interface level handling.

    I disagree. The application should not manage database integrity.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 12:57 pm

    #1145052

  • RE: Are the posted questions getting worse?

    Paul White NZ (4/2/2010)

    Yay! My apply articles have been scheduled!!! 12th & 19th April - excited :w00t:

    Thanks Steve!

    Congrats - they are well written.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 12:37 pm

    #1145036

  • RE: Are the posted questions getting worse?

    Trey Staker (4/2/2010)

    Hmmm... makes me wonder how most of you study?

    I know my knowledge gaps and constantly try and fill them. Occasionally through the forum discussions I've...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 12:37 pm

    #1145035

  • RE: Are the posted questions getting worse?

    Paul White NZ (4/2/2010)

    CirquedeSQLeil (4/2/2010)

    I envision the MCM being completely different.

    Ha. This is something I do quite a lot in real life: have a whole discussion in my head...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 12:32 pm

    #1145030

  • RE: The Missing Certification

    Paul White NZ (4/2/2010)

    I find the whole TiS thing very difficult - it adds a fair amount of administrative overhead without really proving much. I guess maybe a year...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 12:29 pm

    #1145029

  • RE: Are the posted questions getting worse?

    Alvin Ramard (4/2/2010)

    Sometimes I'm still amazed by how fast technology moves. I just ordered a 2 TB HD for $150. The first computer I ever ordered included a...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 12:25 pm

    #1145024

  • RE: Speed up a database shrink

    Chad Crawford (4/2/2010)

    Ah. I missed that. I was thinking of setting up the Snapshot to run once per week, and then maintaining that publication as procs or...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 12:18 pm

    #1145020

  • RE: Application loses connection to the database

    dmiller-745870 (4/1/2010)

    Since we switched over to the new system (SQL Server 2008), I am having problems staying connected. If I leave the system for a bit when I go back...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 12:17 pm

    #1145019

  • RE: Are the posted questions getting worse?

    Paul White NZ (4/2/2010)

    CirquedeSQLeil (4/2/2010)

    Paul White NZ (4/2/2010)

    A good way to prepare for the MCM 😉

    Don't make me laugh so hard.

    Why laugh? :blink: :crying:

    I envision the MCM being completely different....

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 12:10 pm

    #1145015

  • RE: The Missing Certification

    Grant Fritchey (4/2/2010)

    Lynn Pettis (4/2/2010)

    I also believe that the certification should be renewed periodically, minimum 3 years, maximum 5 years.

    Recertification should include testing, presenting original material at users groups/conferences, attending...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 12:04 pm

    #1145010

  • RE: Speed up a database shrink

    Paul White NZ (4/2/2010)

    Jason,

    Paul White NZ (4/2/2010)

    I would be tempted to restore the production database to the staging server, and then run a script to set up snapshot replication with...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 12:00 pm

    #1145008

  • RE: DBCC CHECKDB

    gmamata7 (4/2/2010)

    Absolutely. CheckDB reads every allocated page in the entire database, hence you're going to have a lot of churn in the data cache as pages come in get checked...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 11:59 am

    #1145007

  • RE: The Missing Certification

    Paul White NZ (4/2/2010)

    I think I would be keen on a certification that had these elements:

  • Minimal time-in-service requirement
  • An adaptive on-line multiple-choice test

  • A set of tasks to perform on a sample...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

April 2, 2010 at 11:57 am

#1145003

  • RE: Today's Random Word!

    John Rowan (4/2/2010)

    dbowlin (4/2/2010)

    Here comes the sun!

    Here comes the Son! Have a Happy Easter weekend everyone!

    You too.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 11:54 am

    #1144999

  • RE: The Missing Certification

    Jack Corbett (4/2/2010)

    CirquedeSQLeil (4/2/2010)

    Let's add that to the list. I forgot recertification.

    What if the certified candidate remains actively engaged in the community, would they need to follow the same...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 2, 2010 at 11:54 am

    #1144998

    • Viewing 15 posts - 15,451 through 15,465 (of 19,560 total)