Forum Replies Created

Viewing 15 posts - 14,131 through 14,145 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (5/7/2010)

    Here's the Oracle-SQL conversion problem. Maybe stay out for now, we're getting nowhere fast and I don't think adding more people nagging for table defs is going to help.

    http://www.sqlservercentral.com/Forums/Topic915299-145-1.aspx...

    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

    May 7, 2010 at 2:47 pm

    #1164455

  • RE: Error

    b.noof (5/5/2010)

    In Oracle it's a structure

    but after i migrate from oracle to sqlserver it come a like u see it

    i do the migrate with swiss its a soft...

    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

    May 7, 2010 at 2:45 pm

    #1164453

  • RE: How to check if a database is being used?????

    JC-3113 (5/7/2010)

    Hi Leo

    can you explain how to actually do a trace on sql server 2005

    Thanks

    Jim

    Here is a document that goes through how to do that.

    http://msdn.microsoft.com/en-us/library/ms187929.aspx

    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

    May 7, 2010 at 12:01 pm

    #1164353

  • RE: Statement evaluation precedence

    Hugo Kornelis (5/7/2010)

    CirquedeSQLeil (5/7/2010)

    Paul White NZ (5/7/2010)

    CirquedeSQLeil (5/6/2010)

    Though I got this correct, it appears there is a typo in the correct answer. My version had the last two flip-flopped...

    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

    May 7, 2010 at 11:58 am

    #1164348

  • RE: SQL Server 2005 Paging – The Holy Grail

    Nice article. Thanks for sharing.

    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

    May 7, 2010 at 11:52 am

    #1164342

  • RE: SQL Server DBA.... what next?

    PaulB-TheOneAndOnly (5/7/2010)

    CirquedeSQLeil (5/7/2010)

    PaulB-TheOneAndOnly (5/7/2010)

    eric_russell 13013 (5/7/2010)

    This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone...

    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

    May 7, 2010 at 11:48 am

    #1164334

  • RE: SQL Server DBA.... what next?

    PaulB-TheOneAndOnly (5/7/2010)

    eric_russell 13013 (5/7/2010)

    This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone steps in...

    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

    May 7, 2010 at 11:39 am

    #1164328

  • RE: MCITP - Database Administrator

    At this juncture, I would certify in 2008 over 2005. The 2005 certification is becoming old. Much of the information is transferable up to 2008, and you would...

    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

    May 7, 2010 at 11:36 am

    #1164323

  • RE: SQL Server DBA.... what next?

    Jeff Moden (5/7/2010)

    CirquedeSQLeil (5/7/2010)

    eric_russell 13013 (5/7/2010)

    This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone...

    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

    May 7, 2010 at 11:29 am

    #1164318

  • RE: SQL Server DBA.... what next?

    eric_russell 13013 (5/7/2010)

    This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone steps in front...

    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

    May 7, 2010 at 11:15 am

    #1164308

  • RE: Are the posted questions getting worse?

    Gail, now that you are more active in the forums again, does this mean that you are done with school for a bit?

    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

    May 7, 2010 at 11:13 am

    #1164306

  • RE: Index usage and index cardinality

    I recommend you read that article that Gail posted. If you still have questions, come back and ask them.

    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

    May 7, 2010 at 11:13 am

    #1164305

  • RE: Today's Random Word!

    crookj (5/7/2010)

    mbricker-600840 (5/7/2010)

    Shenanigans Mike

    Mike Shenanigans? Isn't he the new coach of the Redskins? :hehe:

    Joe

    I would take him any day over Jay Cutlass.

    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

    May 7, 2010 at 11:08 am

    #1164302

  • RE: rarely used procedures in db

    A solution that I have implemented is to run a trigger that inserts the data for all running stored procedures into a log table. The trigger was a logon...

    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

    May 7, 2010 at 11:06 am

    #1164298

  • RE: How to check if a database is being used?????

    Angelindiego (5/7/2010)

    Thank you all for the ideas, I am trying them all!!!!!!!!!!

    You're welcome.

    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

    May 7, 2010 at 10:58 am

    #1164290

Viewing 15 posts - 14,131 through 14,145 (of 19,560 total)