Forum Replies Created

Viewing 15 posts - 91 through 105 (of 213 total)

  • RE: Migrating SQL Server 2005 32bit to 64bit

    If I understand the question correctly, you're asking if 64 bit and 32 bit versions of SQL server store your data any differently?  No, they don't.  The 64 bit concept...


    Student of SQL and Golf, Master of Neither

  • RE: Migrating SQL Server 2005 32bit to 64bit

    Either way works fine.  I like the Detach and Attach methods, they take almost no time, while a backup and restore obviously has to copy everything record by record.  We...


    Student of SQL and Golf, Master of Neither

  • RE: A Look at GUIDs

    Heck, I would!  Making my worst enemy type Guids all day would be awesome!

    Seriously, there is no reason for any user to ever even see a Guid, much less need...


    Student of SQL and Golf, Master of Neither

  • RE: A Look at GUIDs

    Excellent, factual article Andy.

    I started using GUIDs as Primary Keys for the very reasons mentioned in your article several years ago (SQL 7 also has NEWID as a function).  My...


    Student of SQL and Golf, Master of Neither

  • RE: Memory Management - awe /3gb /pae

    Whoops, my bad.  You are using SQL 2000, we're on 2005.  My comment probably doesn't apply.

     


    Student of SQL and Golf, Master of Neither

  • RE: Memory Management - awe /3gb /pae

    You didn't mention whether you were using the 32 bit or 64 bit version of Win2003 Server.  With the 64 bit you don't need to mess with the switches at...


    Student of SQL and Golf, Master of Neither

  • RE: Database Commenting Guideline

    The bottom line message in this article is "Comment your code if it's not absolutely clear what you are doing". 

    I like that.  It's what I do.  It's what I...


    Student of SQL and Golf, Master of Neither

  • RE: VPN Woes

    I've used identical pairs of Linksys routers several times with great success.  They are not hard to setup, they stay setup and they make it easy to map several computers...


    Student of SQL and Golf, Master of Neither

  • RE: 9 Gb Backup?

    We do this, backing up a 40 gig database across a 1 gigabit fiber link to another server.  The impact on the primary server is noticible but certainly not unacceptable. ...


    Student of SQL and Golf, Master of Neither

  • RE: Can''''t connect using Linked Server in 2005

    I'm still searching for the answer to this.  Does anyone have any experience, or even any decent guesses?


    Student of SQL and Golf, Master of Neither

  • RE: Linking to 2005 from 7

    I'm still fighting this problem.  Does anyone even have any good guesses?

     


    Student of SQL and Golf, Master of Neither

  • RE: Business Continuity for SQL Servers With a Standby Approach

    Nice ad.


    Student of SQL and Golf, Master of Neither

  • RE: Binary data pros/cons

    I'd say it's a bit more than a rumor.  From the About page at the very link you quoted:

    The current configuration is the scale-out configuration first deployed in November 2003....


    Student of SQL and Golf, Master of Neither

  • RE: Binary data pros/cons

    We've got yet another reason to use the DB storage method.  We allow hundreds of customers to trade work between themselves.  This includes attachments that move from one customer to...


    Student of SQL and Golf, Master of Neither

  • RE: Simplicity

    Query Analyzer hands down.  Show Execution Plan option specifically.  The version 7 one, 2005 still has me looking around for an old friend.


    Student of SQL and Golf, Master of Neither

Viewing 15 posts - 91 through 105 (of 213 total)