Forum Replies Created

Viewing 15 posts - 751 through 765 (of 1,034 total)

  • RE: T-SQL

    Ooh and I managed to get the query to return different seconds as well

    (No column name)(No column name)

    2009-11-16 08:45:49.000Monday

    2009-11-16 08:45:49.000Monday

    2009-11-16 14:45:48.997Monday

    2009-11-16 14:45:48.997Monday

    Although I'm a bit confused exactlyhow the later version...

    November 17, 2009 at 7:50 am

    #1080259

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    david.wright-948385 (11/17/2009)

    I think getdate() = getutcdate() would return false in your time zone, so I think they're probably different!

    Everyone is looking at the values, yes, they are "different",...

    November 17, 2009 at 7:33 am

    #1080243

  • RE: ISNULL

    I too go with using ISNULL because I discovered it before COALESCE.

    For multiple NULL values until I discovered COALESCE, I'd just chain ISNULL's

    ISNULL(<test value>,ISNULL(<test value 2>,<final value))

    etc.

    November 3, 2009 at 7:00 am

    #1074247

  • RE: View Users assigned to an Active Directory account in SSMS

    This may or may not work, but there are scripts out there to create a linked server to AD and then query AD as if it were SQL.

    They work, but...

    November 2, 2009 at 7:50 am

    #1073813

  • RE: Role Membership

    skjoldtc (10/22/2009)

    I think the quesiton could have been worded better. Something like "What are the valid values that can be returned by IS_MEMBER?"

    The question implied or I inferred that we...

    October 22, 2009 at 8:11 am

    #1069450

  • RE: The Future of Bits

    jcrawf02 (10/16/2009)

    Dammit Luke, you used the force and beat me to it! :hehe: I've been wanting to buy one of those, but have yet to actually do it. Anybody own...

    October 16, 2009 at 10:10 am

    #1067024

  • RE: Stored Procs and Unused Parameters

    Al-279884 (10/15/2009)

    From current experience in my workplace: sometimes developers use third-party libraries like iBatis or NHibernate for Object Model - Relational Database mappings. Maybe these libraries are forcing the developer...

    October 16, 2009 at 7:32 am

    #1066864

  • RE: Stored Procs and Unused Parameters

    I sure as hell hope not.

    This particular developer is a bit difficult to work with, but has the advantage of politics.

    I think it's silly to expose these parameters but if...

    October 14, 2009 at 6:40 am

    #1065613

  • RE: sql 2005 query runs slow in retrieving a set with two parameters

    What does the execution plan look like? Table Scans or Index Scans or Index Seeks.

    Can you provide sample DDL and INSERT statements to stick some sample data into a...

    October 13, 2009 at 1:33 pm

    #1065363

  • RE: sql 2005 query runs slow in retrieving a set with two parameters

    Jee I think I've seen something like this before.

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    You migth want to look at the query plans its building... and look at what Gail did here to make an neato...

    October 13, 2009 at 1:20 pm

    #1065353

  • RE: Stored Procs and Unused Parameters

    Bob Hovious 24601 (10/13/2009)

    Think about this... the unused parameters do have a purpose. They are being used to save coding effort in the calling application.

    Ok since you put...

    October 13, 2009 at 1:17 pm

    #1065352

  • RE: Stored Procs and Unused Parameters

    GSquared (10/13/2009)

    I'd say go ahead and include them. It means a little extra RAM being allocated, but it doesn't hurt anything beyond that.

    Okies... it wasn't about work for me...

    October 13, 2009 at 12:59 pm

    #1065344

  • RE: Stored Procs and Unused Parameters

    Michael Valentine Jones (10/13/2009)

    Ask the developer to explain exactly why that isn't a stupid idea.

    The answer to this one is that he loops through an object and passes all the...

    October 13, 2009 at 10:37 am

    #1065295

  • RE: Speedup big database - MSSQL 2005

    GilaMonster (10/10/2009)

    Why on earth do you have a table with 400+ columns?

    You know, I ask myself the same thing when I look at some of the stuff developers did before...

    October 13, 2009 at 9:31 am

    #1065260

  • RE: Group on DateTimeColumn

    Bob Hovious 24601 (10/12/2009)

    Your way would definitely save a few CPU cycles, but shouldn't it be

    GROUP BY DATEADD(month,datediff(month,0,cv.Dischargedtm),0)

    ??

    That would group them into monthly buckets... since it seems to be...

    October 12, 2009 at 10:49 am

    #1064834

Viewing 15 posts - 751 through 765 (of 1,034 total)