Forum Replies Created

Viewing 15 posts - 40,846 through 40,860 (of 49,552 total)

  • RE: About Replication error

    Sounds like you have data corruption. Please run the following in the database 'ERP'

    DBCC CHECKDB ('ERP') WITH NO_INFOMSGS, ALL_ERRORMSGS

    Do you have any idea when this started?

    Do you have any backups...

    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

    February 21, 2009 at 12:35 pm

    #948203

  • RE: Replication Error sp_MSupd_tblxyz

    What script changes?

    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

    February 21, 2009 at 12:32 pm

    #948202

  • RE: Replica error

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic662081-5-1.aspx

    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

    February 21, 2009 at 12:31 pm

    #948200

  • RE: Surrogate clustered index to guarantee "sequentiality"

    allmhuran (2/21/2009)

    As a contrived example, let's say I have a table containing entries made by users. A user can't make two entries at the same time, so I have a...

    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

    February 21, 2009 at 12:28 pm

    #948198

  • RE: Surrogate clustered index to guarantee "sequentiality"

    The other point to consider is that the clustered index key, as it is the row's 'identifier' will be in every single nonclustered index. So, by choosing a wide clustering...

    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

    February 21, 2009 at 12:16 pm

    #948195

  • RE: Are the posted questions getting worse?

    RBarryYoung (2/21/2009)

    One thing that I would really like to see, is better capabilities for managing, organizing or even just finding forum posts, even just our own previous posts. Great...

    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

    February 21, 2009 at 11:09 am

    #948187

  • RE: New Server: Logins First ? or Restore DB First ?

    Look up "Orphaned users" in Books Online

    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

    February 21, 2009 at 11:06 am

    #948186

  • RE: New Server: Logins First ? or Restore DB First ?

    homebrew01 (2/21/2009)

    If I'm moving databases from a 2000 server to a new 2005 server, should I restore the databases, then use sp_help_revlogin to script & import the logins ? ...

    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

    February 21, 2009 at 10:00 am

    #948178

  • RE: Are the posted questions getting worse?

    RBarryYoung (2/21/2009)

    Good idea, Gail. A "Slow SQL Server" is really a different problem from a "Slow Query".

    I'm thinking of the "Slow Query" scenario here.

    You know my checklist: 1) use...

    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

    February 21, 2009 at 8:04 am

    #948164

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (2/21/2009)

    It's a good idea... but how will that solve the problem of poeple just asking a question without doing research or even wondering hwo to ask the question 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

    February 21, 2009 at 8:02 am

    #948163

  • RE: Are the posted questions getting worse?

    Kit G (2/21/2009)

    I got hooked in high school, played in college and have kept it up sporatically afterwards. And while I can't say that I lost any days... I...

    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

    February 21, 2009 at 7:41 am

    #948157

  • RE: Are the posted questions getting worse?

    After yet another case of someone just posting a query and asking why it was slow (If I could tell, I'd have some really, really happy clients), I'm contemplating writing...

    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

    February 21, 2009 at 7:39 am

    #948156

  • RE: Why this Function is Slow?!

    peace2007 (2/21/2009)

    I've found out that each query that calls this function is very slow. I'd like to know why this function is so slow.

    Execution plan?

    Table definitions and index definitions?

    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

    February 21, 2009 at 7:30 am

    #948152

  • RE: Large Log from Status 2 Files

    Richard (2/21/2009)

    This works fine apart from one database, which fills the log with status 2 files.

    Status 2 files? Not sure what you mean. Clarification please?

    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

    February 21, 2009 at 7:29 am

    #948151

  • RE: Implicit conversion from data type sql_variant to varchar is not allowed. Use the CONVERT function to run this query.

    susaabraham (2/21/2009)

    You have mentioned about adding the type to the hybridDictionary. Can you please help us to do that....

    do you have any sample with you

    No samples, and C# is 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

    February 21, 2009 at 4:34 am

    #948139

Viewing 15 posts - 40,846 through 40,860 (of 49,552 total)