Forum Replies Created

Viewing 15 posts - 25,231 through 25,245 (of 49,552 total)

  • RE: Help with SQL query

    Excellent. Take a careful read through my blog post (referenced above) to make sure you're not opening yourself to SQL Injection vulnerabilities. There are ways to do this with dynamic...

    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

    July 2, 2011 at 10:43 am

    #1347456

  • RE: Help with SQL query

    Think it works in R2. Not 100% sure

    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

    July 2, 2011 at 8:05 am

    #1347438

  • RE: Table not recognising new column

    p.s. Store dates in a datetime. You're setting yourself up for a world of pain by storing it as a char. Doesn't matter that it's passed as a string, SQL...

    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

    July 2, 2011 at 7:28 am

    #1347434

  • RE: Table not recognising new column

    It wasn't SQL telling you the column was invalid, had you run the insert it would have run just fine. It was just Management Studio's Intellisense. It doesn't update after...

    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

    July 2, 2011 at 7:27 am

    #1347433

  • RE: Table not recognising new column

    Edit -> Intellisense -> Refresh Local Cache

    (or Ctrl-Shift-R)

    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

    July 2, 2011 at 7:15 am

    #1347430

  • RE: Help with SQL query

    opc.three (7/2/2011)

    Bummer. The article is still relevant. Please see the section titled "Recompile". Adding the option to your query will cause it to be more expensive than would otherwise be...

    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

    July 2, 2011 at 6:54 am

    #1347428

  • RE: A Little Interviewing Advice

    Craig Farrell (7/2/2011)

    Jeff Moden (7/1/2011)

    djackson 22568 (7/1/2011)

    While it is true that these MAY NOT be opposites, for most managers they are.

    I have to disagree with that, as well. I've...

    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

    July 2, 2011 at 5:22 am

    #1347423

  • RE: Please help!! Going to SQL Bootcamp.

    SQLRNNR (7/1/2011)

    I'd also recommend checking out the MCM Videos.

    http://sqlskills.com/T_MCMVideos.asp

    Those might be a little (ok a lot) advanced for someone doing a ITP bootcamp

    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

    July 1, 2011 at 1:36 pm

    #1347304

  • RE: Are the posted questions getting worse?

    Thanks everyone. Wasn't actually planning on announcing it here.

    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

    July 1, 2011 at 1:25 pm

    #1347300

  • RE: Are the posted questions getting worse?

    GSquared (7/1/2011)

    GilaMonster (7/1/2011)

    Gus, you own me a new keyboard!

    GSquared (7/1/2011)

    I must be misunderstanding you. I've never before seen someone recommend hypocrisy before without it being essentially sarcastic.

    Assuming "own" =...

    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

    July 1, 2011 at 11:02 am

    #1347203

  • RE: Unnecessary Index?

    GSquared (7/1/2011)

    The main advantage I see to the non-clustered index in this case, is that it will have more rows per page than the clustered index (since it's narrower), and...

    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

    July 1, 2011 at 11:00 am

    #1347198

  • RE: Unnecessary Index?

    No. Not with a table this narrow. If I was doing indexing work, that one would be on my list to drop without serious concern.

    Just do a check (query sys.sql_modules)...

    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

    July 1, 2011 at 10:58 am

    #1347194

  • RE: NonClustred Index on Primary key vs Clustred Index on Primary key

    krish.sett (7/1/2011)

    Hi Gail Shaw,

    So you mean to say its another way of appling unique constrain ...?

    Exactly.

    The only differences between unique index and unique constraint is the way they appear in...

    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

    July 1, 2011 at 10:55 am

    #1347191

  • RE: Are the posted questions getting worse?

    Gus, you own me a new keyboard!

    GSquared (7/1/2011)

    I must be misunderstanding you. I've never before seen someone recommend hypocrisy before without it being essentially sarcastic.

    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

    July 1, 2011 at 10:53 am

    #1347190

  • RE: Unnecessary Index?

    In this particular case there are very few advantages to having that exact index, seeing as the table is so small. Swapping the columns around (col4, col1) however could be...

    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

    July 1, 2011 at 10:50 am

    #1347184

Viewing 15 posts - 25,231 through 25,245 (of 49,552 total)