Forum Replies Created

Viewing 15 posts - 916 through 930 (of 3,061 total)

  • RE: Question about splitting partition

    stewartc-708166 (7/12/2011)

    Regrettably one cannot do a split in the middle.

    You can only MERGE from the left and SPLIT on the right (i.e. latest).

    mmmhh... are you totallly 100% sure about this?

    I...

    July 12, 2011 at 6:14 am

    #1351512

  • RE: Performance issue and keeping old data

    oussama.dinia (7/12/2011)

    We have a database for one of our website (10 years old), for which we still keep orders.

    Our orders table has grown to 12+ million records, growing at 5000...

    July 12, 2011 at 6:05 am

    #1351510

  • RE: Time Varing Numerical Quantity

    narain337 (7/11/2011)

    Kindly give an example of a real business situation where neither a star nor a snowflake schema can be used to represent that data.

    Firstly, a snowflake "schema" is nothing...

    July 11, 2011 at 5:45 am

    #1351008

  • RE: Ref Cursors

    Bruce W Cassidy (7/8/2011)

    PaulB-TheOneAndOnly (7/8/2011)

    Correct but, a REF CURSOR is not a parameter - it's a reference to a specific memory location.

    ... the point being that it's how you pass...

    July 9, 2011 at 3:29 pm

    #1350763

  • RE: Related data within the same facts

    MR-216760 (4/23/2011)

    How do you store facts within which data is related? And how do you configure the measure? For example, I have a data warehouse that tracks the lifecycle of...

    July 8, 2011 at 1:18 pm

    #1350609

  • RE: Tables in database files - mdf, ndf

    am-244616 (7/8/2011)

    Is there anyway to locate what tables belong database files (assuming that there are multiple database files mdf and ndf). I used this query below, but it only tells...

    July 8, 2011 at 12:38 pm

    #1350579

  • RE: howto delete old Data records in the right way?

    stefan.mueller 34873 (7/8/2011)

    I have a database with around 30 gigs.

    Now i want to delete in some tables all the data which is older than 3 Years.

    If i set the Database...

    July 8, 2011 at 11:54 am

    #1350559

  • RE: importing data from Access DB to SQL server 2008

    ravi01031986 (7/8/2011)

    I need to import Access db to SQL server using SSIS packages.Could some one tell me how to do these in the best possible way.I am having like 3...

    July 8, 2011 at 11:43 am

    #1350550

  • RE: Inserting Data in the Middle of a Partition

    michael.french 172 (6/30/2011)

    I guess I need to clarify my question more.

    My plan is to load the data one partition at a time by loading a staging table and then merging...

    July 8, 2011 at 6:47 am

    #1350317

  • RE: Junk characters coming doing query from oracle server

    Bruce W Cassidy (7/6/2011)

    Also I'm not sure the degree symbol fits into the 7-bit ASCII character set:

    NLS_CHARACTERSET= US7ASCII

    That's why configuration also includes alternative "National" Character Set set to AL16UTF16...

    NLS_NCHAR_CHARACTERSET= AL16UTF16

    July 8, 2011 at 6:41 am

    #1350312

  • RE: Ref Cursors

    Bruce W Cassidy (7/6/2011)

    ssc_san (6/24/2011)

    Thanks for the reply Paul.

    Any specific reason, is it because of the difference in their architecture?

    Thanks.

    SQL Server stored procedures can return result sets directly. Oracle...

    July 8, 2011 at 6:38 am

    #1350308

  • RE: Reference sub or super type?

    keymoo (7/4/2011)

    Out of curiosity, may I ask why BondInstrument table was detached from Intrument table? blame it to my ocd but I have problems digesting 1:1 relationships 🙂

    Because...

    July 5, 2011 at 5:38 am

    #1348201

  • RE: Code Ownership - DBA vs. Developer

    Oliiii (7/4/2011)

    I guess that's another 'it depend' answer.

    In this case i depend on the size of the company.

    If you have a small company with few devs, then they can own...

    July 5, 2011 at 5:28 am

    #1348191

  • RE: Code Ownership - DBA vs. Developer

    Jeff Moden (7/3/2011)

    PaulB-TheOneAndOnly (7/3/2011)

    I think we are on the same page - just saying things in a different way.

    Onwership of the data does not equates with ability to manipulate the...

    July 4, 2011 at 7:12 am

    #1347831

  • RE: Check if a value is used in multiple foreign keys

    I assume that if a single dependency is missing you want the dependency-check to fail, is that correct?

    If that's the case I would join the ten tables by that "FK"...

    July 4, 2011 at 7:01 am

    #1347825

Viewing 15 posts - 916 through 930 (of 3,061 total)