Forum Replies Created

Viewing 15 posts - 28,051 through 28,065 (of 49,552 total)

  • RE: Upgrade from SQL 80 to 100

    Abrar Ahmad_ (1/31/2011)

    The old sql 80 DB was not configured to update/create statistics automatically, that's why one solution in mind is to Create Statistics on all table all columns, 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 31, 2011 at 2:18 am

    #1280289

  • RE: SQL Server Interview Questions And Answers

    p.s. You might want to spend some time validating and expanding the answers to your interview questions. Some are totally wrong, many are so vague as to not be answers.

    eg:...

    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 31, 2011 at 2:16 am

    #1280288

  • RE: SQL Server Interview Questions And Answers

    It's very easy for a good interviewer to tell the difference between someone who's memorised answers and someone who know the topic.

    Don't exaggerate your skills.

    Don't lie to the interviewer

    Don't...

    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 31, 2011 at 2:01 am

    #1280282

  • RE: Upgrade from SQL 80 to 100

    Abrar Ahmad_ (1/31/2011)

    but "There are some cases where queries perform worse on 2008 than on 2000", i may sense sub-query or co-related sub queries u may be pointing out. 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 31, 2011 at 1:41 am

    #1280280

  • RE: database design for social networking site

    What version of SQL?

    For normalisation, have a look at this series: http://michaeljswart.com/?p=1036. Also ask your DBA, he may know database design.

    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 31, 2011 at 12:52 am

    #1280267

  • RE: Foreign Key with Clustered or Non-Clustered index

    Normally you'd start with a nonclustered index on the foreign key columns, then modify if necessary.

    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 31, 2011 at 12:48 am

    #1280266

  • RE: Upgrade from SQL 80 to 100

    Not in general. There are some cases where queries perform worse on 2008 than on 2000, they're generally a small minority and can often be rewritten. Make sure that you...

    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 31, 2011 at 12:44 am

    #1280265

  • RE: SQL Server Index and Performance tuning ETL

    avinash jobanputra (1/30/2011)

    1)We have created a number of indexes to improve the read time of some queries. However these tables then have large inserts going into them. Does...

    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 30, 2011 at 10:37 pm

    #1280247

  • RE: Microsoft SQL Server, Error: 945

    Please note: 4 year old thread.

    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 30, 2011 at 10:25 pm

    #1280244

  • RE: reset sa password

    Make sure SQL Agent is stopped

    Make sure any application that could connect is prevented from doing so

    Make sure no one else is trying to connect

    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 30, 2011 at 10:14 pm

    #1280240

  • RE: reset sa password

    What do you mean 'it doesn't work'?

    What exact steps did you follow? What errors did you get?

    Do you have a sysadmin account other than sa? A windows authentication one?

    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 30, 2011 at 10:01 am

    #1280194

  • RE: Return most recent result or a default

    chris.compton-977504 (1/29/2011)

    OR is the table #T is actually written to disk?

    A glance at the 2005 docs seem to indicate that it could be written to disk, but it is unclear.

    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

    January 29, 2011 at 1:37 pm

    #1280125

  • RE: Index

    Can't see a difference between queries 2 and 3. I can't tell which will run faster, you'll have to do that. Turn Statistics Time on and run them.

    p.s. Why 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 29, 2011 at 1:32 pm

    #1280124

  • RE: T-SQL - Calculate Login Duration

    Errr, why would you prefer a slow and inefficient while loop over a ranking function?

    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 29, 2011 at 12:43 pm

    #1280109

  • RE: Index

    Cost is an estimate, it can be wrong, don't count on it. Usually the best query is the fastest one.

    Post the actual execution plans, not pictures of them, there's lots...

    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 29, 2011 at 7:36 am

    #1280078

Viewing 15 posts - 28,051 through 28,065 (of 49,552 total)