Forum Replies Created

Viewing 15 posts - 4,756 through 4,770 (of 5,841 total)

  • RE: SQL Server 2005 Poor performance on loading

    su5y (4/20/2009)

    what do you mean regards to statistics? We are looking at the paging file this morning which is currently on the c drive which may not be big...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    April 20, 2009 at 10:16 am

    #980837

  • RE: Data loading using cursors for row by row fetch, check and insert,very slow help please.

    It is a very common misconception that WHILE ... LOOP over a collection of records is better than a cursor. The costs associated with setting up/managing a cursor or...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    April 20, 2009 at 5:53 am

    #980632

  • RE: Odd SQL Execution Plan question

    1) Output the query plan as text or XML and post THAT in your document. Those things get HUGEly bloated and make even simple queries look like a nightmare....

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    April 20, 2009 at 5:49 am

    #980629

  • RE: SQL Server 2005 Poor performance on loading

    1) Statistics are out of date. Consider updating them nightly.

    2) You don't have a max memory setting and sql server is taking too much RAM.

    need much more...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    April 20, 2009 at 5:47 am

    #980627

  • RE: Best Replaces for Cursor

    bitbucket (4/19/2009)

    Paul White

    The answer is..."it depends!"

    Sometimes, a cursor *is* the optimal solution. Not often, but it does happen.

    Paul care to post some code that shows an example of where a...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    April 20, 2009 at 5:46 am

    #980625

  • RE: SAN and potential Filegroup configuration help required....

    Swirl80 (4/13/2009)

    Cheers for that,

    2) Please refer to my original post, whoever set our san up originally (before my time - believe it to be DELL themselves) created 4 RAID groups...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    April 13, 2009 at 7:58 am

    #976616

  • RE: SAN and potential Filegroup configuration help required....

    Swirl80 (4/11/2009)

    Hi, thanks for the response.

    1) Will putting the tlogs on the raid10 be still as quick even though there are numerous log and data files on there? Can...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    April 13, 2009 at 6:30 am

    #976501

  • RE: Performance Best Practices

    RBarryYoung (4/10/2009)

    Steve Jones - Editor (4/10/2009)

    Sorry should have noted. I moved this to 2000.

    Heh. You and Kevin really had me going there for a minute. I thought...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    April 10, 2009 at 8:57 am

    #975817

  • RE: Performance Best Practices

    RBarryYoung (4/9/2009)

    sigh* Please note which forum you are in.

    Just post the text version then.

    He IS in the 2000 forum, isn't he? šŸ™‚

    OP: My guess is that any process that...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    April 10, 2009 at 8:12 am

    #975771

  • RE: SAN and potential Filegroup configuration help required....

    1) Putting the tlogs on the raid10 will probably be faster than on the raid5 sets, assuming the raid10 isn't saturated

    2) having too many file groups/partitions on disks (raid or...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    April 10, 2009 at 8:08 am

    #975770

  • RE: SQL Server 2005 Paging ā€“ The Holy Grail

    Nice article.

    I have been doing similar coding for a few years now with great success. My typical situation gets just the primary key fields from many tables necessary to...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 11, 2009 at 5:31 am

    #957356

  • RE: Dig in a 3,3 Tera byte SAP database

    I STRONGLY recommend that you get some professional help, sooner rather than later. From your questions and comments I just don't see you having the necessary skills and training...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 19, 2009 at 1:18 pm

    #947086

  • RE: Is this box underpowered?

    Barkingdog (2/16/2009)

    "GrumpyOLDDBA" wrote

    >>> I'd suggest you get the sql performance dashboard from connect,

    What is connect? Can you provide a URL?

    Barkingdog

    I think he meant http://www.codeplex.com, although the sql server performance dashboard...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 16, 2009 at 12:38 pm

    #944785

  • RE: How to avoid Table scan from temp db

    Eswin (2/12/2009)

    Tanx

    I created indexes for my temp table but still the issue persists . table scan costs 100%.

    The optimizer is pretty darn good. table scans can often be much...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 13, 2009 at 7:53 am

    #943622

  • RE: Procedure with Table variable as input parameter?

    GĀ² (2/11/2009)

    You could also pass in an XML string and parse it into a temp table or table variable.

    Greg

    That is covered in the document I referenced, with example...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 11, 2009 at 10:36 am

    #942346

Viewing 15 posts - 4,756 through 4,770 (of 5,841 total)