Forum Replies Created

Viewing 15 posts - 12,916 through 12,930 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (8/11/2010)

    I asked this to several people at the PASS summit last year. No one (other the ex-South African) got it even close to right.

    How do you pronounce "Gauteng"?

    For extra...

    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

    August 11, 2010 at 11:54 am

    #1205595

  • RE: Yet another FOREIGN_KEY / INSERT question

    Ray K (8/11/2010)

    jerry-621596 (8/11/2010)

    Yeah, saw that after posting. Keep getting side tracked by work.

    I know the feeling. Damned work stuff always seems to get in the way! :hehe:

    It's...

    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

    August 11, 2010 at 11:52 am

    #1205593

  • RE: A Quick Look at the MPP World

    Thanks for the article.

    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

    August 11, 2010 at 11:41 am

    #1205580

  • RE: Are the posted questions getting worse?

    Here's a good one:

    Horse is pronounced HARSE in some smaller towns around here.

    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

    August 11, 2010 at 11:39 am

    #1205576

  • RE: Fooling SQL Server

    Steve Jones - Editor (8/11/2010)

    The backup file isn't changed. What happens when you do the restore is that the mdf/ldf/ndf are created as sparse files. All reads from these files...

    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

    August 11, 2010 at 11:27 am

    #1205561

  • RE: The Bottom Line

    OCTom (8/11/2010)

    Not being a DBA, I don't know the answer to this. Do DBA's work independently or do they get permission first before making changes? AS a developer and "accidental"...

    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

    August 11, 2010 at 11:25 am

    #1205559

  • RE: Are the posted questions getting worse?

    Kit G (8/11/2010)

    Ray K (8/11/2010)

    Kit G (8/11/2010)

    Ray K (8/11/2010)

    Ah -- if I remember my Rochester geography correctly, you were in Chili or Henrietta (or somewhere thereabouts), is that right? ...

    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

    August 11, 2010 at 11:15 am

    #1205552

  • RE: Raw Materials - Healthy Caution or... Something Else?

    I'll join the fray. I'm thinking of posting this in my cube anyway.

    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

    August 11, 2010 at 10:20 am

    #1205506

  • RE: My MSDB Database is over 31 GB in the development server

    AndrewSQLDBA (8/11/2010)

    Since it is NOT a SSIS Server, then why are you storing all those SSIS packages in the MSDB database?

    Remove them, that will free up a few Gigs...

    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

    August 11, 2010 at 10:09 am

    #1205501

  • RE: Use of IDENTITY_INSERT?

    Thanks for the question.

    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

    August 11, 2010 at 10:05 am

    #1205494

  • RE: My MSDB Database is over 31 GB in the development server

    dsohal (8/11/2010)

    can you please get me the query to delete it,

    It's not a matter of deleting it at this point. The Service Broker needs to be properly configured. ...

    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

    August 11, 2010 at 10:02 am

    #1205490

  • RE: My MSDB Database is over 31 GB in the development server

    Well, that is much more helpful.

    You need to purge the sysxmitqueue. Basically there is an application that is sending messages to your server. Somebody enabled service broker but...

    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

    August 11, 2010 at 10:00 am

    #1205487

  • RE: The Bottom Line

    DBA's are in a good position. We can fix problems that are highly visible. The flipside is that since we often take ownership of those problems, people associate...

    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

    August 10, 2010 at 11:56 pm

    #1205155

  • RE: Fooling SQL Server

    Steve Jones - Editor (8/10/2010)

    Apologies to anyone that feels I crossed the line into too much advertising. I was asked to write something on this product, and I think I...

    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

    August 10, 2010 at 10:28 pm

    #1205125

  • RE: Are the posted questions getting worse?

    Just an FYI, TSQL Tuesday is today. The theme is Beach Time and you can find more info here[/url].

    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

    August 10, 2010 at 2:41 pm

    #1205048

Viewing 15 posts - 12,916 through 12,930 (of 19,560 total)