Forum Replies Created

Viewing 15 posts - 706 through 720 (of 3,061 total)

  • RE: Are You Easy To Work With?

    SQLRNNR (11/23/2011)

    Elliott Whitlow (11/22/2011)

    Depends on the topic.. If you want to do something monumentally boneheaded in SQL then I'm going with No, VERY difficult..

    CEWII

    I probably am in...

    November 23, 2011 at 1:26 pm

    #1412456

  • RE: Database setting upon creation

    Klarence A. (11/23/2011)

    Hi.. What should be considered in setting the autogrowth and initial size of each file upon creation?

    Welcome to capacity planning.

    1- Estimate how much space will be needed...

    November 23, 2011 at 1:05 pm

    #1412444

  • RE: Data migration

    sunny.tjk (11/22/2011)

    I'm going to run DBCC Shrinkfile to migrate data out of a huge file into 2 new files. After the data is migrated, do I need to drop the...

    November 23, 2011 at 12:20 pm

    #1412414

  • RE: Help regarding Data update in SQL

    Please check: http://www.sqlservercentral.com/Forums/Topic493913-338-1.aspx

    November 23, 2011 at 11:25 am

    #1412384

  • RE: Where do you save your Create By/Date and Modify By/Date information?

    sam.alexander (11/23/2011)

    This is more of a general question on where everyone saves when and who created and last edited a record in the database.

    My standard is to have CreateBy, CreateDate,...

    November 23, 2011 at 11:17 am

    #1412381

  • RE: Update Statistics and Backup

    Dev (11/23/2011)

    Note: Not relevant to SQL Server.

    Export utility

    STATISTICS

    Default: ESTIMATE

    Specifies the type of database optimizer statistics to generate when the exported data is imported. Options are ESTIMATE, COMPUTE, and...

    November 23, 2011 at 10:35 am

    #1412359

  • RE: Update Statistics and Backup

    Dev (11/23/2011)

    Oracle gives control to copy / not copy statistics in backup / restore.

    Not true.

    November 23, 2011 at 9:57 am

    #1412334

  • RE: Update Statistics and Backup

    Dev (11/23/2011)

    Roy Ernest (11/23/2011)

    As far as I know when a Back up is done, it preserves the Stats as well.

    Can you please lead me to some evidence?...

    November 23, 2011 at 8:50 am

    #1412270

  • RE: SQL server connections to informix database

    mya (11/23/2011)

    I want to know that SQL server can make connection to informix database. How can I go about this ? Do we need specific ODBC driver?

    Please check IBM...

    November 23, 2011 at 8:43 am

    #1412261

  • RE: Update Statistics and Backup

    Dev (11/23/2011)

    What you can do using the proper DBMS_ Oracle package is to take a Performance Statistics "backup" and "restore" it as it pleases you but this is...

    November 23, 2011 at 7:16 am

    #1412176

  • RE: Update Statistics and Backup

    Dev (11/23/2011)

    jbrewer (11/23/2011)

    Is it better to run a full backup before or after Updating Statistics?

    I am kind of curious on what all information SQL Server Backup stores. Because...

    November 23, 2011 at 7:08 am

    #1412168

  • RE: hi guys

    smohammadnia.3840 (11/23/2011)

    oh no sorry plz my error is:

    Msg 7308, Level 16, State 1, Line 4

    OLE DB provider 'MSDAORA' cannot be used for distributed queries because the provider is configured to...

    November 23, 2011 at 6:57 am

    #1412155

  • RE: Landing My First Job

    SqlNewJack (11/23/2011)

    ...my wife and I just welcomed our baby boy into the world which is why my transition has been slow.

    You really got a good excuse, huh? Congrats!...

    November 23, 2011 at 6:53 am

    #1412150

  • RE: Partition usage in SQL Server 2008

    smitha.bangalore (11/23/2011)

    Sorry..It was the typo error. Both the filters are on DT column.

    Would you mind in posting full query and execution plan - for both cases as well as base...

    November 23, 2011 at 6:50 am

    #1412146

  • RE: Landing My First Job

    Dev (11/23/2011)

    PaulB-TheOneAndOnly (11/23/2011)

    Dev (11/23/2011)[hrNope. He/she is not. Last Login Friday, May 06, 2011 9:35 PM.

    :w00t: don't you feel like preaching on the desert?

    Not Exactly. The...

    November 23, 2011 at 6:32 am

    #1412129

Viewing 15 posts - 706 through 720 (of 3,061 total)