Forum Replies Created

Viewing 15 posts - 871 through 885 (of 3,061 total)

  • RE: General Question

    laddu4700 (8/1/2011)

    I am not sure whether I can ask a general question here, sorry I am posting in wrong place.

    Who will write the end-user report scripts ( business logic based)....

    August 2, 2011 at 12:34 pm

    #1362491

  • RE: database size

    yes.

    August 2, 2011 at 12:09 pm

    #1362450

  • RE: database size

    chess.chess (8/2/2011)

    Hi , what is the average size of a large database for an application like

    online banking ? i.e. how many tables and MBs of data ? Just looking...

    August 2, 2011 at 12:08 pm

    #1362447

  • RE: Never ending changes

    rootfixxxer (7/19/2011)

    Every table in my database should maintain history, and use the one table approach?

    Kind of a start date, end date, and a bit field referring to the current...

    August 2, 2011 at 12:03 pm

    #1362441

  • RE: Adding/Removing Columns

    Roger Sabin (8/2/2011)

    Let me make sure I have this.

    If I use ALTER TABLE to change the varchar size (e.g. varchar(20) to varchar(50)), SQL Server will not duplicate the table but...

    August 2, 2011 at 11:54 am

    #1362426

  • RE: hi..help with statement

    Ninja's_RGR'us (8/2/2011)

    PaulB-TheOneAndOnly (8/2/2011)

    sravnmaganti (8/2/2011)

    actually i want to know is it possible to create primary key with non_cluster index.

    Yes.

    Edit: man, you are fast

    I know, and it's about time you realized it...

    August 2, 2011 at 11:49 am

    #1362415

  • RE: hi..help with statement

    sravnmaganti (8/2/2011)

    actually i want to know is it possible to create primary key with non_cluster index.

    Yes.

    Edit: man, you are fast

    August 2, 2011 at 11:38 am

    #1362407

  • RE: Time Dimension

    b.narasimhakumar (6/21/2011)

    I have created one generated time dimension and fact table

    like fact table column start_date

    How can i join fact table with time dimension.

    I assume you mean date dimension table.

    In...

    August 2, 2011 at 10:21 am

    #1362320

  • RE: Compare dates

    -Syd- (8/2/2011)

    Thank you. So if there any way to compare which the nearest date on a table?

    But it cant be order DESC by date place a TOP 1 on the...

    August 2, 2011 at 10:10 am

    #1362310

  • RE: Compare dates

    -Syd- (8/2/2011)

    I have some data, with differents date.

    Without making a subquery, is there a function on 2008r2 to compare which is the nearest date on the table to today?

    No silver...

    August 2, 2011 at 9:58 am

    #1362294

  • RE: Calling an Oracle function from SQL Server

    SJanki (8/2/2011)

    Hi Paul,

    I tried this

    declare @InputPara varchar(100)

    set @InputPara='Hello'

    declare @OutputPara bigint

    EXECUTE ( 'BEGIN ? := packagename.functionname(?,?); END;', @InputPara, @OutputPara OUTPUT )at linkedservername;

    Its giving me this error

    Msg 7215, Level 17, State...

    August 2, 2011 at 9:53 am

    #1362289

  • RE: Sychronizing a live database to 3 sites: Possible? Worthwhile?

    denver.drake (8/2/2011)

    Good questions. Since this is a "we're thinking about it" situation, I have no idea what the actual size of the database will be, or anything about the Tlog....

    August 2, 2011 at 8:31 am

    #1362209

  • RE: Sychronizing a live database to 3 sites: Possible? Worthwhile?

    denver.drake (8/2/2011)

    I got this question from my company today, I'm not sure how to answer. We have 3 sites in North America with good bandwidth on our WAN. Anybody...

    August 2, 2011 at 7:59 am

    #1362168

  • RE: Adding/Removing Columns

    Roger Sabin (8/2/2011)

    We have a production table that contains a large amount of data (100's of GB's). We need to add some new columns to it, remove some columns from...

    August 2, 2011 at 7:36 am

    #1362148

  • RE: ReIndexing Questions

    PhilipC (8/2/2011)

    I appreciate ReIndexing has been done to death, but I'm just wondering a few things.

    I see most people suggest using a custom script to run re-indexing across their databases...

    August 2, 2011 at 6:44 am

    #1362105

Viewing 15 posts - 871 through 885 (of 3,061 total)