Forum Replies Created

Viewing 15 posts - 526 through 540 (of 5,502 total)

  • RE: Performance Issues on Production - Having to run DBCC FREEPROCCACHE

    Based on the brief description it sounds like parameter sniffing. You might want to check Gails blog series[/url] for details and solutions.

    If FREEPROCCACHE solves the issue and there are just...


    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]

    March 9, 2012 at 12:17 pm

    #1457348

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (3/8/2012)

    7000 and 4000 are 😛

    Divisible by 2, 5, 10, 100 and 1000 (and a lot more!)

    You might have a different point of view then:

    8000 is a round number....


    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]

    March 8, 2012 at 3:10 pm

    #1456839

  • RE: Problem grouping records

    What is your expected result? Are you looking for the min amount or max or sum or avg?

    In case you're looking for the "first" amount, we'd need to know what...


    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]

    March 8, 2012 at 2:32 pm

    #1456820

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (3/6/2012)

    ...

    Back off-topic: apparently SQL Server 2012 RTM is released (evaluation edition).

    General availability is for the first of April. Why does that make me skeptical?

    MS seems to start evaluating...


    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]

    March 6, 2012 at 2:54 pm

    #1455610

  • RE: Suggestions for inserting 420 million rows into a table?

    I'd export the data using bcp and import it into the target db using bcp again.

    Make sure the target db is set to bulk-logged recovery or Simple recovery.

    The current approach...


    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]

    March 5, 2012 at 12:58 pm

    #1454972

  • RE: How to select values

    If you decide to go for the "split string solution", at least use the "fast lane"[/url] and not the "pedestrian walk" 😉


    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]

    March 5, 2012 at 8:37 am

    #1454827

  • RE: Problems to UPDATE Float Field to NVARCHAR Field....Help me, please

    sanmon_11 (3/5/2012)

    Hi Lutz,

    In the Query:

    SELECT CAST(CAST(MotorEns_NoSerie AS NUMERIC(13,0)) AS VARCHAR(13)) FROM tbl_MotorEns

    I got this Error:

    Msg 8115, Level 16, State 6, Line 1

    Arithmetic overflow error converting float to data type numeric.

    any...


    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]

    March 5, 2012 at 7:19 am

    #1454785

  • RE: Simplify result set

    Wouldn't a simple DISTINCT do the job?


    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]

    March 4, 2012 at 1:16 pm

    #1454599

  • RE: How to select values

    You could use an auxiliary table with username and Location (having three rows for user 'Ram' and three separate rows for user 'Krishna'.

    Then query this table using the CROSS APPLY...


    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]

    March 4, 2012 at 9:13 am

    #1454569

  • RE: Joining 2 Counts Help (Thank you in advance)

    You have different column names in GROUP BY. Would it be possible to have some sample data in a ready to use format (see the first link in my signature...


    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]

    March 4, 2012 at 3:13 am

    #1454537

  • RE: SQL Server Licencing

    Hence my point. When KNAPP does it it seems legal. when others do it it seems we are touching on infringement

    If it is OK for Knapp to pass every pickers...


    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]

    March 3, 2012 at 6:31 pm

    #1454505

  • RE: SQL Server Licencing

    We're currently in a similar discussion and decided to go a slightly different route:

    We asked MS to provide us with a legal ("bullet-proof") definition of a "device", since it can't...


    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]

    March 3, 2012 at 4:36 pm

    #1454499

  • RE: Problems to UPDATE Float Field to NVARCHAR Field....Help me, please

    You could try CAST(CAST(YourColumn AS NUMERIC(x,0)) AS VARCHAR(x)), where X is the number of digits you need to store. This under the assumption that you don't have serial numbers with...


    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]

    March 3, 2012 at 8:33 am

    #1454445

  • RE: Problems to UPDATE Float Field to NVARCHAR Field....Help me, please

    There are several questions:

    The most important one: why do you need to change a numeric value to a character value? What changed in the business case?

    Why is the 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]

    March 3, 2012 at 2:10 am

    #1454424

  • RE: How to use Pivot for Two Columns

    Step 1 would be to use datetime column instead of separate columns for year and moth.

    Then you'd be able to use PIVOT. Not just for PIVOT but as a better...


    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]

    March 3, 2012 at 2:03 am

    #1454422

Viewing 15 posts - 526 through 540 (of 5,502 total)