Forum Replies Created

Viewing 15 posts - 2,116 through 2,130 (of 7,484 total)

  • RE: how do i allow only specific ip address to connect to my sql server

    Ville-Pekka Vahteala (10/9/2014)

    Typical setup for fw is that you have first allowed rules and then deny all

    1. Allow from scope (allowed IPs) to ports 1434 and 1433 TCP and UDP...

    October 9, 2014 at 6:13 pm

    #1751474

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (10/9/2014)

    GilaMonster (10/9/2014)

    TomThomson (10/8/2014)

    I wish e718 had been available when I was younger; but I think http://www.thinkgeek.com/product/f3cd/ would have been even better.

    I think my sysadmin would love that one.

    Talking...

    October 9, 2014 at 5:54 pm

    #1751472

  • RE: Today's Random Word!

    Ed Wagner (10/9/2014)

    Sean Lange (10/8/2014)

    Ed Wagner (10/8/2014)

    djj (10/8/2014)

    Ed Wagner (10/8/2014)

    djj (10/8/2014)

    SQLRNNR (10/8/2014)

    Tang

    Space

    Star Trek

    Frontier

    Enterprise

    Edition

    Expensive

    Overpriced

    October 9, 2014 at 5:49 pm

    #1751471

  • RE: Transactions

    patrik.ljunggren (10/9/2014)

    There are no one completely correct answer.

    A1 are the most correct.

    If the answer hade been "The insert succeeds and the update fails BUT when are both rolled back".

    Have I...

    October 9, 2014 at 8:36 am

    #1751319

  • RE: Are the posted questions getting worse?

    GilaMonster (10/8/2014)

    One of the managers complained this morning that, as far as he can tell, most of my wardrobe is made up of geeky t-shirts. I'm not sure I see...

    October 8, 2014 at 8:02 pm

    #1751133

  • RE: Today's Random Word!

    Sean Lange (10/8/2014)

    Ed Wagner (10/8/2014)

    djj (10/8/2014)

    Ed Wagner (10/8/2014)

    crookj (10/8/2014)

    Sean Lange (10/7/2014)

    SQLRNNR (10/7/2014)

    sprite

    gremlin

    Pixie

    Dust

    Devil

    Tornado

    Vortex

    SpySat

    October 8, 2014 at 10:44 am

    #1751057

  • RE: APPLY

    Meow Now (10/8/2014)

    Surely it's reasonable for it to not to mean what it doesn't say? ...

    I find this statement ironic since you are stating exactly what it's doing. It...

    October 8, 2014 at 10:28 am

    #1751051

  • RE: APPLY

    jkoppin (10/8/2014)

    In my opinion communication is the hardest part about IT because of things like this, where it is obvious to one person, and not to another

    I agree with...

    October 8, 2014 at 10:06 am

    #1751047

  • RE: Are the posted questions getting worse?

    Ed Wagner (10/7/2014)

    Sean Lange (10/7/2014)

    Koen Verbeeck (10/7/2014)

    As if regular spam wasn't annoying enough, one particalar user is now "spamming" the recent posts view with QotD threads...

    That has been going on...

    October 8, 2014 at 9:01 am

    #1751016

  • RE: Columnstore changes

    Mighty (10/7/2014)

    TomThomson (10/7/2014)

    marsigme (10/7/2014)

    Got tripped up with this note in the Data Compression article <http://msdn.microsoft.com/en-us/library/cc280449.aspx&gt;.

    To add archival compression, use ALTER TABLE (Transact-SQL) or ALTER INDEX (Transact-SQL) with the REBUILD option...

    October 8, 2014 at 8:37 am

    #1751000

  • RE: APPLY

    Brian.Klinect (10/8/2014)

    Why was an apply used and not a left join? Is there a reason beyond just needing an example?

    Given that most SQL developers appear to consider APPLY as...

    October 8, 2014 at 7:54 am

    #1750978

  • RE: APPLY

    Meow Now (10/8/2014)

    While I understand what both APPLYs do, I believe I misunderstood the question. I didn't realize "Which type of apply will return the IT department for this query?"...

    October 8, 2014 at 7:44 am

    #1750972

  • RE: Today's Random Word!

    whereisSQL? (10/7/2014)

    Ed Wagner (10/7/2014)

    crookj (10/7/2014)

    Ed Wagner (10/7/2014)

    BWFC (10/7/2014)

    Ed Wagner (10/7/2014)

    djj (10/7/2014)

    Ed Wagner (10/6/2014)

    whereisSQL? (10/6/2014)

    Sean Lange (10/6/2014)

    SQLRNNR (10/6/2014)

    geoduck

    Yummy!!!

    Delicious

    Taste

    Bud

    Spring

    Pogo

    Jump

    Rope

    Hang

    Tight

    Wad

    October 7, 2014 at 7:17 am

    #1750572

  • RE: Columnstore changes

    marsigme (10/7/2014)

    Got tripped up with this note in the Data Compression article <http://msdn.microsoft.com/en-us/library/cc280449.aspx&gt;.

    To add archival compression, use ALTER TABLE (Transact-SQL) or ALTER INDEX (Transact-SQL) with the REBUILD option and DATA...

    October 7, 2014 at 6:20 am

    #1750539

  • RE: THROW defaults

    Nice question. But the answer turned up in comments on last weeks raiserror question, so it was a bit easy for anyone who had read that.

    October 6, 2014 at 5:30 am

    #1750266

Viewing 15 posts - 2,116 through 2,130 (of 7,484 total)