Forum Replies Created

Viewing 15 posts - 511 through 525 (of 18,926 total)

  • RE: clustered vs Non clustered index scan

    LIKE 'string%' (no % at the begining) can use a seek. Those will indeed scan.

    That's an estimated plan, I need the actual one.

    What you can do with search...

    December 7, 2011 at 6:47 pm

    #1418458

  • RE: clustered vs Non clustered index scan

    Can you post the most standard searches along with it's actual execution plan?

    Maybe we can turn it into a seek which would be loads better.

    December 7, 2011 at 5:53 pm

    #1418440

  • RE: Today's Random Word!

    SQLRNNR (12/7/2011)

    bcsims 90437 (12/7/2011)

    Ninja's_RGR'us (12/7/2011)

    SQLRNNR (12/7/2011)

    mutiny

    How can you do that when you're the boss???

    Multiple personalities?

    understatement

    says who?

    December 7, 2011 at 11:16 am

    #1418307

  • RE: Return as single comma delimitted value

    drew.allen (12/7/2011)

    Ninja's_RGR'us (12/7/2011)

    And the solution is??? Those are columns, not rows.

    I'll let you think about it for a couple minutes ;-).

    FOR XML PATH('') needs to be handle any data...

    December 7, 2011 at 11:15 am

    #1418306

  • RE: date when changes made to the object?

    Close the dbs (still accessible, it'll just have to be auto-opened).

    check the default trace for if / when they open. Keep in mind that this trace only keeps 125MB...

    December 7, 2011 at 10:48 am

    #1418290

  • RE: date when changes made to the object?

    Tara-1044200 (12/7/2011)

    Deos the query you provided give me the last date when some one read any database?

    and if i am doing a daily backup, does that show wrong dates?

    Back to...

    December 7, 2011 at 10:31 am

    #1418275

  • RE: T-SQL help

    I knew I was forgetting something :w00t:.

    Tx

    December 7, 2011 at 10:30 am

    #1418274

  • RE: conversion error

    Just replace all spaces, commas (assuming period is your decimal separator).

    Then the cast will work.

    December 7, 2011 at 10:24 am

    #1418269

  • RE: Where do I go from here Education wise?

    ramjohn8 (12/7/2011)

    So I should go ahead and create that faux database then. I was thinking about creating a database based on my brother's Transformer collection. 😀

    Any...

    December 7, 2011 at 10:23 am

    #1418268

  • RE: T-SQL help

    HTH 🙂

    December 7, 2011 at 10:22 am

    #1418267

  • RE: Temp Table Vs Table Variable

    matt.newman (12/7/2011)

    Sorry, must have missed. Lots of stuff to read through! Probably glazed over a few.

    NP, so did I 😀

    December 7, 2011 at 10:19 am

    #1418264

  • RE: Temp Table Vs Table Variable

    matt.newman (12/7/2011)

    A table variable is not always used the same way for the rest of the query. Maybe you have the 10K row count or maybe 2 row count in...

    December 7, 2011 at 10:11 am

    #1418255

  • RE: Where do I go from here Education wise?

    ramjohn8 (12/7/2011)

    That sounds like a great idea. Speaking of which I have been given a Test Server but I'm not exactly sure where to start? Should I just...

    December 7, 2011 at 10:08 am

    #1418251

  • RE: Return as single comma delimitted value

    drew.allen (12/7/2011)

    I prefer using FOR XML PATH(''), because it

    1) automatically handles the conversion

    2) automatically handles NULL values

    If you're working with character data, you do have to be careful with certain...

    December 7, 2011 at 10:07 am

    #1418250

  • RE: How to use case/between in where clause to write this simple query? Thanks.

    Lynn Pettis (12/7/2011)

    halifaxdal (12/7/2011)

    Lynn Pettis (12/6/2011)

    Ninja - You'll have to show me what you were trying to accomplish, just not clicking today.

    Please don't be tough to Ninja, maybe it was...

    December 7, 2011 at 9:54 am

    #1418240

Viewing 15 posts - 511 through 525 (of 18,926 total)