Forum Replies Created

Viewing 15 posts - 26,221 through 26,235 (of 49,552 total)

  • RE: Today's Random Word!

    Daniel Bowlin (5/10/2011)

    Ray K (5/10/2011)

    Brandie Tarvin (5/10/2011)

    WOTD: Hands

    Feet

    Inches

    Metres. (no more of that imperial garbage)

    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

    May 10, 2011 at 7:38 am

    #1322298

  • RE: blocking @rajesh

    Ninja's_RGR'us (5/10/2011)

    Actually it's 10 minutes. I gave him the best link I had, looks like it did the job :-)!

    😀 I didn't check where the link went before replying.

    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

    May 10, 2011 at 7:34 am

    #1322291

  • RE: blocking @rajesh

    rajeshn29.dba (5/10/2011)

    Can any one give reply plzzzzzzzzzzzzzzzzzzz

    Patience. This is a discussion forum, not a chat room. We're all volunteers with our own jobs and own problems. bumping your post 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

    May 10, 2011 at 7:28 am

    #1322283

  • RE: Weird Execution Plan

    Brandie Tarvin (5/10/2011)

    EDIT: Wait a sec. Was the Bookmark Lookup doing a Nested Inner Join behind the scenes in SQL 2000? Did we just not see it?

    Yeah, kinda.

    The (high level)...

    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

    May 10, 2011 at 6:07 am

    #1322228

  • RE: Password login problem to database

    What database engine?

    Php is usually used with MySQL, not SQL Server.

    If it is SQL Server, we're at minimum going to need to see the table structure.

    If it's MySQL, you're more...

    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

    May 10, 2011 at 6:04 am

    #1322226

  • RE: Order of Tables in a Query

    terrykzncs (5/10/2011)

    I know that SQL joins tables from left to right, but in what order should we join tables for the code to be most efficient?

    Any order you like. Unless...

    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

    May 10, 2011 at 5:58 am

    #1322224

  • RE: Integrity check fails yet full & transactional job successful

    Indexed view and the wrong settings for quoted identifier I'm guessing.

    Can you run a manual checkDB, just to be sure the DB is clean?

    DBCC CheckDB(<Database name>) WITH No_INFOMSGS, ALL_ERRORMSGS

    If 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

    May 10, 2011 at 5:49 am

    #1322214

  • RE: Which index will get the prority and why?

    Depends completely 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

    May 10, 2011 at 3:52 am

    #1322176

  • RE: Data Loss

    Unless you had a trace running at the time of the delete, there's no history stored.

    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

    May 10, 2011 at 3:15 am

    #1322167

  • RE: SQL Server 2005

    Go to your favourite search engine. Search for DCM or "Differential Change Map"

    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

    May 10, 2011 at 2:17 am

    #1322145

  • RE: STOREPROC VERY SLOW

    terrykzncs (5/9/2011)

    Like they said before, start with replacing the cursors with set statements. But then replace the temp tables with table variables.

    In general I recommend the other way around. Replace...

    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

    May 9, 2011 at 11:37 pm

    #1322089

  • RE: Select COUNT(ID) vs Select Count(0)

    No. You're thinking of SELECT * - a shorthand for all columns.

    Select * - Return all columns of this resultset.

    Count(*) - Count all rows in this resultset regardless of what...

    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

    May 9, 2011 at 4:40 pm

    #1322023

  • RE: Are the posted questions getting worse?

    Oh my: http://shitmystudentswrite.tumblr.com/

    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

    May 9, 2011 at 4:09 pm

    #1322017

  • RE: Select COUNT(ID) vs Select Count(0)

    Maybe.

    If ID is a nullable column, then count(ID) will be slower than Count(*) or Count(1). If it's not nullable, they are completely equivalent.

    http://sqlinthewild.co.za/index.php/2009/04/14/on-counts/

    Edit: Apologies, I misread the question first time.

    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

    May 9, 2011 at 4:04 pm

    #1322014

  • RE: Weird Execution Plan

    Brandie Tarvin (5/9/2011)

    It's at the last SELECT that things go weird. The book says I should see an Index Seek for the nonclustered index seek and a Key Lookup operator...

    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

    May 9, 2011 at 1:31 pm

    #1321965

Viewing 15 posts - 26,221 through 26,235 (of 49,552 total)