Forum Replies Created

Viewing 15 posts - 12,736 through 12,750 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    My title is DB Architect but what they really needed was somebody to do db dev, db admin, and db architect.

    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 27, 2010 at 9:11 am

    #1213021

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/27/2010)

    One thing I've noticed as a consultant is that non-IT hiring managers and most consulting agencies have no idea what a DBA is. If they want someone 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

    August 27, 2010 at 9:08 am

    #1213017

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (8/27/2010)

    AFAIR, Incrementals haven't been a part of SQL Server. Perhaps in v4.2, can't remember that far, but I think it was always diff in SQL, incremental...

    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 27, 2010 at 8:59 am

    #1213009

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/27/2010)

    Odd. I remember studying incremental backups when I took my SQL 2000 cert test. Maybe 2000 got rid of it and SQL 7 had it, but there were...

    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 27, 2010 at 8:52 am

    #1213002

  • RE: Stored Proc: Fast in SSMS, Slow in ASP.Net

    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

    August 27, 2010 at 8:50 am

    #1213000

  • RE: There is no space in the server

    LDK (8/26/2010)

    You say you are using SQL2008 EE (express edition)?

    SQL2005EE had data file size restrictions of 4Gb I think? Once your EE DB grew to 4Gb+ it would start giving...

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

    #1212715

  • RE: Restore DTS to a different instance or server

    You are 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

    August 26, 2010 at 8:02 pm

    #1212686

  • RE: Import Stored Procedure Scripts

    Three methods come to mind:

    1. Redgate SQL Compare allows you to compare the database against scripts and sync the changes

    2. Source Control. Deploy your sql files through...

    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 26, 2010 at 8:02 pm

    #1212685

  • RE: How to know what are the most used store procedures and functions in a Data Base

    To the question of finding which procedures or functions are most commonly used:

    Some will go to the length of altering all procs and adding a piece of code that inserts...

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

    #1212677

  • RE: Are the posted questions getting worse?

    GilaMonster (8/26/2010)

    CirquedeSQLeil (8/26/2010)

    716 (caffeine)

    Using a lot of that one tonight. Wait, it's morning already.

    Already worked the 24 hour day and then breezed through the 12 hour night. That is...

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

    #1212673

  • RE: There is no space in the server

    Hypothetical or reality?

    I would go with restarting services - but first I would make sure tlogs are backed up and the log files are a decent size.

    Next I would ensure...

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

    #1212670

  • RE: Are the posted questions getting worse?

    WayneS (8/26/2010)

    CirquedeSQLeil (8/26/2010)

    Alvin Ramard (8/26/2010)

    CirquedeSQLeil (8/26/2010)

    Well, we can see that Wayne has come into some more free time 😉

    I wonder which DBCC TimeWarp parameter value(s) he's using.

    716 (caffeine)

    1892 (morphine)

    346 (HGH)

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

    #1212668

  • RE: SSRS In a Flash - The Basics

    Nice article and thanks for sharing it with us.

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

    #1212663

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/26/2010)

    CirquedeSQLeil (8/26/2010)

    Well, we can see that Wayne has come into some more free time 😉

    I wonder which DBCC TimeWarp parameter value(s) he's using.

    716 (caffeine)

    1892 (morphine)

    346 (HGH)

    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 26, 2010 at 5:49 pm

    #1212656

  • RE: Are the posted questions getting worse?

    Well, we can see that Wayne has come into some more 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

    August 26, 2010 at 5:42 pm

    #1212649

Viewing 15 posts - 12,736 through 12,750 (of 19,560 total)