Forum Replies Created

Viewing 15 posts - 2,941 through 2,955 (of 3,061 total)

  • RE: resource database - move or not?

    mssqlsystemresource gets replaced each time you apply a Service Pack, problem is Service Pack "thinks" mssqlsystemresource is located in the same place Master database is so... if you move mssqlsystemresource.mdf...

  • RE: Adding Files to a Database

    joyce.staszewski (9/12/2008)


    Would it be better to add files to the existing Primary group and then rebuild the indexes to balance the data across the files?

    If you are planning in having...

  • RE: sqlserver connection over WLAN

    It looks like you have a DNS issue, name resolution.

    Can you ping the server from the station using DNS name?

  • RE: Data Warehousing?

    Glen (9/11/2008)


    Does it mean that what you are saying should be translated to: "When I am designing a data warehouse, I am not basing my architecture and design of a...

  • RE: Data Warehousing?

    Glen (9/11/2008)


    I totally disagree.

    Business requirements specify where you have to go, no how to go there.

    In ideal world? Yep. In reality? ...

    After all: the design of the DWH will...

  • RE: Data Warehousing?

    Glen (9/11/2008)


    Design of a DWH using relational model or cubes should be defined by client's requirements

    I totally disagree.

    Business requirements specify where you have to go, no how to go there.

  • RE: Network admin turned DBA

    1- You can start with Books Online, chapter 1.

    2- Think twice before doing anything then, when you are totally sure step back and think about it one more time.

    3- Always...

  • RE: Licensing Question

    Shark Energy (9/11/2008)


    ... a web app with hundreds of users you would be better off with the processor license.

    Yes.

    You can also research Microsoft ISP licensing.

  • RE: Data Warehousing?

    :w00t: You are only mentioning Kimball... that's blatant discrimination!!!

    If you mention Kimball you are required by law to mention Inmon... -or was it Inmoff? 😀

  • RE: Data Warehousing?

    Alvin Ramard (9/10/2008)


    Point a webcam at the abacus and you can have mirroring; or would that be replication?

    mmhhh... neither one, if you loose your primary-abacus-site you would have nothing at...

  • RE: Are there equivalents in Oracle Sql ?

    Welcome to the Oracle world.

    PL/SQL and Transact-SQL are totally different languages like French and Occitan are meaning, do not expect to be fuent in one of them just because you...

  • RE: Data Warehousing?

    Alvin Ramard (9/10/2008)


    Backup of the abacus would be easy. Just take a picture and store it in a safe place.;)

    That would be good for DR... you can send the...

  • RE: Data Warehousing?

    Michael Earl (9/10/2008)


    Assuming the table has a date field indicating when each row was added and rows cannot be deleted, it meets Inmon's definition just fine.

    In both definitions, the final...

  • RE: Two databases with the same physical file names and locations

    Sandra Skaar (9/9/2008)I have two databases, let's call them DB1_Production and DB1_Test. Both of these databases have the SAME physical file names AND the files are in the same location

    Prove...

  • RE: Oracle database

    Nicely done. Congrats!

Viewing 15 posts - 2,941 through 2,955 (of 3,061 total)