Forum Replies Created

Viewing 15 posts - 2,461 through 2,475 (of 8,761 total)

  • RE: Stored procedure takes more than minute to run.

    savibp3 - Saturday, January 21, 2017 2:27 AM

    I have stored procedure which takes more than a min to run in sql browser.when...

    January 21, 2017 at 2:47 am

    #1924183

  • RE: Just an observation: It seems odd that foreign keys cannot be references to unconstrained superkeys...*

    Further on the schema I posted previously

    Questionnaire
    An instance of a collection of questions and their properties.

    Question
    Individual unique questions and their properties. ...

    January 21, 2017 at 2:21 am

    #1924182

  • RE: validation ERD

    I see many problems here and my first thought is that a re-iteration of the business requirement analysis should be the next step. The schema itself is over simplified for...

    January 21, 2017 at 12:43 am

    #1924181

  • RE: How to find same data for all the columns in a table

    Can you post the DDL (create table) script, sample data as an insert statement and the expected output please?
    😎

    January 20, 2017 at 1:00 pm

    #1924141

  • RE: SSC Forum Updates

    Is there any way to increase the resolution of images posted, currently they are far to small to be usable?
    😎

    January 20, 2017 at 8:43 am

    #1924071

  • RE: SSC Forum Updates

    Trying out Jeff's method on the ASCII diagram
    😎

    Looks like it works like a charm! Thanks Jeff!

  •                                                                    ,--------------------------------,
     +--------------------+           +---------------------------+    |      +------------------+      |    +---------------------------+ 
     | Questionnaire      |           | Questionnaire_question    |    |      | Execution        |      |    | Execution_answer          |
     |--------------------|           +---------------------------+    |      +------------------+      |    +---------------------------+
     | Questionnaire_id   |-+---,     | Questionnaire_question_id |>+--'      | Execution_id     |-+--, '--+<| Questionnaire_question_id |  
     | Questionnaire_name |     '---+<| Questionnaire_id          |>+-------+<| Questionnaire_id |    '----+<| Execution_id              |  

January 20, 2017 at 8:26 am

#1924064

  • RE: validation ERD

    rick.adams - Friday, January 20, 2017 6:14 AM

    I looking for feedback about this ERD to make it a valid...

    January 20, 2017 at 6:36 am

    #1923998

  • RE: SSC Forum Updates

    Was trying to post an ASCII diagram as a code=plain, comes out all muddled
    😎


                           ,--------------------------------,
     +--------------------+    +---------------------------+  |  +------------------+  |  +---------------------------+
     | Questionnaire  |   ...

    January 20, 2017 at 5:34 am

    #1923983

  • RE: SSC Forum Updates

    James Billings, Redgate - Friday, January 20, 2017 1:51 AM

    Eirikur Eiriksson - Friday, January 20, 2017 1:27...

    January 20, 2017 at 1:56 am

    #1923943

  • RE: SSC Forum Updates

    James Billings, Redgate - Friday, January 20, 2017 1:20 AM

    We've deployed a fix this morning for the [TopicTitle] not being correctly replaced in...

    January 20, 2017 at 1:27 am

    #1923939

  • RE: CDC in Standard Sp1 with 120 compability level

    postfix - Friday, January 20, 2017 1:12 AM

    Hi,
    We should migrate MSSQL 2014 Enterprise to 2016 SP1 Standard.
    Compability level should be the same (120...

    January 20, 2017 at 1:21 am

    #1923937

  • RE: Finding the name

    Thanks for the simple question Steve.
    😎

    Quick pointer, use the text() function to bypass the implied XML reconstruction for the output,

    SELECT r.value('local-name(.)','VARCHAR(100)') AS Slot,
       r.value('(./text())[1]','VARCHAR(100)')...

    January 20, 2017 at 12:48 am

    #1923934

  • RE: How to restrict access to users

    Those are server-level settings so the sp_configure must be run by a member of the sysadmin role, also RECONFIGURE WITH OVERRIDE is needed for updating the Running Configuration Value.

    January 20, 2017 at 12:40 am

    #1923933

  • RE: Just an observation: It seems odd that foreign keys cannot be references to unconstrained superkeys...*

    I must agree with SQL Server on this one 😉 that schema is too ambiguous to constrain properly. 
    😎

    Here is a quick suggestion of a better way of doing this

    January 20, 2017 at 12:07 am

    #1923932

  • RE: SQL Server Book

    BiboKid - Thursday, January 19, 2017 8:20 PM

    Hi!

    What book would you recommend for SQL Server troubleshooting CPU, memory, replication etc issues.

    Thanks

    First thought would...

    January 19, 2017 at 10:04 pm

    #1923924

    • Viewing 15 posts - 2,461 through 2,475 (of 8,761 total)