Forum Replies Created

Viewing 15 posts - 2,416 through 2,430 (of 2,458 total)

  • RE: Script to convert MS Access queries to T-SQL

    james.massey (8/3/2012)

    Well, that's a shame. I'm pretty much restricted to operating this way for this need - but it matches up with the fact that I could find no...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 3, 2012 at 12:09 pm

    #1521571

  • RE: Applying join

    Kirby1367 (8/2/2012)

    Koen Verbeeck (8/2/2012)

    SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS

    WHERE TABLE_NAME = 'Table A'

    INTERSECT

    SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS

    WHERE TABLE_NAME = 'Table B';

    You can also use a INNER JOIN instead of INTERSECT to accomplish the...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 2, 2012 at 4:36 pm

    #1521181

  • RE: How to manage Transaction Log.

    GilaMonster (8/1/2012)

    Don't shrink the log to 0 (unless the next operation is going to be a grow)

    Growing the log is an expensive operation, the file has to be zeroed out...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 1, 2012 at 4:29 pm

    #1520589

  • RE: How to manage Transaction Log.

    sestell1 (8/1/2012)

    There shouldn't be any need to shrink the log file while doing the inserts. This just adds extra overhead as the log has to auto-grow back out as...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 1, 2012 at 4:10 pm

    #1520582

  • RE: trying to add alias for value generated by Where clause

    polkadot (7/31/2012)

    Unless I comment out the alias 'AS RunningTotal' the query fails, but I need an alias for the column the WHERE STATEMENT generates. Will someone please show me...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 1, 2012 at 3:57 pm

    #1520579

  • RE: How to manage Transaction Log.

    prasadau2006 (7/31/2012)

    Hi All,

    Is their a way we can manage Transaction log even before it fills up? I have some archive tables, my requirement is to add fields to this tables...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 1, 2012 at 1:53 pm

    #1520499

  • RE: Removing tags stored in a ntext field

    jshahan (7/25/2012)

    XMLSQLNinja, thank for your time and alternative approach. I'm afraid that the garbage in my data is not well formed and this method stumbles as a result as...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 25, 2012 at 2:27 pm

    #1517632

  • RE: Get running total in the following query

    Lynn Pettis (7/25/2012)

    Thoughts? It all depends on where you run the code. On my development VM the Quircky Update beats your rCTE every time. Using your code...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 25, 2012 at 2:03 pm

    #1517627

  • RE: Get running total in the following query

    Lynn Pettis (7/23/2012)

    Okay, now modify the rCTE to run against this dataset. It will contain 1,000,000 rows of data and potentially 10,000 unique cID's, not 1 (cID = 123)...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 25, 2012 at 1:23 pm

    #1517600

  • RE: Get running total in the following query

    Gosh, that's quite confrontational.

    My sincere apologies if I came off as confrontational; that was not my intent.

    I, too, get quite a bit of information on the Internet...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 25, 2012 at 1:16 pm

    #1517596

  • RE: Get running total in the following query

    Jeff Moden (7/23/2012)

    XMLSQLNinja (7/23/2012)

    ChrisM@home (7/20/2012)

    XMLSQLNinja (7/18/2012)

    ...

    There are other ways to do this but using recursion is generally the fastest.

    Recursion is the third fastest; CLR > "Quirky Update" > rCTE >...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 23, 2012 at 10:34 pm

    #1516583

  • RE: Removing tags stored in a ntext field

    Oky Doky.

    Just got back from vacation and wanted to get to this ASAP. I am not optimizing this query, just getting the desired results for now.

    First, no UDF needed....

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 23, 2012 at 5:05 pm

    #1516513

  • RE: Get running total in the following query

    ChrisM@home (7/20/2012)

    XMLSQLNinja (7/18/2012)

    ...

    There are other ways to do this but using recursion is generally the fastest.

    Recursion is the third fastest; CLR > "Quirky Update" > rCTE > cursor > triangular...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 23, 2012 at 3:43 pm

    #1516499

  • RE: Get running total in the following query

    Just got back from vacation and wanted to address this one first...

    I must be missing something but I don't see how that recursive CTE (as much as I like...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 23, 2012 at 2:55 pm

    #1516486

  • RE: Database update from web page

    First thought was that we would connect to current db and do updates directly (validating fields before update).

    Good Grief! First and foremost - NEVER do that. As a DBA,...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 18, 2012 at 11:22 am

    #1514384

Viewing 15 posts - 2,416 through 2,430 (of 2,458 total)