Forum Replies Created

Viewing 15 posts - 8,986 through 9,000 (of 49,552 total)

  • RE: SQL exam question

    I suggest you go and have a chat with the lecturer/teacher and get the material that you missed and work through it. Neither of those is at all correct. Topics...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 21, 2014 at 4:28 am

    #1715273

  • RE: SQL Profiler - Server side Trace

    Since you've given me nothing to go on (no trace script, no details of where/when/how the trace gets started), good luck figuring it out. A trace doesn't survive SQL restarting,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 21, 2014 at 4:13 am

    #1715268

  • RE: SQL Profiler - Server side Trace

    A trace is a trace, doesn't matter whether it's called from a proc or an agent job or ad-hoc code.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 21, 2014 at 4:00 am

    #1715264

  • RE: SQL exam question

    What do you have so far?

    p.s. this isn't a SQL certification exam question, is it?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 21, 2014 at 3:57 am

    #1715262

  • RE: SQL Profiler - Server side Trace

    Ok, so let's start with the code that you're running, or are you expecting someone to write a whole profile trace script for you without any idea what your existing...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 21, 2014 at 2:26 am

    #1715242

  • RE: SQL Profiler - Server side Trace

    Not hard. Let's start with the code you already have for the trace.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 21, 2014 at 2:18 am

    #1715240

  • RE: Question about transaction log.

    enriarg (5/20/2014)

    I was reading about delay transaction log, durability, truncate and all that, someone on one of the documents mention that a service shutdown doesn't really commit the dirty pages,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 21, 2014 at 2:09 am

    #1715239

  • RE: 1=1

    Gordon Barclay (5/20/2014)

    Erikur - I disagree that it simplifies the script, what is wrong with the following that needs simplifying?

    You missed "when dynamically creating the where clause"

    Personally, I hate...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 20, 2014 at 12:09 pm

    #1715075

  • RE: Re-order views' fields' name

    adonetok (5/20/2014)

    For about 300 fields view, how to code to re-order fields' name?

    ALTER VIEW ... then start typing. Don't forget to test all the applications and fix the myriad of...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 20, 2014 at 10:22 am

    #1715038

  • RE: Does a restored DB bring its virtual file stats with it?

    Yes, because the restore doesn't use the same methods as normal queries do when they're reading/writing. Restore doesn't write much at all to the tran log.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 20, 2014 at 7:55 am

    #1714945

  • RE: Are the posted questions getting worse?

    I'm just going to leave this here...

    http://www.sqlservercentral.com/Forums/Topic1572621-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 20, 2014 at 7:50 am

    #1714940

  • RE: urgent_Backup_needed

    Per hour?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 20, 2014 at 7:43 am

    #1714935

  • RE: Change Recovery Model of a Replicated Database

    Replication does not prevent a change in recovery model.

    ALTER DATABASE <database name> SET RECOVERY FULL

    If it throws an error, please post the exact error message.

    Curious, why are you setting the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 20, 2014 at 7:10 am

    #1714918

  • RE: Database IN RECOVERY

    If the database state is RECOVERING, then it is running the recovery process and will come online at the end of that. Probably there's a large transaction that needs to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 20, 2014 at 7:02 am

    #1714912

  • RE: urgent_Backup_needed

    You want to pay someone be available for you to ask assistance of and to do parts of your job that you can't?

    Out of shear curiosity, what amount are you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 20, 2014 at 6:58 am

    #1714910

Viewing 15 posts - 8,986 through 9,000 (of 49,552 total)