Forum Replies Created

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

  • RE: DBCC Checkdb Problems

    GilaMonster (1/17/2013)

    Bhuvnesh (1/17/2013)

    The specialist is a person who knows everything about something but nothing about anything else.

    If you want to be insulting, kindly be so elsewhere.

    Absolutely NOT gail. i respect...

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

    January 17, 2013 at 5:14 am

    #1578252

  • RE: How to set index for these select queries

    prakash.kumar3669 (1/17/2013)

    What i have read from online articles, its important to index the columns which comes in where condition.

    Not only Where BUT group by, order by , JOIN's ON...

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

    January 17, 2013 at 4:30 am

    #1578229

  • RE: DBCC Checkdb Problems

    GilaMonster (1/17/2013)

    What's powershell? 😀

    Sorry, that's not something I use much, so don't know very well.

    The specialist is a person who knows everything about something but nothing about anything else.

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

    January 17, 2013 at 4:18 am

    #1578225

  • RE: Nested replaces ?

    i havent got what you actually needed and asked ? can you post your requirement with sample data along with desired output. see "we cant see what you see"

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

    January 17, 2013 at 4:15 am

    #1578223

  • RE: Delete rows from the table using cursor

    PLease note.4 years old thread.

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

    January 17, 2013 at 4:12 am

    #1578222

  • RE: Wrong Execution Plan question

    sqlnes (1/17/2013)

    What i can do so far is explained the current situation to the application owner.

    What you can before explanting to them, test the code with the suggestion and...

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

    January 17, 2013 at 3:31 am

    #1578195

  • RE: DB Shrinking Question

    broonie27 (1/16/2013)

    Why would the DB still be showing 10GB free space after a shrink?

    From BOL If target_size is specified, DBCC SHRINKFILE tries to shrink the file to the specified...

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

    January 17, 2013 at 1:43 am

    #1578142

  • RE: How to set index for these select queries

    prakash.kumar3669 (1/17/2013)

    In my table (large one) there is mainly three select queries:

    1) select * from Product where productid=101

    Here productid is primary key so it is clustered index, so no problem...

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

    January 17, 2013 at 1:26 am

    #1578138

  • RE: Wrong Execution Plan question

    Place your (

    SELECT a, b FROM KEY_TABLE kt JOIN......

    UNION

    SELECT a, b FROM KEY_TABLE kt JOIN......

    UNION

    SELECT a, b FROM KEY_TABLE kt JOIN......

    ) T0

    code in temp table and add appropraite...

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

    January 17, 2013 at 1:24 am

    #1578137

  • RE: Insert multiple lines in a single row

    shohelr2003 (1/17/2013)

    I don't know what is CU2.

    this is link http://support.microsoft.com/kb/2072493 , is it production server ? if ues then DOnt do this without proper discussion

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

    January 17, 2013 at 1:19 am

    #1578133

  • RE: Vendor DB backup job help.

    davidwarner (1/16/2013)

    Now i added the convert(varchar(2),datepart(mi,getdate())) part which does give me the minutes into the filename. but if the backup runs on the hour the file will get called DBNAMELog_13.bak...

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

    January 17, 2013 at 1:07 am

    #1578128

  • RE: Query Help..

    Unsed indexes/Sp/tables ...this task seems endless and startless for me.

    Why ?

    because how will and Who will decide which indexes/tables are UNUSED. how will you assure DBA, DEV ...

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

    January 17, 2013 at 12:23 am

    #1578112

  • RE: How to archive old data on top of existing table partition?

    Thanh Ngay Nguyen (1/16/2013)

    I have a very clear idea on how to do either 1 or 2, but not both.

    First you need to perform 1st then monthly job/manual...

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

    January 17, 2013 at 12:05 am

    #1578105

  • 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 11:57 pm

    #1578101

  • RE: Wrong Execution Plan question

    sqlnes (1/16/2013)

    It's weird, when I tried it today, it has back to the "correct" plan without set FORCEPLAN. it has been running fine now. I just wondering now would it...

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

    January 16, 2013 at 11:50 pm

    #1578098

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