Forum Replies Created

Viewing 15 posts - 20,596 through 20,610 (of 49,552 total)

  • RE: how??

    Have you tried failing over the mirroring so that the DB you want to change is the principal and seeing if you can change it there?

    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

    February 4, 2012 at 9:47 am

    #1442760

  • RE: how to make content management system for a website

    Buy one.

    Seriously, it's not something that you'll do in a week or two.

    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

    February 4, 2012 at 9:44 am

    #1442758

  • RE: rebuilding indexes

    Don't reinvent the wheel...

    http://sqlfool.com/2011/06/index-defrag-script-v4-1/

    or

    http://ola.hallengren.com/Versions.html

    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

    February 4, 2012 at 9:41 am

    #1442757

  • RE: alternative to table variable and temp tables

    Also asked here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=170990

    Also, exactly what is your problem here? Does the query not work? Is the performance unacceptable?

    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

    February 4, 2012 at 9:39 am

    #1442756

  • RE: huge transaction log file

    Please read through this - Managing Transaction Logs[/url] and http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    February 4, 2012 at 9:38 am

    #1442755

  • RE: 3GB PAE in windows 2008 32 bit?

    The 1GB is the kernal's VAS allocation, not the free memory used by other apps.

    If you need more free memory for other apps, lower SQL's max server memory.

    Chapter 4 -...

    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

    February 4, 2012 at 12:42 am

    #1442724

  • RE: Incremental Back up

    Rajeev Ramachandran (2/3/2012)

    I think Differential backups are called as incremental backups.

    Differential and incremental are very different things.

    Differential is what we have in SQL, where all differential backups depend on 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

    February 4, 2012 at 12:24 am

    #1442721

  • RE: Are the posted questions getting worse?

    Summer, glorious summer (and lots of rain)

    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

    February 3, 2012 at 12:04 pm

    #1442587

  • RE: Solution to complex query

    Here you go: how to post DDL and sample data http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    February 3, 2012 at 10:31 am

    #1442538

  • RE: [LOG] Block procedure or delete to record at log file?

    dbapleno (2/3/2012)

    Thanks all,

    I had used that function before, but the problem is that I want to execute the procedure (delete) and delete that info at the log (about xxxGB)....

    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

    February 3, 2012 at 10:28 am

    #1442536

  • RE: reduce the size of transaction log

    Now that is a massively different question.

    Start with this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    Also, you probably want to work on optimising the queries that use lots of TempDB space, look into removing unnecessary temp...

    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

    February 3, 2012 at 8:54 am

    #1442478

  • RE: reduce the size of transaction log

    mw112009 (2/3/2012)

    So when we run a stored proc, we get error messages saying the "Transaction Log is full"

    So there has to be a way to reduce the size of this...

    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

    February 3, 2012 at 8:36 am

    #1442465

  • RE: High disk queue length

    Please note, the original post is almost 3 years old and the OP has not logged in for over a year.

    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

    February 3, 2012 at 8:17 am

    #1442452

  • RE: Are the posted questions getting worse?

    Thanks, more than enough editors now.

    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

    February 3, 2012 at 6:49 am

    #1442391

  • RE: Terms in plain English .... please

    raotor (2/3/2012)

    Am I correct in thinking that using schemas can be useful because you can grant users access at the schema level and thus you could deny users access 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

    February 3, 2012 at 6:13 am

    #1442367

Viewing 15 posts - 20,596 through 20,610 (of 49,552 total)