Forum Replies Created

Viewing 15 posts - 5,071 through 5,085 (of 8,416 total)

  • RE: deletion of 2 million records

    Stefan_G (3/19/2010)

    Nice. I started using this technique with SQL 2000 and I had not noticed that it was deprecated. Thank you for that info.

    You are welcome. It comes...

    March 19, 2010 at 6:39 am

    #1136657

  • RE: Trigger Not Working TSQL Question

    SQL Dude-467553 (3/18/2010)

    Intersting I didn't know that. I looked and the SSIS package was using the Fast load option, I switched that to just use table and the trigger...

    March 19, 2010 at 6:36 am

    #1136654

  • RE: sp_send_dbmail - dashes under column headers

    Have you considered using Reporting Services instead?

    It is quite good at the sort of thing you seem to be doing here.

    March 19, 2010 at 6:26 am

    #1136645

  • RE: Stored Procedure returns two tables

    The second result set is the return code of the stored procedure, and is probably manufactured by whatever data access technology you are using to connect to SQL Server.

    March 19, 2010 at 6:24 am

    #1136644

  • RE: Statistics

    GilaMonster (3/19/2010)

    Resurrected two year old thread.

    Ha. Never noticed that! :laugh: :blink: :ermm: :blush:

    March 19, 2010 at 6:18 am

    #1136640

  • RE: Are the posted questions getting worse?

    Jeff Moden (3/18/2010)

    BWAA-HAAA!!!! If you put everything into a single EAV, you CAN have a clustered index on all the data in the database. :hehe::-D

    Database design is easy these...

    March 19, 2010 at 6:16 am

    #1136639

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (3/19/2010)

    I'm in Oxford, Mississippi, actually, about an hour south of Memphis. Memphis sits on the Mississippi River at the extreme western edge of Tennessee.

    The words 'Mississippi'...

    March 19, 2010 at 6:14 am

    #1136638

  • RE: Single Query for getting missing row values based on Date for generating report output

    The Dixie Flatline (3/19/2010)

    Hey Paul, what got you onto a recursive kick?

    Blame Chris Morris 😀

    Actually, that is not quite fair - I do like recursive solutions (as a challenge) but...

    March 19, 2010 at 6:09 am

    #1136632

  • RE: Statistics

    Complex topic. Rather than try to summarize it here, I will just link to a pretty definitive TechNet article by Eric N. Hanson and Lubor Kollar:

    Statistics Used by the...

    March 19, 2010 at 6:06 am

    #1136630

  • RE: deletion of 2 million records

    Stefan_G (3/18/2010)

    If the table is very big (more than 10 million rows) you can delete the data in several passes. Use SET ROWCOUNT to limit the amount of data deleted...

    March 19, 2010 at 6:03 am

    #1136628

  • RE: TSQL using parameters does not use the index

    Piotr.Rodak (3/19/2010)

    Tom, you might also consider adding Execute SQL Task to your package to grab the newsequentialguid() from database instead of using the ExecutionInstanceGuid. It looks like you would need...

    March 19, 2010 at 5:47 am

    #1136618

  • RE: Use BETWEEN between strings

    fiaolle (3/19/2010)

    Thanks for the help 🙂

    No worries.

    March 19, 2010 at 5:36 am

    #1136611

  • RE: TSQL using parameters does not use the index

    Tom Van Harpen (3/19/2010)

    ...I guess I was getting hung up with the fact it was doing a table scan to figure out that there were not any rows. With the...

    March 19, 2010 at 5:35 am

    #1136610

  • RE: Date ranges intersections..

    bramanthe (3/19/2010)

    Paul,

    no. I've just shown you my solution as the answer for

    Paul White NZ (3/18/2010)

    Let us know how you get on.

    Oh right. I see. It doesn't have...

    March 19, 2010 at 5:31 am

    #1136609

  • RE: compare of 2 big tables

    peleg k (3/19/2010)

    as i undestand, i should change the reasonRef column on Con_RecipientToMessages to an included column?

    Con_RecipientToMessages is a table. You cannot make a column included on a table....

    March 19, 2010 at 5:29 am

    #1136608

Viewing 15 posts - 5,071 through 5,085 (of 8,416 total)