Forum Replies Created

Viewing 15 posts - 751 through 765 (of 789 total)

  • RE: COUNT and NULL

    then...after janine.rawnsley's post what is the final word for this topic to use join or "or" operator!

    or it depends from the relations between tables..plz advice!

    ???

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2008 at 4:45 am

    #808916

  • RE: Database backups best practice

    great topic with useful things here ... thnx friends for everything that you reply here!

    :hehe::hehe::hehe::hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2008 at 2:53 am

    #808866

  • RE: Sharing data between two databases

    nice and useful topic...thnx!:P

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2008 at 2:41 am

    #808860

  • RE: Named Pipes

    o nooo I didn't know that the backup strategy changes from SQL server 2000 in SQL Server 2005 ...o nooo at least this detail o nooo!

    :D:D:D:D:D:D:D:D:D

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 23, 2008 at 12:06 am

    #805879

  • RE: Rebuild Master

    Me too, I lose but I learn professional way thnx!

    😛

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 22, 2008 at 5:33 am

    #805413

  • RE: DBA Morning Check List

    This is nice article & useful... not bad!

    Great post here!

    Thnx! 😉

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 15, 2008 at 2:52 am

    #802404

  • RE: link server

    Grant Fritchey (4/4/2008)

    Try

    SELECT * FROM pkd...tbl

    it works!...thnx!

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 4, 2008 at 8:11 am

    #798461

  • RE: link server

    So what about if you want to create a link to Access database!?

    the link is working but when it creates, you can see what happened with hierarchy:

    please see the attachment!

    so...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 4, 2008 at 1:09 am

    #798228

  • RE: Table vs View

    There is the results:

    retrieving from the table with the same where clause it takes 1:33 (min:sec)

    from view with 4 columns it takes 0:33 ( min:sec)

    so the table definition is with...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 3, 2008 at 2:05 am

    #797663

  • RE: Table vs View

    It depends from the users rights!

    the more efficient is view sometimes when you have to use the particular data for some users, because you eliminate many unnecessary columns to view...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 3, 2008 at 1:43 am

    #797650

  • RE: Hot Backup

    thnx for Reply!

    🙂

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 2, 2008 at 2:19 am

    #797049

  • RE: Huge table update

    ok there is the results for my table with over 1 500 000 records:

    updateing

    25 000 rec for 1:22 (min:sec)

    250 000 rec for 7:19

    over 500 000 or exactly 676 561...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 28, 2008 at 5:04 pm

    #795516

  • RE: Huge table update

    Antares686 (3/28/2008)

    Did you set you batch size, when you call call like this

    EXEC spUpdatepare 25000

    this will affect 25000 records in the batch.

    I confused with this problem so I forget that...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 28, 2008 at 8:45 am

    #795240

  • RE: Huge table update

    Hmmm ...it's impossible ok the syntax of the procedure works and has been created but when I execute them both of them again doesn't work there is msg:

    Msg 201, Level...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 28, 2008 at 8:36 am

    #795230

  • RE: Huge table update

    ookkk now works fine ...thnx from all of you !!!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 28, 2008 at 8:24 am

    #795216

Viewing 15 posts - 751 through 765 (of 789 total)