Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 3,061 total)

  • RE: De-normalize or index?

    harendra.singh (12/18/2010)

    create proper indexes on the columns which are included in where condition. Also place proper joins by normalizing tables

    well... this one can be translated as: "do it right, dont'...

    December 18, 2010 at 11:42 am

    #1264383

  • RE: Simple Design Analysis Question before designing dimensions and facts

    johnacandy (12/14/2010)

    Suppose that i have the following staging table with the following columns...

    As a side note I'll say you should never start with the Staging table but with the actual...

    December 18, 2010 at 9:03 am

    #1264373

  • RE: De-normalize or index?

    pdanes2 (12/9/2010)

    De-normalize or index?

    Question could be translated like "be healthy or take a fast speed train?" meaning, those options should never be part of the same question.

    Normalization/De-Normalization is related to...

    December 18, 2010 at 8:50 am

    #1264368

  • RE: LOB_DATA doesn't get deallocated

    jln (12/15/2010)

    I think I actually saw this some time back but disconsidered it as it was reported fixed.

    So I basically need to go talk to SQL server support at...

    December 15, 2010 at 9:14 am

    #1262953

  • RE: LOB_DATA doesn't get deallocated

    jln (12/15/2010)

    According to our supplier the application needs the snapshot isolation in order to avoid some locking issues.

    Where can i find information on the bug you mention, are there any...

    December 15, 2010 at 8:56 am

    #1262937

  • RE: How to read data from mysql to mssql server

    Lowell (12/15/2010)

    ...Once you have the Linked Server in place I have found a few different ways of interacting with the mysql database

    I understand poster is looking for the other way...

    December 15, 2010 at 7:56 am

    #1262861

  • RE: LOB_DATA doesn't get deallocated

    Described behavior appears to be closely related to bug #50002862

    Do you really need snapshot isolation or was it just a test?

    December 15, 2010 at 7:49 am

    #1262854

  • RE: How to read data from mysql to mssql server

    naresh.talla (12/14/2010)

    i have created one linkedserver on sql server 2005 and i am reading data from mssql server to mysql through linked server....

    my question is how i can read data...

    December 15, 2010 at 7:42 am

    #1262850

  • RE: What could cause Network I/O waits high?

    DBA in Unit 7 (12/15/2010)

    Yes, you are right. I am looking at a 'performance' problem. The application side was complaining that it is slow to pull out of data from...

    December 15, 2010 at 7:04 am

    #1262821

  • RE: Can you use one Dimension table for 2 fact tables

    456789psw (12/13/2010)

    its seems like the conformed dimensions. is much simpler on the developer, but no much on the end user? I am thinking more on the lines of accounting or...

    December 14, 2010 at 5:49 am

    #1262135

  • RE: Dev/Test/Prod Scenario

    Steve Jones - SSC Editor (12/10/2010)Developers SHOULD NOT be able to change objects (tables, stored procedures, etc.) on production.

    Agreed and, SHOULD NOT be able to change/create/drop objects in Test either...

    December 14, 2010 at 5:45 am

    #1262133

  • RE: schema model diagram

    MonsterRocks (12/14/2010)

    in sql 2k5, i have a database.. i want to take its schema diagram.. is there any tool available for it?.. any suggestion pls

    SQL Server Management Studio/

    Databases/

    target_database/

    Database Diagrams/

    New

    🙂

    December 14, 2010 at 5:38 am

    #1262131

  • RE: Design Question - Company, Clients, Branches, Departments

    netpicker9 (12/8/2010)

    Can any one please let me know how design tables below,

    1. Company

    2. Client

    3. Branch

    4. Departments

    Points:

    a. Some companies do not have any branches and just departments

    b. If company happen have...

    December 10, 2010 at 8:43 am

    #1261079

  • RE: Partitioning Large MS SQL-Server FACT table

    rajesh999 (12/6/2010)

    Scenario:

    •Data should be retained for 5 years or 60 months.

    •Table will have about 800 million records

    •Have adapted monthly partition.

    •Each File group have 8 files to match the Number of...

    December 10, 2010 at 8:36 am

    #1261072

  • RE: looking for an application that will monitor and alert on lack of data received by querying SQL DB ?

    Building on torpkev's comment, this is too specific for a third party application - this is something you have to do by yourself.

    By the way, no need to bother developers...

    December 10, 2010 at 8:29 am

    #1261069

Viewing 15 posts - 1,276 through 1,290 (of 3,061 total)