Forum Replies Created

Viewing 15 posts - 5,476 through 5,490 (of 49,552 total)

  • RE: Tuning the query for performance

    Can you post the execution plan please, not a picture of part of it?

    Index and table definitions would also be useful.

    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

    June 26, 2015 at 9:16 am

    #1808440

  • RE: State County City Problem

    Please note: 7 year old thread.

    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

    June 26, 2015 at 6:13 am

    #1808368

  • RE: Exit Lines

    Labour law where I live mandates 30 day notice period for resignations, so it's more a case of notify management, find out whether they require you to work the notice...

    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

    June 26, 2015 at 6:00 am

    #1808363

  • RE: Are the posted questions getting worse?

    I've gone partially kindle (well, kindle for the iPad), partially paper for books. If I've started a series in paper, I want the entire series that way. If I've started...

    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

    June 26, 2015 at 4:03 am

    #1808347

  • RE: To trigger or not to trigger

    Query Shepherd (6/26/2015)

    how can i explain my Boss that triggers are evil und only usefull for auditing purposes.

    Since they're not automatically evil and are useful for a lot more than...

    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

    June 26, 2015 at 3:42 am

    #1808344

  • RE: query about nulls

    sgmunson (6/25/2015)

    but we all use DATEADD() or DATEDIFF() or GETDATE() in WHERE clauses all the time, and no one raises their hand and says "not a good idea" 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

    June 26, 2015 at 3:36 am

    #1808341

  • RE: Logic to rebuild only the clustered indexes, skipping to rebuild non clustered indexes in the same table.

    SQL-DBA-01 (6/25/2015)

    Even I too knew but elder folks like to argue on the matter, so now I will paste the links for them to know.

    Excuse me?

    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

    June 26, 2015 at 2:33 am

    #1808330

  • RE: Logic to rebuild only the clustered indexes, skipping to rebuild non clustered indexes in the same table.

    SQL-DBA-01 (6/25/2015)

    ignoring the non clustered indexes as those are taken care of by the Clustered indexes.

    No they're not. Rebuilding the clustered index doesn't affect nonclustered indexes in any way.

    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

    June 25, 2015 at 4:11 pm

    #1808273

  • RE: Are the posted questions getting worse?

    SQLBill (6/25/2015)

    For me, he was building up this world/environment where the ruler was killed, a split happened, and fighting was going on to determine the 'rightful' ruler. I 'knew'...

    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

    June 25, 2015 at 3:59 pm

    #1808271

  • RE: Are the posted questions getting worse?

    Bookshelf 2

    There's a lot of empty spaces because of the recent cleanup and trip to the 2nd hand bookshop. Still piles of books in my bedroom which need to be...

    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

    June 25, 2015 at 1:09 pm

    #1808215

  • RE: Are the posted questions getting worse?

    As promised, the bookshelves.

    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

    June 25, 2015 at 1:05 pm

    #1808212

  • RE: ldf shrink issue

    jralston88 (6/25/2015)

    For example - if you had a vlf status 2 at the very of your answerset, would you be able to shrink the ldf at all -...

    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

    June 25, 2015 at 1:05 pm

    #1808211

  • RE: Msg 5244: Repair statement not processed

    Firstly, repair_rebuild is not going to do a damn thing.

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (EDW_ShoreTel).

    and that's the same for both DBs

    Try repair_allow_data_loss...

    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

    June 25, 2015 at 12:44 pm

    #1808203

  • RE: ALTER database to modify the log file

    Guras (6/25/2015)

    But the data file is set to unlimited growth so why is it saying full?

    Possibly because it couldn't grow fast enough, possibly because there isn't space on the disk,...

    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

    June 25, 2015 at 10:35 am

    #1808153

  • RE: ALTER database to modify the log file

    It'll be 2TB, not 2GB and that's the max size that a transaction log file can reach, so it's the same as unlimited.

    btw, the error was telling you the data...

    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

    June 25, 2015 at 10:03 am

    #1808136

Viewing 15 posts - 5,476 through 5,490 (of 49,552 total)