Forum Replies Created

Viewing 15 posts - 22,621 through 22,635 (of 26,490 total)

  • RE: CASE. Is this a legitimate SQL?

    Don't think so. What happens when you try running it in SSMS?

  • RE: Number of columns in composite key

    Nope, I am sure what I heard was normalization. I understand denormalization. I am aware of up to 6th normal form (no nulls).

  • RE: Batch Query Execution?

    What do you want to trigger the job? does it only run once a day?

  • RE: SQL Injection

    NotManyPoints (2/3/2009)


    If a DBA has:

    a) no idea about the particular topic of SQL injection (particularly this topic, as its so widely written about -which is not the same as acted...

  • RE: Incremental Backup Job

    I'm going to suggest that you read BOL again. Read about Full, Differential, and Transaction Log backups. What types and how often you run the various backups is...

  • RE: Number of columns in composite key

    Actually, I've heard, but can't confirm, that if follow the rules of normalization far enough, you end up back where you started. Why you'd do that, I have no...

  • RE: Number of columns in composite key

    Bruce W Cassidy (2/3/2009)


    ivana.andric (2/3/2009)


    Can anyone tell me are there any limits on how many columns should be in composite key? I have a unique combinations of 28 fields that...

  • RE: Number of columns in composite key

    Maximum number of columns (excluding INCLUDED columns) is 16.

  • RE: Batch Query Execution?

    If it is the same queries in the same order every day, I'd now have to agree with Roy; a scheduled job with multiple steps.

  • RE: SQL Injection

    NotManyPoints (2/3/2009)


    Lynn Pettis (2/3/2009)


    So, it begs the question, are you aware of every aspect of SQL Server yourself?

    No of course not: that would remove the need for this website, and...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/3/2009)


    Lynn Pettis (2/3/2009)


    GilaMonster (2/3/2009)


    Bruce W Cassidy (2/3/2009)


    I'm still struggling with reading most of the questions. I think it's because I'm such a noob.

    Nah. You're not the only...

  • RE: SQL Injection

    NotManyPoints (2/3/2009)


    GilaMonster (2/3/2009)


    NotManyPoints (2/3/2009)


    More that they have an awareness and be somewhat ‘up to speed’ as it were in their chosen profession.

    Would that go for every aspect of...

  • RE: How to add multiple columns from different tables into one column of new table

    Have you read the article that several of us have recommended that you read? If you follow the steps in that article, you can post everything we need to...

  • RE: Are the posted questions getting worse?

    GilaMonster (2/3/2009)


    Bruce W Cassidy (2/3/2009)


    I'm still struggling with reading most of the questions. I think it's because I'm such a noob.

    Nah. You're not the only one. That's the original...

  • RE: Business Model - using SSRS to allow customers to view reports via the web

    rod (2/3/2009)


    We are proposing to allow our customers to view reports over the web.

    What licencing do you recommend? CALs or processor?

    What access do you suggest? Forms or windows based?

    Our...

Viewing 15 posts - 22,621 through 22,635 (of 26,490 total)