Forum Replies Created

Viewing 15 posts - 42,466 through 42,480 (of 49,566 total)

  • RE: Do we have syatem table like DUAL in oracle

    sabarichandru (12/10/2008)

    i need for to run the single line statement in Tsql without using any specific tables ..

    Unlike in Oracle, SQL doesn't require the from clause or a table to...

    December 10, 2008 at 5:34 am

    #910242

  • RE: Improve SQL Query Performance

    debjani.bedajana (12/9/2008)

    Hi Gail,

    Sorry to bother you. Wondering if you could find some solution. Thanks for your help.

    Debjani

    Chris seems to have the query sorted. I'll take a look when I have...

    December 10, 2008 at 5:32 am

    #910239

  • RE: Performance optimization of UNIOn

    Is that the only index?

    December 10, 2008 at 2:09 am

    #910152

  • RE: Do we have syatem table like DUAL in oracle

    There's isn't a 'dual' table in SQL. What do you need it for?

    December 10, 2008 at 2:05 am

    #910146

  • RE: retrieve the previous version of a stored procedure

    Kishore.P (12/10/2008)

    you can generate the script the sp for previous ver. if it is not encrypted.

    How, if the proc has been written over?

    December 10, 2008 at 1:59 am

    #910139

  • RE: Database growth

    madhu.arda (12/10/2008)

    Hi Jeff,

    Iam curious to know why the available space for the database was showed as zero in enterprise manager and negative value when I ran sp_spaceused before running DBCC...

    December 10, 2008 at 1:02 am

    #910114

  • RE: Performance optimization of UNIOn

    arup_kc (12/10/2008)

    I have a notion than "SELECT D.Label" will take more system resources than "SELECT 1". And since EXISTS works on boolean value, hence no difference between the two but...

    December 10, 2008 at 12:51 am

    #910111

  • RE: Log File viewer shows error for backup

    Have you got any other backup tools than litespeed? That looks like the kind of messages that a 'snapshot' backup tool would generate. They work by asking SQL to temporarily...

    December 10, 2008 at 12:24 am

    #910103

  • RE: retrieve the previous version of a stored procedure

    Find a backup of the DB that has the version of the proc that you want. Restore that alongside the existing DB and then script out the procedure

    December 10, 2008 at 12:22 am

    #910101

  • RE: pls help me

    ganesha2181 (12/9/2008)

    *** i have a 400000 lacs data. i want to this data separeted to 40 tables. per table have 100000 data.

    Why?

    December 10, 2008 at 12:18 am

    #910098

  • RE: Performance optimization of UNIOn

    mohd.imtiaz (12/9/2008)

    Hi Gail,

    here is the table defination

    Index definitions?

    December 10, 2008 at 12:08 am

    #910093

  • RE: Are the posted questions getting worse?

    rbarryyoung (12/9/2008)

    GilaMonster (12/9/2008)

    I still think my favourite has to be this piece of code that I found when one of the devs complained that the dev server was very slow....

    December 9, 2008 at 4:06 pm

    #910001

  • RE: sql 2005 encryption

    Joe (12/9/2008)

    I want to do encryption in sql 2005 without modfiing any exsiting data structure or application? it that possible in sql 2005; pls hlep; thanks in advance.

    What do you...

    December 9, 2008 at 2:57 pm

    #909975

  • RE: Are the posted questions getting worse?

    Matt Miller (12/9/2008)

    Funny - that's the EXACT reaction I got when I tossed it back....:)

    Just about every time I've done a presentation or informal training and mentioned the problems of...

    December 9, 2008 at 2:43 pm

    #909965

  • RE: Query Help Please

    Mike Feuti (12/9/2008)

    Not sure if this answers your question or not but I want the email addresses and ID for anyone on any committtee. the ID's are the link...

    December 9, 2008 at 2:40 pm

    #909962

Viewing 15 posts - 42,466 through 42,480 (of 49,566 total)