Forum Replies Created

Viewing 15 posts - 61 through 75 (of 163 total)

  • RE: Out of memory message when user try to login on application

    Sue_H (8/29/2016)

    EasyBoy (8/29/2016)

    Hello,

    We have a very small database with SQL server 2014 (10 GB of ram). From the last week , when users were trying to login to through the...

    August 29, 2016 at 1:24 pm

    #1898161

  • RE: File Group Running out of space frequently

    Few days ago, we had nearly 200 GB of space available and now we have only 30-40 GB space left.

    Is there any script/method to find out who is filling the...

    July 21, 2016 at 11:28 am

    #1891400

  • RE: File Group Running out of space frequently

    We are adding, dropping and updating data on daily basis. But, it doesn't seems to be that much 😉

    July 15, 2016 at 2:08 pm

    #1890429

  • RE: Optimize very frequent running SP

    Thanks all for your inputs. I will try all recommendation on our test environment and share my outcomes with you guys.

    April 8, 2016 at 8:25 am

    #1870814

  • RE: Optimize very frequent running SP

    Eric M Russell (4/7/2016)

    I'm not understanding the following. Is [GDML.eResults.UserStore] a database with an odd 3 part name containing periods, or is this a reference to a remotely linked database/table?

    [GDML.eResults.UserStore].[dbo].[vw_aspnet_UserProfiles]

    That's...

    April 7, 2016 at 1:16 pm

    #1870638

  • RE: Slow running query

    GilaMonster (1/20/2016)

    Rather get a backup restored somewhere you can test. Because a test table with dummy data will behave differently.

    That's what i think earlier, but backup size is too large...

    January 20, 2016 at 9:50 am

    #1853205

  • RE: Slow running query

    GilaMonster (1/20/2016)

    EasyBoy (1/20/2016)

    This index is already exist.

    CREATE INDEX [ix_tblEventSample_FkSample_fkEventtype] ON [dbo].[tblEventSample]([fkSample], [fkEventType]) WITH FILLFACTOR = 97 ON [INDEXDBGROUP]

    GO

    No it doesn't.

    Andrew recommended an index with the key fkeventtype, fksample....

    January 20, 2016 at 8:40 am

    #1853174

  • RE: Slow running query

    Andrew G (1/19/2016)

    CREATE NONCLUSTERED INDEX ix_tblEventSample_fkeventtype ON dbo.tblEventSample (fkeventtype, fksample) WITH FILLFACTOR = 90 ON [INDEXDBGROUP] --[PRIMARY]

    That seems to resolve the index scan. See how long after that.

    This index...

    January 20, 2016 at 7:37 am

    #1853133

  • RE: Slow running query

    EasyBoy (1/19/2016)

    GilaMonster (1/19/2016)

    EasyBoy (1/19/2016)

    Sean Lange (1/19/2016)

    Can you post the actual execution plan instead of the excel version? It shows a lot more detail which helps with the insight as to...

    January 19, 2016 at 11:51 am

    #1852895

  • RE: Slow running query

    GilaMonster (1/19/2016)

    EasyBoy (1/19/2016)

    Sean Lange (1/19/2016)

    Can you post the actual execution plan instead of the excel version? It shows a lot more detail which helps with the insight as to what...

    January 19, 2016 at 10:25 am

    #1852844

  • RE: Slow running query

    Sean Lange (1/19/2016)

    Can you post the actual execution plan instead of the excel version? It shows a lot more detail which helps with the insight as to what can be...

    January 19, 2016 at 10:06 am

    #1852834

  • RE: Rewrite query for better performance

    GilaMonster (12/16/2015)

    And does tblEventSample have any nonclustered indexes? If so, please post definitions of all of them.

    Only one Nonclustered index:

    nonclustered : fkSample, fkEventType

    December 16, 2015 at 1:36 pm

    #1846430

  • RE: Rewrite query for better performance

    GilaMonster (12/16/2015)

    Picture of the plan is useless, and you should have mentioned it's SQL 2000, as that removes a lot of options.

    Please run the query with SHOWPLAN_ALL and put the...

    December 16, 2015 at 12:43 pm

    #1846405

  • RE: Rewrite query for better performance

    It is SQL server 2000. So, i am not able to save the sqlplan.

    Anyhow, i have captured the main part and attached for your consideration.

    Thanks

    December 16, 2015 at 11:43 am

    #1846392

  • RE: Tune SQL Query with very large tables

    ScottPletcher (11/20/2015)

    Would need to see the view definition and related table definitions.

    If you're serious about tuning the tables, rather than just this specific query, would also need to...

    November 20, 2015 at 11:58 am

    #1841430

Viewing 15 posts - 61 through 75 (of 163 total)