Forum Replies Created

Viewing 15 posts - 2,161 through 2,175 (of 5,502 total)

  • RE: require additional memory?

    I would first run a script and check for missing indexes. (I'm sure there are SS2K scripts out there...). Most probably a missing index issue as my first wild guess.

    As...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 7, 2011 at 3:38 am

    #1270534

  • RE: XML vs ntext

    Kendal Van Dyke has a video over at sqlshare about what's involved in converting our existing data to the XML data type.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 7, 2011 at 1:17 am

    #1270478

  • RE: How can we extract data from excel file in stored procedures

    http://support.microsoft.com/kb/306397/EN-US/

    Edit: powered by SSC, the Google alternative 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 7, 2011 at 1:13 am

    #1270476

  • RE: Performance tuning tips for beginners

    Before following Gails great articles, you need to understand what the procedure you're trying to improve actually does.

    Therefore, a brief code review is highly recommended (=mandatory).

    Look for the obvious things...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 7, 2011 at 1:07 am

    #1270475

  • RE: An execution error in SSIS 2008 package

    It seems like your package include a step like file access or the like.

    You have several choices: set up a proxy that's allowed to do it or rewrite your DTS...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 7, 2011 at 12:43 am

    #1270466

  • RE: XML vs ntext

    iamanks (1/6/2011)

    Hello Gila, Thanks for the information. We are currently storing xml code in ntext columns. While migrating to SQL 2008, I want to change them all to different datatypes...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 7, 2011 at 12:36 am

    #1270460

  • RE: Doubt clarification

    deepikamm (1/6/2011)

    sorry i am a beginner so it takes time for me to understand it.

    another question

    what are all the basic things i need to check up for tuning any stored...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 7, 2011 at 12:26 am

    #1270454

  • RE: please help very urgent

    qur7 (1/6/2011)

    Thanks for the reply.. I understand it and i know it, unfortunately thats not an option..... any other way ???

    What is the specific reason for not being an option...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 7, 2011 at 12:22 am

    #1270453

  • RE: How do I connect to a Oracle server via SQL Server

    Did you actually follow any of the links I pointed you at? Most of them include a line like "Install Oracle client"...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 7, 2011 at 12:08 am

    #1270446

  • RE: How do I connect to a Oracle server via SQL Server

    Maybe this link will help you getting started.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 6, 2011 at 2:57 pm

    #1270347

  • RE: Trust People

    Hugo Kornelis (1/6/2011)

    Being European, I think soccer when I read the workd football. And because I know next to nothing about football, I'll answer in soccer style.

    The truly great soccer...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 6, 2011 at 2:30 pm

    #1270339

  • RE: From MS-SQL Query (without using xp_CmdShell) how can we Without using Copy a Single or Multiple Files from Server Hard Disk drive to Local system Hard Disk drive?

    An SSIS package together with dedicated service account might be a solution, too.

    But a CLR is most probably easier to design and maintain....


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 6, 2011 at 9:50 am

    #1270183

  • RE: Is there a way to do this without a cursor/loop to process individual records?

    Chad Carter (1/6/2011)

    The most I have seen at one time is a couple of hundred records so we should be OK. I will begin testing with it and getting...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 6, 2011 at 9:04 am

    #1270160

  • RE: Get count for each row

    Are there any duplicates?

    If not, you could simply use

    ROW_NUMBER() OVER(ORDER BY Value) - 1


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 6, 2011 at 8:55 am

    #1270153

  • RE: Number of weeks between two dates

    JenMidnightDBA (1/6/2011)

    mister.magoo (1/6/2011)

    Rem70Rem (1/6/2011)

    This seems to be a good approach, but some year have 52 weeks when some other have 53.

    The DATEPART function has a WEEK datepart that displays the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    January 6, 2011 at 8:35 am

    #1270141

Viewing 15 posts - 2,161 through 2,175 (of 5,502 total)