Forum Replies Created

Viewing 15 posts - 28,156 through 28,170 (of 49,552 total)

  • RE: SQL REPLICATION

    Open SQL Books online (the help file that comes with SQL Server), select the content tab in the left pane, expand out SQL 2005, click on Replication. Start reading.

    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 26, 2011 at 1:00 am

    #1278318

  • RE: DBCCC SHRINKFILE

    If there's a disaster (drive fails, server blows up, server room goes up in flames, etc), how much data loss is considered 'acceptable' by business? Normally measured in minutes, 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 26, 2011 at 12:54 am

    #1278317

  • RE: Database in Suspect Mode

    scorpianprince (1/25/2011)

    So if one of my log file is missing then the database goes into the suspect mode.

    No, it won't. If the log file is missing, SQL will either recreate...

    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 26, 2011 at 12:53 am

    #1278316

  • RE: DBCCC SHRINKFILE

    Daily is not enough for transaction logs. At that rate you may as well use simple recovery. Hourly, every 30 min or every 15 are far more reasonable.

    In the case...

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

    #1278289

  • RE: How to remove all keys (including indexes) in a database?

    What exactly do you want to remove?

    Primary keys?

    Foreign keys?

    Unique Constraints?

    All indexes?

    And why?

    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 25, 2011 at 3:18 pm

    #1278218

  • RE: Perf Mon for a beginner

    Perfmon records counter values, values for certain measurements. Profiler captures complete events from SQL 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 25, 2011 at 3:02 pm

    #1278213

  • RE: Automated Trigger To Require a WHERE Clause

    No. Triggers run within the transaction (explicit or implicit) that triggered them.

    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 25, 2011 at 12:45 pm

    #1278119

  • RE: Is there a way to be sure your union queries do not contain dups?

    Union concatenates the two resultsets then eliminates duplicates. Union All just concatenates the two resultsets.

    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 25, 2011 at 12:45 pm

    #1278117

  • RE: Are the posted questions getting worse?

    LutzM (1/25/2011)

    GilaMonster (1/25/2011)

    North. About 9000km.

    Not sure, just thinking, maybe, will see, depends....

    Tunis? Algier? Edit: at lest when using Bing maps...

    Bing maps are off then. It's just under 7500km from Johannesburg...

    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 25, 2011 at 12:41 pm

    #1278112

  • RE: Are the posted questions getting worse?

    GSquared (1/25/2011)

    Better bet, if the person you're dealing with is in the "reject data" personality band, would be "It'll take a couple of days to figure out how long 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 25, 2011 at 12:36 pm

    #1278109

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    Toby White (1/25/2011)

    Great artical Gail! Your commentary about intersections and the factors around whether to place the most selective column in the leading edge of the index are very practical...

    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 25, 2011 at 12:27 pm

    #1278102

  • RE: Are the posted questions getting worse?

    GSquared (1/25/2011)

    Let's see ... Africa is just about 8,000 km on it's longest north-south dimension, and Jo'Burg is 28 degrees E, so that would put you in ... Czech Republic?...

    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 25, 2011 at 12:20 pm

    #1278097

  • RE: Are the posted questions getting worse?

    GSquared (1/25/2011)

    My usual estimate for that kind of thing is "less than eternity, but longer than breakfast". By that time, I usually don't care if I offend someone, 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 25, 2011 at 12:08 pm

    #1278088

  • RE: Are the posted questions getting worse?

    GSquared (1/25/2011)

    GilaMonster (1/25/2011)

    Craig Farrell (1/25/2011)

    I've got it pretty good at the moment...

    Wish I could say the same, as I'm sure my near-constant rants (whining) has implied. Starting to think about...

    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 25, 2011 at 11:59 am

    #1278077

  • RE: Are the posted questions getting worse?

    Craig Farrell (1/25/2011)

    Uh. Oh. The Katana is being sharpened.

    No, not in that direction

    How'd the 'morning' vendor meeting yesterday go in your afternoon?

    Let's see, a discussion with the business owner...

    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 25, 2011 at 11:56 am

    #1278071

Viewing 15 posts - 28,156 through 28,170 (of 49,552 total)