Forum Replies Created

Viewing 15 posts - 1,561 through 1,575 (of 8,416 total)

  • RE: Filtered index with IS NULL predicate

    GilaMonster (11/8/2011)

    So much for 'fixed in the next version of SQL'... 🙁

    The comments on the Connect item are contradictory, but the most recent one says:

    "This is now an active DCR...

    November 8, 2011 at 2:14 am

    #1404306

  • RE: how to convert subquery to a join

    skanth (11/7/2011)

    select *

    from

    a,b,c

    where

    A.cash_id in

    ( select B.cash_id

    from B

    where B.cash_id = C.cash_id

    )

    The literal translation of that query...

    November 7, 2011 at 9:23 pm

    #1404253

  • RE: Select the document name from a column contaning full path and file name

    Jeff Moden (11/7/2011)

    I agree with TOM. I recommend you continue to use DATALENGTH for the very reason he stated.

    Trouble is, that implementation now only works with Unicode data. ...

    November 7, 2011 at 9:00 pm

    #1404249

  • RE: SELECT tagnames (not attributes) from xml code

    Use the local-name function:

    DECLARE @XML XML =

    N'<root>

    <resource-list>

    <Specimen Name="CODE"/>

    </resource-list>

    </root>'

    SELECT

    ...

    November 7, 2011 at 8:44 pm

    #1404248

  • RE: execute stored procedure with order by

    daveriya (11/7/2011)

    i am converting function into sp,can i execute like this exec proc proc_name 'parm1' 'parm2' order by column.

    Given that the best solution is to insert into table variable and...

    November 7, 2011 at 8:25 pm

    #1404246

  • RE: Filtered index with IS NULL predicate

    Alex Bransky (11/7/2011)

    I'm on SQL 2008 R2 (10.50.1600) and I just created a filtered index with "MyColumn IS NULL" as the filter and my queries appear to be using the...

    November 7, 2011 at 8:02 pm

    #1404243

  • RE: Starting with "WITH"

    I would happily refer to rCTEs (and nested loops plans in general) as RBR rather than RBAR; it's the 'A' that I have issues with 🙂

    Mind you, everything's RBR when...

    November 7, 2011 at 7:06 pm

    #1404241

  • RE: Convert table into XML

    One more time, with PATH syntax:

    SELECT

    aosms.iStudentid AS [StudentId],

    aosms.oldClassID AS [OldClassID],

    aosms.newClassID AS [NewClassID]

    FROM dbo.ArrayOfStudentMoveSummary AS aosms

    FOR XML

    ...

    November 7, 2011 at 7:18 am

    #1403938

  • RE: how to query

    SELECT

    s2.sname,

    m.marks,

    s.name

    FROM @marks-2 AS m

    JOIN @Student AS s ON

    s.stuid = m.studentid

    JOIN @Subject...

    November 7, 2011 at 6:57 am

    #1403926

  • RE: Stored Procs vs Ad Hoc

    Gianluca Sartori (11/7/2011)

    That's it Paul!!!

    I still have confused the two, but at least I'm happy it wasn't my fantasy playing tricks on me. 🙂

    It is inconsistent, so I doubt...

    November 7, 2011 at 4:03 am

    #1403838

  • RE: order of criteria in where clause changes query palan

    Adi Cohn-120898 (11/4/2011)

    I think that this is a bug, but I might be wrong. Can anyone have an explanation for that?

    Sure. I think most people will say that...

    November 7, 2011 at 2:49 am

    #1403818

  • RE: Starting with "WITH"

    Jeff Moden (11/6/2011)

    I have to agree to disagree then... rCTEs are nothing like Hugo's 'lasagne' code. Craig Freeman's explanation of how rCTEs operate is spot on. It reads...

    November 6, 2011 at 10:05 pm

    #1403777

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/4/2011)

    What is this query plan operator?

    It's the 'before' operator for this one:

    I don't think I've ever seen a Log Row Scan operator in the wild.

    November 6, 2011 at 9:36 pm

    #1403773

  • RE: Starting with "WITH"

    Jeff Moden (11/6/2011)

    But it's only faster than SELECT DISTINCT if there are, in fact, a lot of dupes. It's much slower than DISTINCT in the presence of a...

    November 6, 2011 at 9:28 pm

    #1403771

  • RE: Grouping on month

    Jeff Moden (11/6/2011)

    But, is it really a SEEK? Yeah... according to SQL Server, it did a SEEK. But only to find the "first" row with a date greater than...

    November 6, 2011 at 9:10 pm

    #1403767

Viewing 15 posts - 1,561 through 1,575 (of 8,416 total)