Forum Replies Created

Viewing 15 posts - 41,551 through 41,565 (of 49,552 total)

  • RE: Deadlock...

    Chris Harshman (1/20/2009)

    I know you help many people on these boards, but this kind of outburst really wasn't called for. Yes the original poster mis-titled their posting, but...

    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

    January 20, 2009 at 1:10 pm

    #929928

  • RE: SA password lost

    S Hodkinson (1/20/2009)

    I shall leave the developer to the attentions of senior management.

    😀

    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

    January 20, 2009 at 6:56 am

    #929707

  • RE: create view problem

    pat (1/19/2009)

    it is only numbers and integer it does not contains text!!

    numbers from 1 to atleast 55000

    Thanks

    Jeff's not asking about the col1 column. Are there any other columns in the...

    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

    January 20, 2009 at 6:30 am

    #929684

  • RE: Removing orphaned mdf and ldf files ?

    Check the permissions on the file. Sometimes when you detach a database file, it looses all permissions. No idea why. Take ownership and then add permissions for the administrators back.

    If...

    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

    January 20, 2009 at 6:25 am

    #929680

  • RE: SQL Server Architecture

    You forgot one. http://www.sqlskills.com/blogs/paul/

    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

    January 20, 2009 at 6:12 am

    #929664

  • RE: Opening & Closing Stock Problem

    tevers (1/19/2009)

    So that's how outsourcing works!! The project goes to India and someone posts it as a question and then sends the answer back.

    :hehe: 😀 :w00t:

    Thanks. That...

    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

    January 20, 2009 at 6:10 am

    #929662

  • RE: add new conditions to a query

    Load it up in management studio or query analyser. You can't debug SQL properly from a web application

    My guess, and this is just a guess, is that the variable you're...

    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

    January 20, 2009 at 5:35 am

    #929630

  • RE: add new conditions to a query

    mathewspsimon (1/20/2009)

    Hi Gail,

    I am not too sure how I can do that.

    How you can do what?

    Only thing I see is it give the first part of the sql which shows...

    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

    January 20, 2009 at 5:28 am

    #929624

  • RE: SQL Server Architecture

    What, specifically, are you looking for?

    If you want info on the storage engine, Inside SQL Server 2005: The Storage Engine is full of information. There's some stuff on the query...

    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

    January 20, 2009 at 5:25 am

    #929623

  • RE: add new conditions to a query

    mathewspsimon (1/20/2009)

    But this gives error.

    And the error it gives would be ... ?

    If it's a syntax error, print the string before you try to execute it. It's usually easy to...

    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

    January 20, 2009 at 4:58 am

    #929609

  • RE: SA password lost

    Can you try logging on the the machine with an account that's a windows administrator, then try to connect to SQL with windows authentication. Providing this is not on Vista/Server...

    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

    January 20, 2009 at 4:55 am

    #929607

  • RE: Database Reindex Fragmentation still the same ?

    I'm guessing that the table in question is very small?

    That's normal for a small table. Anything under about 1000 pages, you don't need to worry about fragmentation

    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

    January 20, 2009 at 4:53 am

    #929604

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/19/2009)

    GilaMonster (1/19/2009)

    🙂 and I'm in the middle of writing a blog rant titled "Bad Advice". It's funny when lots of people write on similar topics at once.

    Maybe 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

    January 20, 2009 at 1:28 am

    #929531

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/19/2009)

    My classic typo that gets past the spell checker is when I mess up "does not". Can anyone guess what my typo is?

    I keep mixing 'or' 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

    January 20, 2009 at 1:21 am

    #929530

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/19/2009)

    Jack Corbett (1/19/2009)

    Here's a good blog post about people just implementing solutions form the internet or forums without caring why:

    http://www.straightpathsql.com/blog/2009/1/18/empirical-evidence.html

    I found this on a tweet by Jonathan Kehayias.

    How...

    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

    January 19, 2009 at 3:37 pm

    #929410

Viewing 15 posts - 41,551 through 41,565 (of 49,552 total)