Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 1,414 total)

  • RE: The Platform Problem

    Steve Jones - SSC Editor (5/14/2013)

    patrickmcginnis59 10839 (5/14/2013)

    Lol I despise windows 8 / server 2012. Microsoft has also changed direction with their application programming tools to a stupid degree. Azure...

    May 14, 2013 at 10:08 am

    #1615089

  • RE: The Platform Problem

    chrisn-585491 (5/14/2013)

    As much as I like SQL Server and the folks that support it, I have some qualms about vendor lock in and Microsoft as a whole. With the slap...

    May 14, 2013 at 7:49 am

    #1614997

  • RE: Better Coding, More Savings

    dmbaker (5/13/2013)

    vliet (5/13/2013)

    Developers think row-based. They cannot work with set-based algorithms. Everyone who tells you otherwise hasn't worked together with developers.

    Really? That's a pretty broad brush you're using there. I...

    May 13, 2013 at 9:21 am

    #1614653

  • RE: Date Format Problem with SQL SERVER ENGLISH VERSION

    Maybe give SET DATEFORMAT a try:

    http://msdn.microsoft.com/en-us/library/ms189491.aspx

    May 11, 2013 at 8:33 am

    #1614384

  • RE: Single User Mode

    Welsh Corgi (5/6/2013)

    Thanks Gail.

    If someone has the sole connection I would not be able to kill their session?

    Worst case scenario would resrting the SQL Server Service start?

    If you've set a...

    May 6, 2013 at 2:18 pm

    #1612764

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/5/2013)

    Ninja's_RGR'us (5/5/2013)

    SQLRNNR (5/5/2013)

    GilaMonster (5/5/2013)

    Ninja's_RGR'us (5/4/2013)

    Lynn Pettis (5/4/2013)

    GilaMonster (5/4/2013)

    Err... I don't know what to think

    http://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx

    And as long as he has been around you'd think he'd know this.

    How many situations...

    May 6, 2013 at 5:14 am

    #1612577

  • RE: Most important DBA Skill?

    majorbloodnock (5/1/2013)

    TravisDBA (5/1/2013)

    majorbloodnock (5/1/2013)

    umailedit (4/30/2013)

    Let me take the contrary view here.

    Hypothetical Question: You are about to have a brain aneurysm operated on. Who would you pick?

    1) A brain surgeon with...

    May 1, 2013 at 9:24 am

    #1611600

  • RE: Most important DBA Skill?

    TravisDBA (5/1/2013)

    majorbloodnock (5/1/2013)

    umailedit (4/30/2013)

    Let me take the contrary view here.

    Hypothetical Question: You are about to have a brain aneurysm operated on. Who would you pick?

    1) A brain surgeon with little...

    May 1, 2013 at 9:13 am

    #1611592

  • RE: Creating database,stored procedures from batch file

    JUST FOR FUN!

    Here's a possibility, but its really rube goldberg like, it would probably be easier with actual programming tools like dot.net or powerscript. The included method is probably low...

    April 30, 2013 at 8:56 am

    #1611281

  • RE: Natural Data

    Also, it seems this time that the big tech firms are NOT fighting CISPA, rather they are supporting its passage. I'd sure like to see which big tech firms are...

    April 26, 2013 at 11:34 am

    #1610473

  • RE: Natural Data

    Eric M Russell (4/24/2013)

    I hope it never gets to the point where corporations can claim ownership of gene sequences (whether they be natural or engineered) in our body. That would...

    April 26, 2013 at 11:27 am

    #1610472

  • RE: Complex many to many relationships

    Ganga-236835 (4/26/2013)

    patrickmcginnis59 10839 (4/26/2013)

    This is an interesting case, so I'm guessing that it really depends on how important the functionality of the foreign key constraint is for your needed functionality....

    April 26, 2013 at 8:31 am

    #1610405

  • RE: Complex many to many relationships

    Ganga-236835 (4/26/2013)

    Although I agree in principle that most common scenario regarding phone numbers is that there is one per person, in the system that I am designing that is just...

    April 26, 2013 at 7:46 am

    #1610375

  • RE: Complex many to many relationships

    ChrisM@Work (4/25/2013)

    Ganga-236835 (4/25/2013)

    Well, first they are not many to many then, and second it constrains the software development due to the inability for code reuse.

    This doesn't really address the point...

    April 25, 2013 at 10:40 am

    #1610037

  • RE: Combining two stored procedures to get one result set.

    Just an idea, maybe not the perfect solution but I might change both of these routines like so:

    systemActivities:

    INSERT INTO #RESULTS

    (

    ROW_SOURCE,

    dtuStart,

    total

    )

    SELECT

    'systemactivities' ROW_SOURCE,

    [dtuStart]

    ,COUNT(systemNum) AS total

    FROM [DB_admin1].[rept].[tblActivityList]

    WHERE total > 10

    GROUP BY dtuStart

    ORDER...

    April 25, 2013 at 6:31 am

    #1609903

Viewing 15 posts - 1,351 through 1,365 (of 1,414 total)