Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 3,061 total)

  • RE: Fact table design issue- Please advise!

    Pac123 (11/5/2010)

    Thats right..Table B is at a more granular level than table #A. [one record for every week in the date range between start and enddates].

    Here is the root cause...

    November 5, 2010 at 4:47 pm

    #1247371

  • RE: ERD Help

    Please take a second look at SoldItems.DateSold, I think this is redundant to Sales.SaleDate. If both pieces of information describe the same attribute which is the date/time of the...

    November 5, 2010 at 3:24 pm

    #1247359

  • RE: Need advice on database integration

    Little Nick (11/5/2010)

    1. Current solutions architecture on integration, looks bad

    2. This is because, if there's no data is push from ERP into IntegratedDB, that special program still running. At this...

    November 5, 2010 at 3:15 pm

    #1247354

  • RE: What's the definitive book on SQL Server DB design?

    info-849042 (11/4/2010)

    What is the definitive book on database design best practises? E.g. covering things like recommended max number of columns in a table (if any recommended max), when to use...

    November 4, 2010 at 7:04 pm

    #1246949

  • RE: Reporting Strategy - Looking for suggestions/comments

    btodd 61953 (11/2/2010)

    I'm learning a lot and thankfully I have a TEST system to work with. The problem is that it is taking me a long time to accomplish...

    November 4, 2010 at 7:45 am

    #1246536

  • RE: table without UPDATA and DELETE

    xbarf (11/4/2010)

    My DB has only one table. This table has only two columns (X & Y) but many many records.

    The only operations on this table are: INSERT and SELECT.

    I mean,...

    November 4, 2010 at 7:39 am

    #1246532

  • RE: SQL clustering vs. virtualization

    parissa_bakhshi (11/4/2010)

    I don't know much about virtualization. Somebody just told me tha it can take use of other servere which are in your virtual environment.

    Yes and No. 😀 ...

    November 4, 2010 at 7:04 am

    #1246504

  • RE: Apress ebook of the day

    RichardDouglas (11/3/2010)

    I promise this isn't spam and I have no connection with Apress

    Okay Rich, I'll trust you but... if you keep notifying us about such new releases it will be...

    November 3, 2010 at 6:45 am

    #1245951

  • RE: SQL clustering vs. virtualization

    parissa_bakhshi (11/2/2010)

    I have a problem choosing between clustering and virtualization solutions.

    We have an SQL server instance which have some large databases in it. Most of serer resources consumes for this...

    November 3, 2010 at 6:34 am

    #1245946

  • RE: SQL to Oracle & ViceVersa

    DNA_DBA (11/1/2010)

    There's a document here that shows how the two databases compare from a DBA point of view:

    http://download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/SQLServer2008forOracle.docx

    Not your fault but target document is not as good as it may...

    November 2, 2010 at 8:38 pm

    #1245831

  • RE: Sr level interview questions

    sasi.tripuraneni (10/26/2010)

    Can any one please post Sr level interview questions, its very urgent!

    Don't put in your resume anything that can be used against you or better rephrasing it: don't lie...

    October 29, 2010 at 2:41 pm

    #1244432

  • RE: Date Dimension Hierarchy Question

    RainbowFfolly (10/29/2010)

    No I hadn't even thought of it. I think I may have been unwittingly brainwashed by Kimball into believing that if Ralph hates snowflakes then so should I...

    October 29, 2010 at 2:21 pm

    #1244420

  • RE: Date Dimension Hierarchy Question

    RainbowFfolly (10/28/2010)

    I've a question about date dimensions related to constructing hierarchies for events that may span more than one year.

    I'd like to include religious holidays in my date dimension as...

    October 29, 2010 at 7:50 am

    #1244196

  • RE: Normalization vs Denormalization

    rootfixxxer (10/28/2010)

    How do i quote some one?!

    @GilaMonster

    Should it? Always? In every case? Why?

    I have little knowledge about developing dw's, but the little thing that i know for example in a...

    October 29, 2010 at 7:35 am

    #1244179

  • RE: Oracle to SQL replicaton - entire DB or one table

    Michal222 (10/29/2010)

    Does anyone have experience about replication between Oracle 10gR2 database to SQL server 2008 database, if so could you please share it with us about the tool or method...

    October 29, 2010 at 7:23 am

    #1244161

Viewing 15 posts - 1,351 through 1,365 (of 3,061 total)