Forum Replies Created

Viewing 15 posts - 29,566 through 29,580 (of 49,552 total)

  • RE: Date Difference Between to dates

    Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    November 3, 2010 at 5:47 am

    #1245929

  • RE: DeadLock

    1222 is better. 1204 is the older traceflag, less info and harder to read/interpret.

    Profiler - select the deadlock graph event. i think you might need the binarydata column for 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

    November 3, 2010 at 5:47 am

    #1245928

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/3/2010)

    Just sent out a beg on twitter too. I think we can put you over the top if we keep pushing. I'd just like to win my category...

    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

    November 3, 2010 at 5:45 am

    #1245926

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (11/3/2010)

    I'm not suggesting anyone to cheat, but the voting system relies on browser cookies to determine if a vote was placed... :Whistling:

    and I have 2 computers and 3...

    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

    November 3, 2010 at 5:34 am

    #1245922

  • RE: Are the posted questions getting worse?

    BrainDonor (11/3/2010)

    I wouldn't say that. There's still a week of voting and the down votes make changes happen quick. Someone can vote up another guy and vote me down 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

    November 3, 2010 at 4:38 am

    #1245905

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/3/2010)

    Just got me a Dev copy of R2 and am uninstalling the regular 2k8 eval copy from my laptop now. Gonna play, gonna play.

    I'm debating on getting...

    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

    November 3, 2010 at 4:34 am

    #1245899

  • RE: How to find LSN numbers in Log shipping

    Which LSNs? What are you trying to do/solve?

    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

    November 3, 2010 at 2:32 am

    #1245873

  • RE: Error Performing SQL Shrink Log File

    Sorry to ruin your day, but it may not solved, just fixed for now. You've marked all current transactions as replicated, but any new transactions may still get marked as...

    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

    November 3, 2010 at 2:30 am

    #1245871

  • RE: SQL 2008 R2 RTM

    lorisj33 (11/2/2010)

    Can someone tell me when SP1 for 2008 R2 will be released yet?

    There's been absolutely no mention of a date for a service pack.

    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

    November 2, 2010 at 3:02 pm

    #1245766

  • RE: Nonclustered Index on Temp Table

    Correct. Index names only have to be unique within a table, while constraint names have to be unique in the DB

    CREATE TABLE #t1 (id int)

    CREATE TABLE #t2 (id int)

    CREATE INDEX...

    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

    November 2, 2010 at 12:27 pm

    #1245633

  • RE: Nonclustered Index on Temp Table

    Goldie Lesser (11/2/2010)

    The problem is that when I put this script inside a stored procedure, and the stored procedure gets called by two users at once, I get the error...

    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

    November 2, 2010 at 12:11 pm

    #1245622

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/2/2010)

    GilaMonster (11/2/2010)

    WayneS (11/2/2010)

    Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?

    8000 characters for a date? I could store an...

    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

    November 2, 2010 at 11:37 am

    #1245587

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/2/2010)

    For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three...

    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

    November 2, 2010 at 11:33 am

    #1245579

  • RE: Query does not return data

    What does this return?

    SELECT TOP (100) DISTINCT WrittenDate FROM ABCD

    where (ColA like '%AB CD EF GH%' or ColA like 'DE FD FG GH%')

    and ABCD.ColB='5A'

    btw, you have missing brackets 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

    November 2, 2010 at 11:29 am

    #1245576

  • RE: Are the posted questions getting worse?

    WayneS (11/2/2010)

    Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?

    8000 characters for a date? I could store an entire calendar 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

    November 2, 2010 at 11:28 am

    #1245574

Viewing 15 posts - 29,566 through 29,580 (of 49,552 total)