Forum Replies Created

Viewing 15 posts - 2,536 through 2,550 (of 2,610 total)

  • RE: An Urgent Ad Hoc Report

    CirquedeSQLeil (3/17/2010)


    jacroberts (3/17/2010)


    This is probably one of the most unreadable stories and unreusable pieces of code I have ever seen in an article.

    Please provide specifics if you are going to...

  • RE: An Urgent Ad Hoc Report

    This is probably one of the most unreadable stories and unreusable pieces of code I have ever seen in an article.

  • RE: Decoupling in Relational Databases

    Whoever said that many-to-many relationships don't exist in the real word is wrong. The truth is that the place where many-to-many relationships don't exist is in database designs. If they...

  • RE: Decoupling in Relational Databases

    Tim,

    Your article is essentially completely correct. I like your honest style, admitting how you used to design database tables before you found out about adding this extra type of table....

  • RE: Decoupling in Relational Databases

    Karen Lopez - InfoAdvisors (3/2/2010)


    You don't have to use a primary key to enforce uniqueness. You can use an alternate key as well. So you could have a...

  • RE: Decoupling in Relational Databases

    Gary Varga (3/2/2010)


    jacroberts (3/2/2010)


    It's not decoupling but designing for resolving many-to-many relationships.

    Surely, depending on ones perspective the many-to-many relationship is defined in a link table that decouples entities at either...

  • RE: Decoupling in Relational Databases

    It's not decoupling but designing for resolving many-to-many releationships.

  • RE: SQL Server 2005: Script all Indexes

    forerolui (2/1/2010)


    But I´m not geting error messages, I´m just geting a blank result page.

    Are you running the script that creates the stored procedure which when run will create the script?

    If...

  • RE: SQL Server 2005: Script all Indexes

    I've updated the code so that it will include both FileGroups and any INCLUDE columns.

    Also made it a stored procedure with the option to include existance test and DROP before...

  • RE: A Neural Network in SQL Server

    sknox (10/27/2009)


    jacroberts (10/27/2009)


    I can see that you can do this using SQL server but I fail to see any benefit to using SQL Server rather than wirting some code using...

  • RE: A Neural Network in SQL Server

    I can see that you can do this using SQL server but I fail to see any benefit to using SQL Server rather than writing some code using a normal...

  • RE: Twenty tips to write a good stored procedure


    11. More WHERE clause hints - Avoid unnecessary conditions in the WHERE Clause. Also try to avoid a function in the WHERE clause as it presents SQL engine to do...

  • RE: Twenty tips to write a good stored procedure


    10. WHERE clauses - In a WHERE clause, the various operators used directly affect how fast a query can run. Here are the conditional operators used in the WHERE clause,...

  • RE: Twenty tips to write a good stored procedure

    Thought I'd get in with the first comment, only a spelling mistake that gets through a spell checker:

    Update: I would recommend you to use SET NOCOUNT ON for the shake...

  • RE: SQLServerCentral Editorial Policy - Article Publication

    GSquared (8/13/2009)


    jacroberts (8/13/2009)


    GilaMonster (8/13/2009)


    Plus who decides what's right? The last editor? What happens if someone comes along a couple months after an article's been published and edits garbage in. It...

Viewing 15 posts - 2,536 through 2,550 (of 2,610 total)