Forum Replies Created

Viewing 15 posts - 196 through 210 (of 476 total)

  • RE: Any benefit in a covering non-clustered index on clustered index columns?

    Thanks Gail. Sounds like more-trouble-than-it-is-worth 🙂

    In the main all - but I ought to make a Belt & Braces test to be sure ... - my Lookup Tables are pretty...

    October 8, 2015 at 5:00 am

    #1832253

  • RE: Commercial Software with All Tables as Heaps and Terrible Performance

    robinwilson (10/7/2015)

    Jeff Moden (10/5/2015)

    The final 42 million reads is pretty bad, as well, even for a batch run. That's like doing a table scan from a 344GB table.

    I think...

    October 8, 2015 at 4:09 am

    #1832241

  • RE: Backup job & Integrity checks are failing

    I've written my own (started back in the last century when open source code was not readily available for such things ...) but the BACKUP aspect of it was a...

    September 30, 2015 at 12:46 am

    #1830341

  • RE: How to avoid using scalar User Defined Functions?

    Jeff Moden (9/29/2015)

    Don't do it slow when you know how to do it fast.

    +1000 (to quote your good self 😉 )

    I don't want to have to revisit the code, once...

    September 30, 2015 at 12:41 am

    #1830338

  • RE: Logging Tables

    Wayne West (9/29/2015)

    I use a trigger that I modified from Pop Rivett's column (https://www.simple-talk.com/content/article.aspx?article=301#forum from 2006. Put the trigger on any table to be audited and you get one...

    September 29, 2015 at 8:05 pm

    #1830312

  • RE: How to migrate huge databases ?

    Jacob Wilkins (9/29/2015)

    Yes, you can mirror to a newer version of SQL Server.

    Thanks. Is there still the delay when failing over whilst SQL upgrades everything to the newer version (as...

    September 29, 2015 at 7:40 pm

    #1830309

  • RE: Getting rid of SELECT *

    I did some work for a company that used SELECT *.

    Their telesales department used the browser base APP extensively and the same DB was used by their end users across...

    September 29, 2015 at 7:35 pm

    #1830308

  • RE: Choosing values

    Koen Verbeeck (9/24/2015)

    I like IIF for replacing very simple CASE statements. Looks a bit better in my opinion and it's shorter.

    I've always considered IIF (in Excel etc.) to be a...

    September 29, 2015 at 6:11 am

    #1830113

  • RE: Backup log with norecovery

    Gail suggested this to me a few days ago. I now think it is preferable to

    ALTER DATABASE MyDatabaseName SET OFFLINE WITH ROLLBACK IMMEDIATE

    which I currently use (before restoring the DB)

    and...

    September 29, 2015 at 6:05 am

    #1830112

  • RE: How to avoid using scalar User Defined Functions?

    Kim Crosser (9/28/2015)

    The real question is whether the UDFs are causing any performance problems. 10x sounds horrible, but in your system does that result in a query that runs...

    September 29, 2015 at 5:57 am

    #1830109

  • RE: No Time for Testing

    P.S.

    @intDebug=01

    is laziness! Put cursor at end of line and press BACKSPACE to remote the "1", or same again to append a "1" (to the zero).

    All our procedures have final parameter...

    September 29, 2015 at 4:55 am

    #1830099

  • RE: No Time for Testing

    Jeff Moden (9/28/2015)

    like I did with DelimitedSplit8k, the tests are frequently saved in the header of the code or as inline comments if multiple sections are required.

    We put them at...

    September 29, 2015 at 4:53 am

    #1830098

  • RE: Update clause

    Just in case of interest I write UPDATEs with an Alias so that we can test them with minimal code changes

    UPDATE U

    -- [highlight="#ffff11"]SELECT *

    -- SELECT COUNT(*)

    FROM S_Office AS U

    WHERE rep_name...

    September 29, 2015 at 4:41 am

    #1830097

  • RE: Many-to-Many Sanity Check

    Not sure if this is worth mentioning ... but ... 🙂

    identity(1,1)

    We start IDENTITY at a higher number, usually the order of magnitude that we expect the row count to become...

    September 29, 2015 at 4:36 am

    #1830095

  • RE: Temp Table's Primary Key Default

    rchantler (9/28/2015)

    CREATE CLUSTERED INDEX IDX_hidvals ON #hidvals(hid)

    That is not declared as UNIQUE, so not quite the same thing as a PRIMARY KEY's Clustered Index (SQL will add a tie-break value...

    September 29, 2015 at 4:29 am

    #1830090

Viewing 15 posts - 196 through 210 (of 476 total)