Forum Replies Created

Viewing 15 posts - 2,146 through 2,160 (of 9,399 total)

  • RE: Do I need those multiple NON UNIQUE indices on my table?

    BOR15K (12/7/2016)

    Hello,

    Need your advise on the above topic, please. Let assume I have an Invoice Lines Table invoice_lines as below, with a unique index on its most common columns:

    invoice_number and...

    December 7, 2016 at 6:04 am

    #1916487

  • RE: Password Policy

    Stewart "Arturius" Campbell (12/7/2016)

    Nice one, thanks Steve

    Haven't used sql logins for a while, preferring windows authentication.

    I also prefer Windows authentication, but must run mixed. I use this all the...

    December 7, 2016 at 5:47 am

    #1916482

  • RE: Are the posted questions getting worse?

    Lynn Pettis (12/6/2016)

    Sean Lange (12/6/2016)

    I sure wish JC would get off his high horse once in awhile. His constant diatribe about portability is a joke. Then he berates posters for...

    December 7, 2016 at 5:45 am

    #1916479

  • RE: Today's Random Word!

    djj (12/7/2016)

    Ed Wagner (12/6/2016)

    Manic Star (12/6/2016)

    whereisSQL? (12/6/2016)

    Revenant (12/6/2016)

    Iceland

    IceCream

    Vanilla

    Sugar

    Brown

    Molasses

    December 7, 2016 at 5:40 am

    #1916477

  • RE: Today's Random Word!

    Manic Star (12/6/2016)

    whereisSQL? (12/6/2016)

    Revenant (12/6/2016)

    Iceland

    IceCream

    Vanilla

    Sugar

    December 6, 2016 at 2:54 pm

    #1916376

  • RE: Are the posted questions getting worse?

    Sean Lange (12/6/2016)

    Time for the annual voyage to a destination for my wife's holiday party. They really go all out!!! They always fly the employees to a location and pay...

    December 6, 2016 at 12:46 pm

    #1916346

  • RE: How to improve performance, when using LIKE (or any other alternative?)

    Eirikur's idea is a really good one. The only thing I'd add is that if you're going to define a column to store the reverse of the string, I'd...

    December 6, 2016 at 10:14 am

    #1916301

  • RE: Extract values from a string

    If you really do need to do this on a MAX data type, performance is going to suffer. It's best to do it on a Varchar(8000) instead. You...

    December 6, 2016 at 10:11 am

    #1916300

  • RE: Deny DML on a table

    Thom A (12/6/2016)

    Adi Cohn-120898 (12/6/2016)

    Thom A (12/6/2016)

    Further Question, why ARE they a member of the db_datareader and db_datawriter roles when they are a member of db_owner role? These roles serve...

    December 6, 2016 at 10:06 am

    #1916297

  • RE: Today's Random Word!

    Ray K (12/6/2016)

    Brandie Tarvin (12/6/2016)

    djj (12/6/2016)

    Ed Wagner (12/6/2016)

    Manic Star (12/6/2016)

    djj (12/6/2016)

    Brandie Tarvin (12/6/2016)

    Kaye Cahs (12/6/2016)

    Grumpy DBA (12/6/2016)

    Ed Wagner (12/6/2016)

    Cream

    Cookies

    Milk

    Santa

    Baby

    Buggy

    Walk

    Amble

    Meander

    Wander

    Lost

    December 6, 2016 at 9:47 am

    #1916289

  • RE: Today's Random Word!

    Manic Star (12/6/2016)

    djj (12/6/2016)

    Brandie Tarvin (12/6/2016)

    Kaye Cahs (12/6/2016)

    Grumpy DBA (12/6/2016)

    Ed Wagner (12/6/2016)

    Cream

    Cookies

    Milk

    Santa

    Baby

    Buggy

    Walk

    December 6, 2016 at 7:32 am

    #1916228

  • RE: STRING_ESCAPE

    I think they're doing more like that to allow for future expansion without requiring breaking backward compatibility. Thanks for a question where I learned something new.

    December 6, 2016 at 5:31 am

    #1916187

  • RE: Today's Random Word!

    djj (12/6/2016)

    BWFC (12/6/2016)

    Stuart Davies (12/6/2016)

    Jeff Moden (12/5/2016)

    Alan.B (12/5/2016)

    Luis Cazares (12/5/2016)

    crookj (12/5/2016)

    djj (12/5/2016)

    Lane

    Lois

    Lana

    Turner

    Postman

    Pat

    Butter

    Milk

    Cream

    December 6, 2016 at 5:26 am

    #1916186

  • RE: Today's Random Word!

    Manic Star (12/5/2016)

    crookj (12/5/2016)

    djj (12/5/2016)

    Ed Wagner (12/2/2016)

    DamianC (12/2/2016)

    Ray K (12/2/2016)

    Ed Wagner (12/2/2016)

    aPed001 (12/2/2016)

    ZZartin (12/2/2016)

    Stuart Davies (12/2/2016)

    Ed Wagner (12/2/2016)

    Kaye Cahs (12/2/2016)

    crookj (12/2/2016)

    aPed001 (12/2/2016)

    Conquer

    Overcome

    Surpass

    Win

    Victor

    Doom

    Bethesda

    Hospital

    M*A*S*H

    hawkeye

    Radar

    Scope

    Paint

    (Happy Little) Trees

    Forest

    December 5, 2016 at 8:48 am

    #1916016

  • RE: RAMDisk? Use it for TempDB?

    Jeff Moden (12/3/2016)

    TheSQLGuru (12/3/2016)

    I have to take exception with one thing you said Igor:

    With efficient code (t-sql, EF, Linq, ...) you can do wonders.

    EF, as in Entity Framework, has...

    December 3, 2016 at 12:35 pm

    #1915905

Viewing 15 posts - 2,146 through 2,160 (of 9,399 total)