Forum Replies Created

Viewing 15 posts - 706 through 720 (of 789 total)

  • RE: Cannot delete table

    It seems that you should close the conn, but also try to restart all services on the Instance where you are working!

    :w00t:

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

    July 11, 2008 at 2:35 pm

    #841820

  • RE: SQL Server 2005 Service Accounts

    Nice article and rich stuff here ...thnx Steve!

    :w00t:

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

    July 11, 2008 at 7:42 am

    #841485

  • RE: Recovery Model

    Hi Sudarram,

    Full Recovery Model fully logs all transactions so the Bulk-Logged Recovery Model minimally logs bulk operations! Bulk-Logged Recovery Model works almost in same manner as Full Recovery Model but...

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

    July 11, 2008 at 7:03 am

    #841448

  • RE: Building Parent-Child Table Tree information

    Interesting ... lot of stuff here and very rich article

    thnx and no comment!

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

    July 10, 2008 at 12:29 pm

    #841034

  • RE: Query issue

    Ok as I can see at the varchar parameter is incorrect you should write like this ''%' + @parameter(varchar)+'%''

    CREATE proc usp_strsrchtemp

    @userstr varchar(100),...

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

    July 10, 2008 at 12:17 am

    #840641

  • RE: What's an MVP?

    Very intereseting ....

    So if you compare one MVP(SQL - and we have some infos how to become MVP) with one Software Engineer (SQL or Oracle Database) Graduate Master or Doctorature...

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

    July 9, 2008 at 12:43 pm

    #840453

  • RE: Pivot view date - SQL vs Oracle

    For the moment I'm not front of Oracle DB I will try tomorow! - thnx!

    Dugi

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

    July 9, 2008 at 12:04 pm

    #840431

  • RE: Pivot view date - SQL vs Oracle

    I try it with TO_CHAR but still not working ... because the same function I used on another view and it works very fine... here to create pivot not working!

    I'm...

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

    July 9, 2008 at 4:39 am

    #839974

  • RE: Pivot view date - SQL vs Oracle

    ...Hmmm... Not working and I do not have any idea what is wrong!!??

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

    July 9, 2008 at 12:55 am

    #839897

  • RE: How do I convert an ip address (stored in a column) to a decimal

    Jason Selburg (6/19/2008)

    Or you could take advantage of the fact that an IP address just happens to have four parts just like a fully qualified SQL object name and use...

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

    July 7, 2008 at 7:15 am

    #838847

  • RE: Import/Export

    Yep we are here to help you just post the specific info what you are trying to do, of course that there are many ways how to do that, but...

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

    July 7, 2008 at 7:00 am

    #838829

  • RE: Independence Day

    hmmm I forget ah ..... Happy Independence of USA ....!!!!

    Regards from Republic of Kosova the newest state in the World

    thnx USA!

    Dugi

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

    July 4, 2008 at 8:10 am

    #838365

  • RE: DBA Certification

    Hi, can you provide us what experience you have with databases or more specific with SQL server:

    1. How many years you have experience!

    2. How are you familar with SQL Server...

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

    July 2, 2008 at 10:22 am

    #837326

  • RE: Congratulations to Our New MVPs

    Congratz! - Jeff and Michael

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

    July 2, 2008 at 12:33 am

    #837012

  • RE: Truncate Log

    I have Hr_database

    Hr_database_data.mdf 1235MB

    Hr_database_log.LDF 25623502MB

    The LDF is growing how to truncate this log file, any scripts??

    Thanks NITa

    The correct way is:

    Set the recovery mode to Simple then shrink log...

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

    June 24, 2008 at 7:22 am

    #833303

Viewing 15 posts - 706 through 720 (of 789 total)