Forum Replies Created

Viewing 15 posts - 1 through 15 (of 2,462 total)

  • Reply To: Having issue while removing non-empty filstream from database

    Correct , my goal is to move database (on-premises) size 700 GB having 2 gb filestream  to EC2 (data and log files will be sitting on ASWS FSX files) and...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    November 17, 2021 at 2:13 pm

    #3954063

  • RE: MSDTC Setting Issue

    same settings worked for me ..thanks

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    January 7, 2015 at 2:29 am

    #1768365

  • RE: Unsual DEADLOCK info

    thanks scott and gail

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 29, 2014 at 10:13 pm

    #1766912

  • RE: Add partition to existing table

    Tarun Jaggi (12/29/2014)

    The main concern is coming while moving back 600M rows (from non-partitioned table) to the partitioned table T1 as non-partitioned table is in primary fg but each partition...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 29, 2014 at 1:53 am

    #1766678

  • RE: Add partition to existing table

    See this http://www.mssqltips.com/sqlservertip/2888/how-to-partition-an-existing-sql-server-table/

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 29, 2014 at 1:26 am

    #1766669

  • RE: Error when altering steps from job in SQL 2008

    gentong.bocor (12/11/2014)

    hi..

    it's very annoying everytime i choose edit steps from a job in SQL2008, it sometimes get such an error like this

    first time it doesn't show errors, several times i...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 29, 2014 at 1:21 am

    #1766668

  • RE: Index Space calculation confusion

    thanks to all for information

    Another Question : can we say "clustered index size" = " original table size" ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    August 11, 2014 at 5:42 am

    #1736803

  • RE: Index Space calculation confusion

    John Mitchell-245523 (8/11/2014)

    Bhuvnesh

    A clustered index isn't the same as other indexes - it forms the actual rows of the table and therefore doesn't contribute to the "index" size. When...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    August 11, 2014 at 4:15 am

    #1736759

  • RE: OS cache in Sql Server

    MikaS (7/30/2014)

    Hi,

    OS System Cache is a subset of a Standby List. Standby List is used for pages that have not been touched for awhile and Windows performed memory trimming on...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    July 30, 2014 at 3:50 am

    #1733507

  • RE: "sys.dm_db_index_usage_stats" has missing information

    thanks a lot Gail

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    July 8, 2014 at 6:03 am

    #1727728

  • RE: OLE DB Source DSn is not visible

    when i create connection

    this i got

    TITLE: Connection Manager

    ------------------------------

    Test connection failed because of an error in initializing provider. ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    July 2, 2014 at 10:40 am

    #1726571

  • RE: OLE DB Source DSn is not visible

    thanks koen , i googled these links ealrier too but couldnt get any help . i will come with complete issue details

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    July 2, 2014 at 2:33 am

    #1726406

  • RE: OLE DB Source DSn is not visible

    Koen,

    first of all thanks for the regular support. 🙂

    i need to make connection for postgresql . how can i ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    July 2, 2014 at 12:56 am

    #1726387

  • RE: SSIS with postgresql

    so which DSn i need to use for postgresql from drop down ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    July 1, 2014 at 1:02 am

    #1726060

  • RE: SaaS and Multi-tenancy Models

    can anyone explain "data warehouse" vs "enterprise data warehouse" ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    March 11, 2014 at 1:56 am

    #1695828

Viewing 15 posts - 1 through 15 (of 2,462 total)