Forum Replies Created

Viewing 15 posts - 41,236 through 41,250 (of 49,552 total)

  • RE: statement runs very slow what have I done wrong or what could I change to make it better

    Please post table definitions, index definitions and the execution plan (saved as a .sqlplan file zipped and attached)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 9:12 am

    #937233

  • RE: SQL Injection

    Jonathan Kehayias (2/3/2009)

    Another thing to note is that what might seem 100 level to you may not be for someone else. I got flamed a few months back for...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 9:09 am

    #937228

  • RE: How to ascertain the path of an active SQL trace (2005 & 2000)

    elitejyo (2/3/2009)

    IIf there are any active traces created using SQL Profiler they are listed as

    id status path...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 9:06 am

    #937224

  • RE: Changed to a StarWars Avatar...am I part of the Club now?

    Lowell (2/3/2009)

    Noted a strong theme among the high posters that everyones shifted to a Star Wars Avatar...

    It was for a bit of fun this past weekend. You may have noticed...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 9:01 am

    #937213

  • RE: Tutorial/Tips on writing SPs that are fast and upto standards of development

    idrees.butt (2/3/2009)

    and the thing is that when I read common mistakes...I cant appreciate them since I dont know whats the correct way of doing that thing...what to do in this...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 8:51 am

    #937198

  • RE: SQL Injection

    NotManyPoints (2/3/2009)

    As it should suggest if you have 'used' this site and generated over 300 posts, some 'skill' must have sunk in.

    Not necessarily. There's a person on another SQL forum...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 8:49 am

    #937195

  • RE: SQL Injection

    NotManyPoints (2/3/2009)

    Was someones account hijacked to ask this question.

    I doubt it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 7:56 am

    #937144

  • RE: compilation error

    vikas bindra (2/3/2009)

    you can not use table variable in: INSERT INTO @tableVar SELECT * FROM anyTable.

    You can't?

    create table TestingVariables (id int, strng varchar(10))

    insert into TestingVariables (id, strng) values (1,'a')

    insert into...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 7:54 am

    #937142

  • RE: No primary key created

    jchandramouli (2/2/2009)

    What is the actual intention creating a table using this script?

    It creates a two column table on the primary filegroup. It won't create a primary key because there's...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 7:44 am

    #937134

  • RE: How to determine that given trace file is active or not

    shivani.suri2 (2/3/2009)

    But the value of path column of sys.traces table is NULL.

    The path will be NULL because, according to SQL, it's not writing the trace to a file, it's streaming...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 7:41 am

    #937132

  • RE: How to find backup frequency

    There's a backup history table somewhere in msdb. Backupset I think

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 7:35 am

    #937129

  • RE: delete records in sql without entry in transaction log

    Derek Dongray (2/3/2009)

    I'm not aware of any way to do deletions without any transaction logging at all.

    All data modifications in SQL are logged, one way or another. It's not...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 7:25 am

    #937116

  • RE: Replication without a primary key in the publisher ?

    obarahmeh (2/3/2009)

    Dear All,

    I have a table that has a huge number of data, this table has no primary key.

    I need to create a replication that replicate this table and any...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 7:22 am

    #937109

  • RE: Need strategy for disaster recovery

    Arun (2/3/2009)

    I am able to take full backup in my production server using the WITH COPY_ONLY option now. Also the log shipping is working fine.

    The only time the COPY_ONLY...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 7:18 am

    #937104

  • RE: Files per Filegroup depends on # of CPU?

    Depends. Are we talking 4 or 5 files, or 4 or 5 hundred files?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 3, 2009 at 7:11 am

    #937097

Viewing 15 posts - 41,236 through 41,250 (of 49,552 total)