Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 2,647 total)

  • RE: please give me a solution for this request

    Jeff Moden (4/23/2012)

    capn.hector (4/23/2012)

    +1 however i saw this same question as homework for one of my sql classes.

    Interesting! Where did you take such a class? ...

    April 23, 2012 at 10:32 am

    #1477632

  • RE: Unable to connect to SQL Server 2008 r2 named instance

    RedLegSQL (4/23/2012)

    Hope someone can help with this one, I've installed SQL Server 2008 r2 developer edition onto the same pc as a default instance of 2005.

    however when I try and...

    April 23, 2012 at 9:36 am

    #1477593

  • RE: sql small discusion

    GilaMonster (4/23/2012)

    SQLKnowItAll (4/23/2012)

    1. A covering index is an index whose key contains all of the values of a query and subsequently does not require reading anything other than the index....

    April 23, 2012 at 9:03 am

    #1477566

  • RE: How to reduce log file size in BCP in?

    Feeg (4/23/2012)

    switch from simple to bulk-logged recovery model ...

    ?

    April 23, 2012 at 9:00 am

    #1477563

  • RE: sql small discusion

    Phil Parkin (4/23/2012)

    Do you know how to use google?

    If you check out the OP's other posts (try this link), you'll rapidly come to the conclusion that the answer is 'no'.

    ROFL...

    April 23, 2012 at 8:47 am

    #1477551

  • RE: please give me a solution for this request

    capn.hector (4/23/2012)

    GSquared (4/23/2012)

    Solution is, tell whomever put the data in the table to do it again, but do it right this time. Don't split the data across multiple rows...

    April 23, 2012 at 8:45 am

    #1477550

  • RE: sql small discusion

    asranantha (4/23/2012)

    1)what is covering index?when we use in sql servr?

    2)what dynamic management view and when we use in sql server?

    Do you know how to use google? 🙂 There is...

    April 23, 2012 at 8:35 am

    #1477536

  • RE: how to display ranking with total ranking in it

    I would test the performance of MAX versus COUNT. Not sure offhand which would be better... Also, I hope you are not storing '1 of 3' in a column....

    April 23, 2012 at 8:19 am

    #1477522

  • RE: SQL Server maintenance plans

    John Mitchell-245523 (4/23/2012)

    Backups can be set to expire - this is when the backup set can be overwritten with a new one. The maintenance cleanup task is different -...

    April 23, 2012 at 8:06 am

    #1477506

  • RE: how to display ranking with total ranking in it

    Shree-903371 (4/23/2012)

    I have sorted the data and had ranking for highest sales by City. But I want to see ranking with highes rank in that city i.e. 1 of 3

    CREATE...

    April 23, 2012 at 7:55 am

    #1477495

  • RE: DB-Mail

    sudhakar-726066 (4/23/2012)

    [font="Courier New"]

    Hello Everyone,

    I have configured DB mail Which works for all SQL server's 2008 except few servers, Which gives below error when i try to send test message.

    ERROR:...

    April 23, 2012 at 7:49 am

    #1477490

  • RE: SQL Server maintenance plans

    Yes, it will delete it. If you moved that file, it would still be a valid file. The backups don't "expire," the clean-up will simply delete them.

    April 23, 2012 at 7:46 am

    #1477489

  • RE: please give the solution for this

    Why don't we start with the basics...

    1. How is the backup created; i.e. Script please...

    2. How are you restoring; again, script please.

    April 23, 2012 at 7:41 am

    #1477484

  • RE: OPENQUERY running stored procedure twice

    raghu_ktm (4/23/2012)

    Hi Jared,

    Nice to see the solution here, In may case same issue with MSSQL Linked server, do you have any idea to solve this as well !

    I am calling...

    April 23, 2012 at 7:09 am

    #1477467

  • RE: Dropping indexes with low read to write ratio?

    GilaMonster (4/19/2012)

    SQLKnowItAll (4/19/2012)

    GilaMonster (4/19/2012)

    SQLKnowItAll (4/19/2012)

    To add a bit that people often forget is the uniqueness of the column(s) indexed. If the data is skewed the index may not be very...

    April 20, 2012 at 5:57 am

    #1476549

Viewing 15 posts - 1,036 through 1,050 (of 2,647 total)