Forum Replies Created

Viewing 15 posts - 5,536 through 5,550 (of 19,560 total)

  • RE: Should I become a DBA?!?

    Fal (10/24/2012)

    bugg (10/18/2012)

    SQLRNNR (10/18/2012)

    I've done the 24x7 oncall on my own. Even if they promise you the vacation and that so and so can cover that week - don't...

    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

    October 25, 2012 at 9:22 pm

    #1553015

  • RE: SELECT (Transact-SQL)

    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

    October 25, 2012 at 9:16 pm

    #1553014

  • RE: Five percent rounded down

    Interesting 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

    October 25, 2012 at 9:14 pm

    #1553013

  • RE: PARSENAME

    Thanks Ron.

    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

    October 25, 2012 at 9:13 pm

    #1553012

  • RE: Today's Random Word!

    LAB

    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

    October 25, 2012 at 8:40 pm

    #1553005

  • RE: Process not releasing tempdb space

    sqldba_newbie (10/23/2012)

    SQLRNNR (10/22/2012)

    sqldba_newbie (10/22/2012)

    Vegard Hagen (10/22/2012)

    Most likely you've come across a piece of bad application code that doesn't clean up after itself.

    All temporary objects created in tempdb must be dropped...

    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

    October 23, 2012 at 8:24 pm

    #1552121

  • RE: Need to help to Restore/attach a database in SQL 6.5

    Here is a tool that others have had work

    http://www.officerecovery.com/mssql/

    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

    October 23, 2012 at 9:35 am

    #1551984

  • RE: Duplicate Foreign Key

    vk-kirov (10/23/2012)

    call.copse (10/23/2012)

    I liked this question, as I wondered whether anyone would try running the sample code, and what would happen if they did (and I got it right comfortably!)....

    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

    October 23, 2012 at 9:17 am

    #1551974

  • RE: Question re: service pack upgrade installation when encryption enabled for dbs

    Perry Whittle (10/22/2012)

    You just need to ensure that you have backups of all certificates (public and private keys) and backups of all the databases too. It might also pay 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

    October 22, 2012 at 10:41 pm

    #1551715

  • RE: Process not releasing tempdb space

    sqldba_newbie (10/22/2012)

    Vegard Hagen (10/22/2012)

    Most likely you've come across a piece of bad application code that doesn't clean up after itself.

    All temporary objects created in tempdb must be dropped when you're...

    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

    October 22, 2012 at 10:32 pm

    #1551713

  • RE: Should I become a DBA?!?

    Jeff Moden (10/22/2012)

    bugg (10/18/2012)

    Okay, you guys are starting to scare the sh*te out of me . Why are you DBA's willing to sacrifice so much of your "free" time,...

    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

    October 22, 2012 at 10:27 pm

    #1551711

  • RE: Changing Identity Columns

    Koen Verbeeck (10/22/2012)

    Lokesh Vij (10/22/2012)

    kapil_kk (10/22/2012)

    in this case the max ident value would be 101 as with first insert statement the value of ident was 100 and with another insert...

    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

    October 22, 2012 at 10:06 pm

    #1551709

  • RE: Table Variables

    Suds. one stinking mis-click though I intended to click permit identity I slipped and hit the wrong check box.

    Grrrrr...:-)

    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

    October 22, 2012 at 11:26 am

    #1551553

  • RE: Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

    Nice Job Ben.

    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

    October 22, 2012 at 11:09 am

    #1551545

  • RE: Are the posted questions getting worse?

    Sean Lange (10/19/2012)

    Is it just me or is the entire SSC site slow today? For me I can barely navigate anywhere. Each click is taking a couple minutes. No other...

    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

    October 19, 2012 at 11:13 am

    #1550978

Viewing 15 posts - 5,536 through 5,550 (of 19,560 total)