Forum Replies Created

Viewing 15 posts - 5,716 through 5,730 (of 7,484 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (7/29/2011)

    I do very little productive on the phone. It's great for shopping lists, much reduces the chance I'll write a list and leave it at home. Twitter on the...

    July 29, 2011 at 1:49 pm

    #1361103

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/29/2011)

    Interesting rant here: http://www.insanit.net/technology/smartphone-rants-3-what-do-i-want-a-real-windows-smartphone-when-do-i-want-it-now/

    Anyone else see the need/value here? I'm struggling to see if this is something that has value.

    Give me a phone with 8GB...

    July 29, 2011 at 11:23 am

    #1360971

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/29/2011)

    Gosh... has anyone ever heard of a good reason to have two identically named SQL Server instances in the same Domain? My gut says there isn't one...

    July 29, 2011 at 11:13 am

    #1360960

  • RE: Linked Server to DB2

    Koen Verbeeck (7/29/2011)

    Oh for f*ck's sake! (excuse my language)

    I have found the issue.

    It's a combination of two things:

    First of all, the driver needs to be executed out of process. So...

    July 29, 2011 at 10:50 am

    #1360939

  • RE: Max degree of parallelism

    SQLkiwi (7/29/2011)

    More reading for you, directly on CXPACKET, and why it doesn't matter:

    Of which only the third one really matters??

    July 29, 2011 at 10:45 am

    #1360935

  • RE: Third Normal Form

    dogramone (7/28/2011)

    Thanks for these articles Tom. I have ensure the application developers here are reading all of them. Of course the DBA's already get it but like a...

    July 28, 2011 at 6:12 pm

    #1360513

  • RE: Third Normal Form

    john.rees-894283 (7/28/2011)

    Hi Tom,

    I was also confused about whether the 3NF example was in 2NF or not.

    I had just submitted a really long question, but then saw your reply to James:

    There's...

    July 28, 2011 at 6:10 pm

    #1360511

  • RE: Unicode Compression

    Nice easy question. Thanks.

    I wonder when unicode compression for in-page nvarchar(MAX) will happen - if ever.

    July 28, 2011 at 5:44 pm

    #1360506

  • RE: Third Normal Form

    James Goodwin (7/28/2011)

    The difference between 2NF and 3NF is that 2NF does not permit any non-prime attribute to have a dependency on something which is a proper subset of a...

    July 28, 2011 at 2:42 pm

    #1360463

  • RE: Third Normal Form

    olsonea (7/28/2011)

    When I was studying Relational Database Concepts in college, there was a catchy mnemonic for 3NF: "The key, the whole key, and nothing but the key, so help me...

    July 28, 2011 at 12:05 pm

    #1360386

  • RE: Third Normal Form

    Michael.Beeby (7/28/2011)

    NB: 40 Tree Rd became 30 Tree Rd at some point.

    Ouch! I will try to get that fixed. Thanks for pointing it out.

    edit (later): Steve has corrected...

    July 28, 2011 at 12:02 pm

    #1360384

  • RE: Third Normal Form

    roger.plowman (7/28/2011)

    Due to the extreme flexibility requirements of our reporting system users need at least a nodding acquaintence with the database schema--primarily how specific data can be found in specific...

    July 28, 2011 at 11:55 am

    #1360382

  • RE: Third Normal Form

    James Goodwin (7/28/2011)

    Tom,

    Thanks for the series, it has been very interesting thus far.

    However, I think more distinction needs to be made between 2NF and 3NF. The example seems to...

    July 28, 2011 at 11:46 am

    #1360375

  • RE: Linked Server to DB2

    Koen Verbeeck (7/28/2011)

    edit: the connection string used in the script is exactly the same as the one used in SSIS. Which works...

    But there's a glaring syntax error connection string in...

    July 28, 2011 at 3:51 am

    #1359892

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (7/27/2011)

    SQLRNNR (7/27/2011)

    Chad Crawford (7/27/2011)

    Useless post just to make 2,285

    Sorry - I thought I saw the bandwagon start up, and I could use a lift.

    Useless post to make umm,...

    July 27, 2011 at 5:09 pm

    #1359747

Viewing 15 posts - 5,716 through 5,730 (of 7,484 total)