Forum Replies Created

Viewing 15 posts - 91 through 105 (of 340 total)

  • RE: Delete from very large multiple tables

    Lynn Pettis - Monday, February 5, 2018 12:37 PM

    Well, replication throws a wrench in what I would consider unless it is...

    February 6, 2018 at 1:21 pm

    #1978772

  • RE: Index Fill Factor

    patrickmcginnis59 10839 - Tuesday, February 6, 2018 11:18 AM

    I don't agree with the answer.

    Fill factor is available for viewing in the view (?)...

    February 6, 2018 at 1:14 pm

    #1978768

  • RE: Index Fill Factor

    Thanks David , George and others as well for compliments and sharing more related info. I'll definitely share the doc I referenced if I can as I go through my...

    February 6, 2018 at 9:49 am

    #1978734

  • RE: Shrink all user database files

    Not encouraged , unless the downside of this resulting in fragmentation and other stuff put by Jeff , can be dealt with. The lower costs of storage these days make...

    January 21, 2018 at 1:02 pm

    #1976664

  • RE: SQL Server Agent (no email upon job failure)

    Its quite strange that none of the options above have worked for you. In my experience it happened because of multiple recipients in the list but you said you've...

    January 20, 2018 at 1:54 pm

    #1976628

  • RE: does backup and restore use tempdb?

    Jeff Moden - Tuesday, January 9, 2018 4:56 PM

    Careful, now.  The head you hand someone may be your own. 😉

    Million(shall I...

    January 13, 2018 at 12:39 pm

    #1975834

  • RE: Get Index Scan Count

    My apologies ..I tried to edit it but not finding an option anywhere. please replace 70 with ur DB id or NULL or 0 to get the results for all...

    January 11, 2018 at 1:32 pm

    #1975613

  • RE: Database Architect Certification

    Hi qh. I'm MCITP and MCTS 2008 R2 , long ago. Thank you so much for the guidance as per the current options.

    January 11, 2018 at 5:31 am

    #1975478

  • RE: Get Index Scan Count


    Just checked it. Have mentioned on the headline 'Script to get the index scan count and Average Fragmentation(since last restart)' . But yes it should've been in...

    January 9, 2018 at 7:23 am

    #1975072

  • RE: Get Index Scan Count

    Yes Gail. Sue had pointed this too. This is the first script I posted and also no idea how can edit it now. Can u help ?

    January 9, 2018 at 1:39 am

    #1975034

  • RE: Get Index Scan Count

    Thanks Gail. Actually I had put that in brackets. I think I lost it when re-editing for some other words, and then didn't proof-read; Did this in wee hours of...

    January 9, 2018 at 1:26 am

    #1975030

  • RE: Get Index Scan Count

    Sue_H - Monday, January 8, 2018 3:02 PM

    One problem with the script is that it is hard coded to use db_id...

    January 8, 2018 at 5:58 pm

    #1975009

  • RE: Composite Key Assistance

    John524 - Saturday, January 6, 2018 9:46 AM

    Thank you Eirikur
    When you say same order of the composition of the PK, you mean...

    January 8, 2018 at 8:31 am

    #1974899

  • RE: Drop failed for jobs

    Its just like referential integrity between two tables. So deleting the plan is the first step.

    January 8, 2018 at 2:21 am

    #1974860

  • RE: Which is better and Why.?

    I've worked on both over the years but specialist in SQL server last 8 years or so .  SQL server has done really very well and caught up with...

    January 4, 2018 at 8:27 am

    #1974478

Viewing 15 posts - 91 through 105 (of 340 total)