Forum Replies Created

Viewing 15 posts - 16 through 30 (of 859 total)

  • RE: delete a large amount of rows in a table

    Since you have multiple tables using the same exclusion data set i would create a work table with that data set and index it, then use a LEFT JOIN tbl...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    February 27, 2013 at 3:05 pm

    #1591763

  • RE: delete a large amount of rows in a table

    thats what i mean by sub query.

    However how many rows are in the logging table and what indexes there are will affect this a lot. Also is End_Time a...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    February 27, 2013 at 2:41 pm

    #1591739

  • RE: delete a large amount of rows in a table

    it should.

    How many rows are in [LOGGING_01_DBF].[dbo].[LOG_LOGIN_TBL]?

    Your sub query could be causing the issue if there are only 133k rows in [CHARACTER_01_DBF].[dbo].SKILLINFLUENCE_TBL and its taking hours.

    if the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    February 27, 2013 at 2:35 pm

    #1591735

  • RE: delete a large amount of rows in a table

    insanityflyff (2/27/2013)

    133.723 rows total and i wanna keep 77.646

    i wanna delete the custom amount according to the query u see above but i tried to run a count for the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    February 27, 2013 at 2:25 pm

    #1591732

  • RE: delete a large amount of rows in a table

    What percentage of the rows are you keeping and how many rows are there in the tables?

    At some point its easier just to loop a delete statement depending on how...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    February 27, 2013 at 2:08 pm

    #1591727

  • RE: t-sql update trigger

    Can you post the DDL for the tables and a couple of sample rows and what you would like inserted into the logging table?

    This information will help when writing the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    February 6, 2013 at 2:54 pm

    #1585146

  • RE: Can DatabaseMail attach a formatted Excel file

    foxxo (2/6/2013)

    You need a tab delimited file for excel to recognise it and the file extension needs to be .csv (.xls will work but will display an error first).

    eg.

    DECLARE @query_result_separator...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    February 6, 2013 at 11:31 am

    #1585076

  • RE: Order of JOIN in multiple table joins

    Eugene Elutin (1/28/2013)

    purushottam2 (1/28/2013)

    Yes, Because in one of my query, i am joining with 3 tables. And table 1 have the 1 million record, 2 Lakh and table3 have 10...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    January 28, 2013 at 11:53 am

    #1581759

  • RE: Help on how to count guests in hotel every day

    dwain.c (1/27/2013)

    I think you need a calendar table to do this:

    CREATE TABLE #Guests (checkin date, checkout date, FullName varchar(50))

    INSERT INTO #Guests

    SELECT '10/12/2012', '10/16/2012', 'Corky Doe' UNION ALL

    SELECT '12/12/2012', '12/17/2012', 'Janice...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    January 28, 2013 at 11:46 am

    #1581755

  • RE: creating SQL login with cursor

    Bhuvnesh (1/9/2013)

    paul 77096 (1/9/2013)

    Thats Brilliant, it worked like a dream.

    in future try to avoid cursors instead use loop or set based approach. why ???? google it 🙂

    Cursors VS Loops...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    January 9, 2013 at 2:26 pm

    #1575448

  • RE: Odd table sizes

    Mick Opalak (1/8/2013)

    That was it. This table is a heap.

    Thanks for the help.

    Did you add a clustered index or resolve it in some way or do you now need...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    January 8, 2013 at 9:11 am

    #1574878

  • RE: Odd table sizes

    Mick Opalak (1/7/2013)

    I verified the row counts using COUNT(*) and they match, as I would expect. However, the publisher has a much larger data size.

    Is there a clustered index...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    January 7, 2013 at 2:54 pm

    #1574540

  • RE: NULL VALUES

    Personally i would rather "Store" the null value than "N/A" as i can save space and if its a numeric field dont have to make any thing special. I...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    January 7, 2013 at 2:50 pm

    #1574538

  • RE: Was the "Commands Completed Successfully" message replaced by "Row(s) affected"?

    GilaMonster (12/13/2012)

    Someone's set up a DDL trigger and forgot to SET NOCOUNT ON in it.

    this is my thoughts as well. when we deal with a table that has a trigger...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    December 13, 2012 at 11:14 am

    #1568423

  • RE: Simular to PIVOT Table, but not

    CELKO (12/12/2012)

    That is not how the relational model works. A table is a set whose attributes are fully known at schema creation time. Elephants do not fall out of the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    December 12, 2012 at 4:48 pm

    #1568102

Viewing 15 posts - 16 through 30 (of 859 total)