Forum Replies Created

Viewing 15 posts - 211 through 225 (of 320 total)

  • RE: Job failed with this error : Conversion failed because the data value overflowed the specified type

    post the error that show in progress tab!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Job failed with this error : Conversion failed because the data value overflowed the specified type

    according with microsoft's article (link bellow), is necessary to do explicit convertion, for example: cast(test as smalldatetime).

    http://msdn.microsoft.com/en-us/library/ms187928.aspx

    in SSIS you can to use the Data Conversion Transformation (component).


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Shared data sets

    good question!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: TDE and Backups

    nice question!

    thanks steve!!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Shrink Database

    very nice question!!! thanks!!!

    Living and learning!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Page Compression in Heaps

    nice! thanks!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Page split - 2

    nice question!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: IsNumeric with NULL and Empty String

    nice!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: DBCC INDEXDEFRAG

    good question!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: How to use temporary table in function

    very nice!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Database Snapshot

    well, forsqlserver!!!

    you posted, correct documentation but incorrect answer!!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: RAID configuration for SQL Server 2008 Database with 8 hard disks

    Perry Whittle (7/12/2011)


    RAID5 and RAID6 have the overhead of parity calculations. RAID10 write performance is much better.

    overhead of writes on disks (on case swap disk too), but better performance on...


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: RAID configuration for SQL Server 2008 Database with 8 hard disks

    ... Everything you need to know about raid10 failures is explained on posts on this forum. I recommend you go to wikipedia or other source for additional reading on...


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: RAID configuration for SQL Server 2008 Database with 8 hard disks

    hi everyone!!!

    after all comments/posted in this discussion, i have a question to pei zhu and kevin with relation the proposed scene, what i said in begin of discussion, is wrong?

    like...


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: RAID configuration for SQL Server 2008 Database with 8 hard disks

    I have nothing to say! only to thank, because every day I learn more! and have long enough humility to recognize that I am wrong!

    Jim Murphy, Pei Zhu-415513, TheSQLGuru, my...


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

Viewing 15 posts - 211 through 225 (of 320 total)