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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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)...

    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...

    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 >...

    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....

    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...

    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...

    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,...

    July 18, 2012 at 11:22 am

    #1514384

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