Forum Replies Created

Viewing 15 posts - 15,211 through 15,225 (of 19,560 total)

  • RE: Raw Materials - Redundancy and Frugality

    Best one yet.

    I like how it appears that there is a play on the previous one with Derek being the "monitoring agent."

    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 7, 2010 at 12:44 am

    #1147058

  • RE: MCJ - The Missing Link

    Lynn Pettis (4/6/2010)

    CirquedeSQLeil (4/6/2010)

    Nicholas Cain (4/6/2010)

    Something I've not seen mentioned but really should be kept in mind with this is that cost should really not be a barrier to entry....

    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 7, 2010 at 12:40 am

    #1147057

  • RE: Are the posted questions getting worse?

    WayneS (4/6/2010)

    Does anyone else around here feel like a rocket scientist?[/u]

    Nope - don't see where the close parenthesis belongs 😉

    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 7, 2010 at 12:37 am

    #1147056

  • RE: Are the posted questions getting worse?

    Paul White NZ (4/6/2010)

    Tom.Thomson (4/6/2010)

    Already missed by hours where I am (6 hours late and still 18 posts to go).

    If the deadline was 6th April, it was missed by 17.5...

    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 6, 2010 at 11:30 pm

    #1147026

  • RE: DBA Tools:sp_whoio

    BTW, I like the idea driving this script. Nice job.

    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 6, 2010 at 11:29 pm

    #1147025

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

    sumit.joshij (4/6/2010)

    At least we all of you have to check the ORCALE database, those who are in favor of maintain the FK constrain.

    At least they(ORACLE corp) can have the knowledge...

    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 6, 2010 at 11:22 pm

    #1147022

  • RE: ANSI_NULLS

    Paul White NZ (4/6/2010)

    CirquedeSQLeil (4/6/2010)

    Nice question Paul.

    1. Did you get it right?

    2. Are you scared by the behaviour ANSI_NULLS OFF?

    Yes I got it correct.

    I thought you explained things...

    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 6, 2010 at 10:13 pm

    #1146994

  • RE: DBA Tools:sp_whoio

    cvn Rao (4/6/2010)

    Hi,

    Iam getting syntax errors while testing the syntax for the procedure sp_whoio..

    Can you please suggest on this ? Iam using sqlserver 2005.. Infact the output of this sp_whoio...

    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 6, 2010 at 10:10 pm

    #1146992

  • RE: Are the posted questions getting worse?

    Jeffrey Williams-493691 (4/6/2010)

    CirquedeSQLeil (4/6/2010)

    Paul White NZ (4/6/2010)

    CirquedeSQLeil (4/6/2010)

    I really thought the thread would surpass 14k today.

    Probably will - though the definition of 'today' varies...;-)

    Eight hours of 7th April 2010 remain...

    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 6, 2010 at 10:06 pm

    #1146989

  • RE: Getting decent sql server performance despite a slow drive

    Paul White NZ (4/6/2010)

    CirquedeSQLeil (4/6/2010)

    ...Master and Model should not be very big. MSDB might get some weight to it (but still kind of small). I move them personally...

    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 6, 2010 at 10:05 pm

    #1146988

  • RE: ANSI_NULLS

    Nice question Paul.

    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 6, 2010 at 10:03 pm

    #1146986

  • RE: Are the posted questions getting worse?

    Paul White NZ (4/6/2010)

    CirquedeSQLeil (4/6/2010)

    I really thought the thread would surpass 14k today.

    Probably will - though the definition of 'today' varies...;-)

    Eight hours of 7th April 2010 remain (local time).

    Down to...

    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 6, 2010 at 9:56 pm

    #1146981

  • RE: system tables only

    WayneS (4/6/2010)

    This will get you the system tables. I'll leave it up to you to do the reindexing / updating of stats.

    select *

    from sys.objects

    where type = 'U'

    ...

    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 6, 2010 at 9:55 pm

    #1146980

  • RE: Getting decent sql server performance despite a slow drive

    Paul White NZ (4/6/2010)

    Marts (4/6/2010)

    I am struggling to move it, from what I have read, you should shut off the agent, backup the DB and restore with move, however that...

    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 6, 2010 at 9:53 pm

    #1146978

  • RE: Are the posted questions getting worse?

    I really thought the thread would surpass 14k today.

    23 to go.

    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 6, 2010 at 9:50 pm

    #1146976

Viewing 15 posts - 15,211 through 15,225 (of 19,560 total)