Forum Replies Created

Viewing 15 posts - 25,066 through 25,080 (of 49,552 total)

  • RE: validate transaction log file.

    What context did you find that statement 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

    July 7, 2011 at 11:24 am

    #1349886

  • RE: Difference between clustered and non clustered index..

    Jayanth_Kurup (7/7/2011)

    However I have one deviation from whats mentioned in the above post , I prefer not to use a index on the date time column because of the size...

    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

    July 7, 2011 at 11:21 am

    #1349883

  • RE: Are the posted questions getting worse?

    Jack Corbett (7/7/2011)

    Regardless of if you are a contractor/consultant or a regular employee, you are responsible for your professional development. So, why aren't we all putting some money away...

    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

    July 7, 2011 at 11:10 am

    #1349866

  • RE: Code Ownership - DBA vs. Developer

    Elliott Whitlow (7/7/2011)

    Once this process was in place for us and the CIO was fully on board. The business was "educated" over time that they were an integral part...

    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

    July 7, 2011 at 10:58 am

    #1349849

  • RE: will any one help

    It's used to get random numbers. It's usually used for data generation for simple tests (like scenarios for blog posts)

    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

    July 7, 2011 at 10:57 am

    #1349848

  • RE: Code Ownership - DBA vs. Developer

    Elliott Whitlow (7/7/2011)

    I was with a large organization that unfortuantely the business analysts were more than happy to throw development under the bus to prevent them from being blamed...

    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

    July 7, 2011 at 10:31 am

    #1349821

  • RE: Deadlock encountered

    Rather use traceflag 1222 on SQL 2005 and above. Much better output.

    There's no information in that deadlock graph as to the statements involved. It's going to be near-impossible to tell...

    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

    July 7, 2011 at 9:58 am

    #1349799

  • RE: A TO Z of Indexing

    Craig Farrell (7/6/2011)

    You know, it IS kind of wierd. Indexing is so central to optimal database performance yet you're right, Gail... there's nothing published as an end to end...

    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

    July 7, 2011 at 9:52 am

    #1349795

  • RE: Oldest non-distributed LSN but No Transactional Replication

    Please post new questions in a new thread and give as much detail as possible.

    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

    July 7, 2011 at 9:50 am

    #1349794

  • RE: What happens to SQL Server when we shut down/Start Windows..?

    matt.newman (7/7/2011)

    My main remark on "outside means" was that the suggestion of pulling a plug or hard shutdown was something I would avoid.

    Sure. That's just common sense with computers. 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

    July 7, 2011 at 9:49 am

    #1349793

  • RE: What happens to SQL Server when we shut down/Start Windows..?

    matt.newman (7/7/2011)

    Killing all power by pulling a plug in the middle of a read, with other failed hardware components... no problems as far as you see it?

    That's not what 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

    July 7, 2011 at 9:08 am

    #1349767

  • RE: What happens to SQL Server when we shut down/Start Windows..?

    matt.newman (7/7/2011)

    Shut down SQL Services first through config manager or command. Better to not risk database corruption in killing the service by outside means.

    That doesn't risk database corruption.

    Dodgy IO subsystems...

    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

    July 7, 2011 at 8:50 am

    #1349756

  • RE: INDEXED View referesh on demand

    Ninja's_RGR'us (7/7/2011)

    GilaMonster (7/7/2011)

    Ninja's_RGR'us (7/7/2011)

    Awesome idea. But why do you need to rebuild just after reenable? Sounds like doing the work twice!

    You re-enable a clustered index (or any 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

    July 7, 2011 at 8:44 am

    #1349752

  • RE: INDEXED View referesh on demand

    Ninja's_RGR'us (7/7/2011)

    Awesome idea. But why do you need to rebuild just after reenable? Sounds like doing the work twice!

    You re-enable a clustered index (or any index infact) by...

    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

    July 7, 2011 at 8:10 am

    #1349732

  • RE: INDEXED View referesh on demand

    Gianluca Sartori (7/7/2011)

    If you don't want to pay for the overhead, you can disable the clustered index on the view and re-enable it with ALTER INDEX REBUILD before running 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

    July 7, 2011 at 7:54 am

    #1349714

Viewing 15 posts - 25,066 through 25,080 (of 49,552 total)