Forum Replies Created

Viewing 15 posts - 511 through 525 (of 3,061 total)

  • RE: Database copy for reporting

    5 Gig database?

    Nighly?

    The answer is: Full Backup and Restore.

    February 6, 2012 at 6:58 am

    #1443095

  • RE: LINK SERVER ERROR FROM SQL TO ORACLE using ODAC component

    gajananhatkar (2/1/2012)

    OLE DB provider "OraOLEDB.Oracle" for linked server "ORAFINNONE" returned message "New transaction cannot enlist in the specified transaction coordinator. ".

    Msg 7391, Level 16, State 2, Line 1

    The operation could...

    February 6, 2012 at 6:47 am

    #1443088

  • RE: I have a question about oracle

    fastformation01 (2/6/2012)

    Which one is faster delete/truncate? Why?

    Assuming you are talking about deleting the whole population of a table it doesn't matter if it's Oracle, SQL Server, DB2 or whatever other...

    February 6, 2012 at 6:44 am

    #1443085

  • RE: stored procedure header

    gugan_ta (2/3/2012)

    We have 60 stored procedures without headers. now we need to include below details in all sp. Is there any workaround to include below details in all sp to...

    February 3, 2012 at 1:51 pm

    #1442637

  • RE: Index is not used while selecting

    snigdhandream (2/2/2012)

    Thanks for your replies. I will make the scenario little bit clear now. The column_name1 is the leading column in the non-clustered composite index. The table has around 7000...

    February 3, 2012 at 1:22 pm

    #1442626

  • RE: Index is not used while selecting

    snigdhandream (2/2/2012)

    Hi,

    I have one table which has some 100+ columns. I have created a composite non-clustered index on 3 of the columns those are used frequently in where clause against...

    February 2, 2012 at 5:31 am

    #1441717

  • RE: What style of diagram to represent a particular process?

    This may be the case where a two levels diagram would help.

    On the first page a simple flowchart showing the main blocks then an additional diagram per block showing each...

    February 2, 2012 at 5:26 am

    #1441708

  • RE: Automatic truncate of varchar string

    SQL Kiwi (1/31/2012)

    SQLKnowItAll (1/31/2012)

    As long as you say it with a positive attitude and maybe a little "I really wish I could, but I just can't figure out how to...

    January 31, 2012 at 1:43 pm

    #1440950

  • RE: Automatic truncate of varchar string

    Siva Ramasamy (1/31/2012)

    I proposed it...but Varchar(max) is not accepted by the team...they want to limit it to 245

    Does it means that "the team" is Okay with losing data rather than...

    January 31, 2012 at 11:15 am

    #1440843

  • RE: Pivot table???

    I would adopt the solution that...

    1- I can understand

    2- I can explain to others

    3- I feel comfortable I can maintain.

    Having said that, I would probably hide the mmhhh... how to...

    January 31, 2012 at 9:02 am

    #1440721

  • RE: Optimize for ad hoc workload

    Roy Ernest (1/31/2012)

    On our OLTP server I set the value for "optimize for ad hoc workloads" as true.

    Out of curiosity... do you really have a large number of ad-hoc queries...

    January 31, 2012 at 8:33 am

    #1440696

  • RE: Pivot table???

    Cadavre (1/31/2012)

    You've over-complicated that a bit Paul. You can do it all with 1 hit on the table instead, using CASE.

    dozen ways minus two 😀

    By the way, first solution generates...

    January 31, 2012 at 8:20 am

    #1440687

  • RE: No. of Instances for a specific Edition

    All editions support named instances therefore you can have more than one and even mixed editions in your server. I've seen Standard and Enterprise edition named instances sitting pretty on...

    January 31, 2012 at 8:15 am

    #1440681

  • RE: Foreign Key reference with Synonym

    GSquared (1/31/2012)

    Jack's and my point is that something like that would give you half of referential integrity. You also need something on the other side that protects rows from...

    January 31, 2012 at 8:07 am

    #1440670

  • RE: Pivot table???

    GrassHopper (1/30/2012)

    Can you show me an example of what you mean? I don't follow you.

    Probably a dozen ways to do it, here goes one...

    create table #mytable

    (tocid decimal,

    prop_id decimal,

    str_val varchar(20),

    num_val...

    January 31, 2012 at 8:04 am

    #1440667

Viewing 15 posts - 511 through 525 (of 3,061 total)