Forum Replies Created

Viewing 15 posts - 3,406 through 3,420 (of 15,381 total)

  • RE: ID or Id

    Eric M Russell (1/20/2015)

    I've used product_id. I like typing code in all lowercase, both keywords and identifiers, which is ok so long as underscores are also used for clarity. Also,...

    January 20, 2015 at 9:47 am

    #1771514

  • RE: Are the posted questions getting worse?

    We are finally starting to move our ERP to a new system (well new to us but still rather antiquated). In the process of looking at vendors our mainframe system...

    January 20, 2015 at 9:31 am

    #1771505

  • RE: ID or Id

    Jason-299789 (1/20/2015)

    I tend to use Id rather than ID. Mainly due to being trained to use Pascal case naming conventions, even when I'm typing I occasionally throw in a...

    January 20, 2015 at 9:22 am

    #1771497

  • RE: ID or Id

    Koen Verbeeck (1/20/2015)

    Personally I prefer ID, but I cannot give any objective claim on why it is better than Id.

    What a minute....we agree on this one. 😉

    I use ID but...

    January 20, 2015 at 9:21 am

    #1771496

  • RE: Performance problem when joining to a view.

    Jason-299789 (1/19/2015)

    Also the WITH(NOLOCK) Hint could do with being removed as you can get dirty reads and so inconsistent data, possibly not as much of an issue on a static...

    January 19, 2015 at 8:54 am

    #1771152

  • RE: Please tel me any good books on profiler and query plan

    rajemessage 14195 (1/19/2015)

    hi,

    Please tel me any good book on profiler and query plan or any good link

    where i can get some problem and solution or steps to follow in...

    January 19, 2015 at 8:30 am

    #1771144

  • RE: Performance problem when joining to a view.

    Daniel Forrester 123 (1/19/2015)

    I'm sure I'll have to do this properly at some point.

    Why not now? The logic and code is fresh in your mind. It almost always takes less...

    January 19, 2015 at 8:30 am

    #1771143

  • RE: Is it a good idea to use a UDDT + Rules for this?

    Steve Jones - SSC Editor (1/16/2015)

    I like that you're keeping a surrogate key. Good idea.

    I like Lowell's thoughts on computed columns. While not specifically doing this, I have done similar...

    January 16, 2015 at 10:59 am

    #1770837

  • RE: SQL Password Policy and Expiration

    asc45 (1/16/2015)

    We are in the discussion of enforcing password policy to our SQL accounts so that none of the accounts can have blank/easy password and follow our domain account policies....

    January 16, 2015 at 10:35 am

    #1770831

  • RE: Counting values

    TomThomson (1/16/2015)

    Sean Lange (1/16/2015)

    TomThomson (1/15/2015)

    Sean Lange (1/14/2015)

    Koen Verbeeck (1/14/2015)

    Nope, I'm control freak enough to change it to SELECT 1. I even do it in the scripts generated by SSMS.

    I might...

    January 16, 2015 at 10:33 am

    #1770830

  • RE: Counting values

    TomThomson (1/15/2015)

    Sean Lange (1/14/2015)

    Koen Verbeeck (1/14/2015)

    Nope, I'm control freak enough to change it to SELECT 1. I even do it in the scripts generated by SSMS.

    I might need some help...

    If...

    January 16, 2015 at 6:57 am

    #1770744

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/15/2015)

    Sean Lange (1/15/2015)

    I am having a discussion with somebody who swears that using

    EXISTS(select 1

    is way faster than just select *. I know Gail has an article on her...

    January 15, 2015 at 12:56 pm

    #1770548

  • RE: Are the posted questions getting worse?

    I am having a discussion with somebody who swears that using

    EXISTS(select 1

    is way faster than just select *. I know Gail has an article on her blog but I...

    January 15, 2015 at 11:49 am

    #1770532

  • RE: Lowest Child in recusive query

    edberg16 (1/14/2015)

    Sean Lange (1/14/2015)

    edberg16 (1/14/2015)

    Mark,

    I am trying to run the query without Path column but I end up with limited result set.

    Any suggestions.

    Thanks.

    What does that mean? Can you share the...

    January 15, 2015 at 7:25 am

    #1770450

  • RE: Lowest Child in recusive query

    edberg16 (1/14/2015)

    Mark,

    I am trying to run the query without Path column but I end up with limited result set.

    Any suggestions.

    Thanks.

    What does that mean? Can you share the code you are...

    January 14, 2015 at 3:39 pm

    #1770283

Viewing 15 posts - 3,406 through 3,420 (of 15,381 total)