Forum Replies Created

Viewing 15 posts - 1,576 through 1,590 (of 8,416 total)

  • RE: Searching smallest unused number

    TheSQLGuru (11/3/2011)

    It is QUITE difficult (without the OUTPUT clause anyway, which is thankfully available now) to do sequencing like this.

    We've always been able to do it safely and efficiently without...

    November 6, 2011 at 6:49 am

    #1403702

  • RE: Split String

    satishthota (11/6/2011)

    thanks and the following string will not work for yours solution

    Declare @Sname Varchar(255)

    set @Sname='SQL SERVER,ORACLE,MYSQL'

    Need query urgent

    DECLARE @sname VARCHAR(255) = 'SQL SERVER,ORACLE,MYSQL';

    SELECT

    SUBSTRING(@sname, N.n, CHARINDEX(string.comma,...

    November 6, 2011 at 5:53 am

    #1403700

  • RE: Starting with "WITH"

    L' Eomot Inversé (11/5/2011)

    That rCTEs are bad for counting doesn't make all use of rCTEs silly and it certainly doesn't demonstrate that rCTEs are not a set-based concept; would you...

    November 6, 2011 at 5:23 am

    #1403699

  • RE: Grouping on month

    Jeff Moden (11/6/2011)

    My main purpose in this is to show that what SQL Server labels as a SCAN is frequently a SEEK in disguise.

    The query plan I get looks like...

    November 6, 2011 at 2:36 am

    #1403693

  • RE: Stored Procs vs Ad Hoc

    Gianluca Sartori (10/27/2011)

    GilaMonster (10/27/2011)

    Gianluca Sartori (10/27/2011)

    Vishal.Gajjar (10/27/2011)

    Adhoc queries need to be exactly same for reuse. i.e. case-sensitivity, white spaces, etc...

    True indeed, except for whitespaces.

    Actually he's completely right. The plan cache...

    November 6, 2011 at 1:41 am

    #1403690

  • RE: Split String

    DECLARE @Sname CHAR(11) = 'A,B,C,D,E,F'

    SELECT

    split = SUBSTRING(@Sname, position.i, 1)

    FROM (VALUES (1), (3), (5), (7), (9), (11)) AS position (i)

    November 6, 2011 at 1:23 am

    #1403689

  • RE: Inserting records into a large table

    richard garth (11/5/2011)

    Is it always the best thing to drop and re-create indexes in this situation?

    No, not always. The main advantages of dropping and re-creating indexes are:

    (1) It can...

    November 6, 2011 at 1:15 am

    #1403687

  • RE: When is a scan cheaper than a seek?

    Artoo22 (11/3/2011)

    Is it really more efficient to scan 4,367,682 rows and perform a merge join than it is to perform 40,371 seeks?

    According to SQL Server's model of reality, the answer...

    November 6, 2011 at 12:59 am

    #1403686

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/4/2011)

    But the physical operator is a hash match which can be used to accomplish all of the above. So I would have gone with hash match. ...

    November 4, 2011 at 10:13 am

    #1403369

  • RE: Today's Random Word!

    Flashdance

    November 4, 2011 at 9:49 am

    #1403349

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/4/2011)

    SQL Kiwi (11/4/2011)

    SQLRNNR (11/4/2011)

    Cadavre (11/4/2011)

    Brandie Tarvin (11/4/2011)

    SQL Kiwi (11/4/2011)

    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    Isn't that...

    November 4, 2011 at 9:31 am

    #1403329

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/4/2011)

    What is this query plan operator?

    It depends. It could be a hash join, hash aggregate, flow distinct, or a union...

    November 4, 2011 at 9:18 am

    #1403324

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/4/2011)

    SQLRNNR (11/4/2011)

    Oh wait, you meant for query plan operators.

    What is this query plan operator?

    Alien ship attacking Beijing skyscraper?

    Correct. When can you start?

    November 4, 2011 at 9:14 am

    #1403318

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/4/2011)

    Cadavre (11/4/2011)

    Brandie Tarvin (11/4/2011)

    SQL Kiwi (11/4/2011)

    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    Isn't that pretty much every...

    November 4, 2011 at 8:50 am

    #1403295

  • RE: Are the posted questions getting worse?

    Cadavre (11/4/2011)

    Brandie Tarvin (11/4/2011)

    SQL Kiwi (11/4/2011)

    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    Isn't that pretty much every interview...

    November 4, 2011 at 8:45 am

    #1403285

Viewing 15 posts - 1,576 through 1,590 (of 8,416 total)