Forum Replies Created

Viewing 15 posts - 30,361 through 30,375 (of 49,552 total)

  • RE: SQL Server 2005 32 Bit Version on Windows Server 2008 R2 x64

    You can. I don't know why you'd want to, but you can run x86 apps on an x64 server.

    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

    September 24, 2010 at 10:49 am

    #1227124

  • RE: SQL 2005 SP3 crashes :(

    Grant the SQL service account 'Lock pages in memory' and make sure that you have max memory configured properly. With 72GB of memory in the server, gut feel is around...

    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

    September 24, 2010 at 10:45 am

    #1227123

  • RE: Moving Database Files Detach/Attach or ALTER DATABASE?

    Nils Gustav Stråbø (9/24/2010)

    So if you delete the transaction log file and the database was not shut down properly there is no chance in h*** you can attach the database...

    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

    September 24, 2010 at 10:39 am

    #1227116

  • RE: Simple Question from a complete newbie

    The SQL language used by MS Access and MS SQL Server is similar, but not the same. Hence, if you're not using SQL Server itself, please tell us what 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

    September 24, 2010 at 9:55 am

    #1227096

  • RE: Transaction Log file size grows exponentially after maintenance Job ?

    YeePee (9/24/2010)

    That is interesting , so Index Rebuild which drops the existing Index and Recreates the index is not logged?

    Sure it is. All data modifications are logged, no exceptions.

    Index...

    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

    September 24, 2010 at 9:51 am

    #1227092

  • RE: Simple Question from a complete newbie

    That doesn't even sound like a SQL Server error. SQL's would be something like

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near 'CREATE'.

    Are you using Microsoft SQL Server here?...

    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

    September 24, 2010 at 9:42 am

    #1227085

  • RE: Transaction Log file size grows exponentially after maintenance Job ?

    Index reorganise is a fully logged operation (in all recovery models). It will grow the transaction log and result in a large log backup, especially if the indexes are very...

    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

    September 24, 2010 at 9:36 am

    #1227082

  • RE: Restoration size

    Restoring one database over another is equivalent to first dropping the existing database, then restoring the backup.

    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

    September 24, 2010 at 8:39 am

    #1227026

  • RE: Are the posted questions getting worse?

    HowardW (9/24/2010)

    I think Gail "wins" with JHB - I've got some friends who work for Visa out there and it's the only place I've visited where a "normal" family in...

    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

    September 24, 2010 at 8:29 am

    #1227015

  • RE: Trying to optimize performance of query having Hash Matches & Agreegate

    Grant Fritchey (9/24/2010)

    Based on the info in the spread sheet, it looks like you have out of date statistics. You've got missing stats warnings.

    Or maybe auto_create_stats turned off?

    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

    September 24, 2010 at 8:21 am

    #1227006

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (9/24/2010)

    Just the necessities are kept alive then 😀

    Precisely.

    I work from home a lot, and 3+ hour powercuts really hurt in that case.

    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

    September 24, 2010 at 5:36 am

    #1226863

  • RE: Are the posted questions getting worse?

    btw, am uploading couple more cat photos and photos from recent weekend trip if anyone's interested.

    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

    September 24, 2010 at 5:31 am

    #1226860

  • RE: Are the posted questions getting worse?

    ALZDBA (9/24/2010)

    I like picture 3 : Finaly computer romance :hehe:

    Unfortunately not. 😉

    That was also during a power failure. I have 2 UPSs for the computer, TV, xbox and ADSL modem,...

    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

    September 24, 2010 at 5:18 am

    #1226849

  • RE: Are the posted questions getting worse?

    Here's a photo taken in daylight.

    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

    September 24, 2010 at 5:17 am

    #1226848

  • RE: Need to find schema difference between two databases

    Bagath (9/24/2010)

    Please give me the sample script if any one worked/have on the criteria like above.

    I use SQLCompare when I'm doing work like that. Search the script library here, 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

    September 24, 2010 at 5:07 am

    #1226842

Viewing 15 posts - 30,361 through 30,375 (of 49,552 total)