Forum Replies Created

Viewing 15 posts - 2,896 through 2,910 (of 19,560 total)

  • RE: SQL LOG SIZE FULL ISSUE

    GilaMonster (6/5/2014)

    rajesh.mekala (6/4/2014)

    please tel me yaar how to reslove this issue permently please give explain brefily

    Call Microsoft Support, open a case.

    Alternatively, if you want free help maybe give...

    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

    June 5, 2014 at 7:28 am

    #1719214

  • RE: Fastest way to convert strings 'TRUE' and 'FALSE' to bit-values 1 and

    EZ PZ lemon SQEEZEE

    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

    June 4, 2014 at 10:19 pm

    #1719076

  • RE: SQL LOG SIZE FULL ISSUE

    rajesh.mekala (6/4/2014)

    please tel me yaar how to reslove this issue permently please give explain brefily

    We can't tell you how to fix it because we don't have near enough information.

    You...

    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

    June 4, 2014 at 9:56 pm

    #1719075

  • RE: SQL LOG SIZE FULL ISSUE

    rajesh.mekala (6/4/2014)

    Thank you your support i am using sqlserver 2008R2 with sp1 and regular basisc i have creted fullbackup and differetailbackup and dont have clr in server..please help me

    Back 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

    June 4, 2014 at 9:50 pm

    #1719072

  • RE: SQL LOG SIZE FULL ISSUE

    So the full backups and the differential backups are running at the same times that the mini-dumps are created?

    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

    June 4, 2014 at 9:45 pm

    #1719070

  • RE: Restore databases from a directory of backup files

    Here is a script to help automate your database restores.

    I use it at several clients to restore anywhere from 1 to 50 databases on regular intervals.

    http://jasonbrimhall.info/2014/01/14/t-sql-tuesday-050-automating-database-restores/

    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

    June 4, 2014 at 9:44 pm

    #1719069

  • RE: Disable logins automaticallu depending upon expiry date in a table

    And just to build on the answer provided so far, throw that command into an agent job that runs on a regular schedule.

    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

    June 4, 2014 at 9:39 pm

    #1719067

  • RE: SQL LOG SIZE FULL ISSUE

    Mini dumps can be created for a number of reasons.

    What is the patch level of your server?

    Do you have CLR enabled?

    Do you have certain jobs that run on a regular...

    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

    June 4, 2014 at 9:38 pm

    #1719066

  • RE: Is it good to enable database compression at server instance?

    If / when you upgrade to SQL 2014, you can do encrypted compressed backups. It is a little different than TDE and is a good thing. Keep 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

    June 4, 2014 at 1:18 pm

    #1718978

  • RE: report server version is older than data source server

    The reports should continue to work. You will need to test the reports as with any upgrade though.

    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

    June 4, 2014 at 12:33 pm

    #1718967

  • RE: Is it good to enable database compression at server instance?

    sqlfriends (6/3/2014)

    Thanks I just wonder if it is good to setup compression at server level or in the indivual backup like maintenance plan or T-SQL backup?

    I generally enable compression at...

    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

    June 4, 2014 at 12:32 pm

    #1718965

  • RE: Today's Random Word!

    crookj (6/4/2014)

    Sean Lange (6/4/2014)

    SQLRNNR (6/4/2014)

    Sean Lange (6/4/2014)

    crookj (6/4/2014)

    whereisSQL? (6/4/2014)

    Sean Lange (6/4/2014)

    SQLRNNR (6/4/2014)

    Ed Wagner (6/3/2014)

    jasona.work (6/3/2014)

    Ed Wagner (6/3/2014)

    Sean Lange (6/3/2014)

    crookj (6/3/2014)

    jasona.work (6/3/2014)

    JAZZ Master (6/3/2014)

    SQLRNNR (6/3/2014)

    mutant

    turtle

    Ninja

    Warrior

    Sensei

    Master

    Shredder

    Shred Dude

    Pizza

    Hungry

    Cake

    Blizzard

    WoW

    Starcraft (100x better than WoW)

    Haven't played...

    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

    June 4, 2014 at 12:25 pm

    #1718959

  • RE: Today's Random Word!

    Sean Lange (6/4/2014)

    crookj (6/4/2014)

    whereisSQL? (6/4/2014)

    Sean Lange (6/4/2014)

    SQLRNNR (6/4/2014)

    Ed Wagner (6/3/2014)

    jasona.work (6/3/2014)

    Ed Wagner (6/3/2014)

    Sean Lange (6/3/2014)

    crookj (6/3/2014)

    jasona.work (6/3/2014)

    JAZZ Master (6/3/2014)

    SQLRNNR (6/3/2014)

    mutant

    turtle

    Ninja

    Warrior

    Sensei

    Master

    Shredder

    Shred Dude

    Pizza

    Hungry

    Cake

    Blizzard

    WoW

    Starcraft (100x better than WoW)

    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

    June 4, 2014 at 12:11 pm

    #1718950

  • RE: Using Dual Monitors vs Single Large Monitor

    LightVader (6/4/2014)

    SQLRNNR (6/4/2014)

    How about 1 big monitor and 1 projector?

    Then it is like having 2 monitors but you really only (technically) have 1.

    I hooked up my old SNES to a...

    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

    June 4, 2014 at 12:05 pm

    #1718943

  • RE: What is best practice to assign job owner?

    Jack Corbett (6/4/2014)

    There are several views on this. I believe you can have the sa account disabled and still have it own jobs.

    My recommendation is to either...

    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

    June 4, 2014 at 12:00 pm

    #1718939

Viewing 15 posts - 2,896 through 2,910 (of 19,560 total)