Forum Replies Created

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

  • RE: Partition Switch to another database

    Suresh B. (1/16/2013)

    However, the filegroup can be different from that of the corresponding tables or other corresponding indexes.

    What does it mean ?

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

    January 16, 2013 at 5:19 am

    #1577763

  • RE: Wrong Execution Plan question

    sqlnes (1/16/2013)

    Could anyone get idea of why SQL Server did not use the "correct" plan as the one when FORCEPLAN was set ON?

    from BOL SQL Server query...

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

    January 16, 2013 at 3:46 am

    #1577738

  • RE: how to concatenate rows and join in another table

    Hi Welcome to SSC forum,

    please Dont cross post , it waste the time of people

    the original thread is http://www.sqlservercentral.com/Forums/Topic1407712-392-1.aspx

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

    January 16, 2013 at 3:38 am

    #1577737

  • RE: Problem in executing distributed query

    Dont cross post , it waste the time of people

    the original thread is http://www.sqlservercentral.com/Forums/Topic1406594-391-1.aspx#bm1407719

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

    January 16, 2013 at 3:35 am

    #1577736

  • RE: Insert multiple lines in a single row

    shohelr2003 (1/16/2013)

    If I execute an insert query into linked server, it works. But when I use trigger to execute an insert query into linked server, it fails and generates the...

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

    January 16, 2013 at 3:31 am

    #1577733

  • RE: Partition Switching Problem

    swaroop.sahoo (1/15/2013)

    I tried to create a partition for January and switch the data in the dummy partition to the newly created partition. But the script ran for more than a...

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

    January 16, 2013 at 3:27 am

    #1577732

  • RE: SQL Server usage in Financial Services

    you can see in below link , many big fishes using Sql server.

    http://blogs.technet.com/b/dataplatforminsider/archive/2012/09/26/financial-services-companies-rely-on-sql-server-2012-to-deliver-the-new-standard-in-mission-critical-platforms.aspx

    http://content.dell.com/us/en/enterprise/sql-server

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

    January 16, 2013 at 3:16 am

    #1577729

  • RE: Rowversion Duplication

    shilpaprele (1/16/2013)

    there may be many developers working on the DB. And if sombody uses the select into then we will have dupliction.

    and this cant be get restricted or stopped...

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

    January 16, 2013 at 2:14 am

    #1577706

  • RE: Insert multiple lines in a single row

    shohelr2003 (1/15/2013)

    @Bhuvnesh,

    Actually it is a distributed query. I wrote an AFTER TRIGGER that will fetch information from six tables that will be SMS content and insert into a remote database's...

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

    January 15, 2013 at 10:12 pm

    #1577622

  • RE: how top clause works

    thanks grant

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

    January 15, 2013 at 10:04 pm

    #1577619

  • RE: how top clause works

    Grant Fritchey (1/15/2013)

    as soon as the data changes or the inputs change, all bets are off.

    yes i have also realized that for smaller set , we can see the...

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

    January 15, 2013 at 5:08 am

    #1577269

  • RE: Rowversion Duplication

    shilpaprele (1/14/2013)

    Is there any way that we can use "SELECT INTO" and still avaoid rowversion dupllication?

    YEs you can try like

    select "all coumns except rowversion column " into newtable...

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

    January 15, 2013 at 4:36 am

    #1577254

  • RE: how top clause works

    sej2008 (1/15/2013)

    I found that TOP clause works little randomly with

    Select TOP 50 percent * from Tablename as it is not giving exact 50 percent in my result set .how it...

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

    January 15, 2013 at 3:55 am

    #1577235

  • RE: Insert multiple lines in a single row

    shohelr2003 (1/15/2013)

    Thank you, Sir. Your code works.

    Actually I wanna convey SMS from my database through mobile operator. That's why I want to insert data in my convenient format. If I...

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

    January 15, 2013 at 3:28 am

    #1577221

  • RE: SQL Server consuming 90% Memory

    Ed Wagner (1/14/2013)

    I have read that SQL Server will consume as much memory as you throw at it and want just a little bit more. No matter how much...

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

    January 14, 2013 at 10:24 pm

    #1577147

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