Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 5,502 total)

  • RE: Virtualize or not ?

    Gagne (12/22/2010)

    ...

    Lutz, that sounds like you're saying that generally speaking, virtualizing a SQL Server will impact performance and that it's all a question of whether it will slow it down...


    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]

    December 22, 2010 at 4:20 pm

    #1265737

  • RE: Calculate Customer counts daily

    Here's my approach:

    ; WITH cte AS

    (

    SELECT dt,id,MAX(statusdate) AS max_statusdate

    FROM ReportDate rd

    LEFT OUTER JOIN CustomerInfo ci ON ci.statusdate<=rd.dt

    GROUP BY dt,id

    )

    SELECT

    dt AS [Report DATE] ,

    SUM(CASE...


    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]

    December 22, 2010 at 4:01 pm

    #1265732

  • RE: Virtualize or not ?

    I, personally, find Brent Ozar's blog[/url] very informative ,especially including the comments and the follow-up article. Those two articles combined give a neutral (if possible at all) point of view...


    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]

    December 22, 2010 at 3:25 pm

    #1265723

  • RE: Help needed with code

    Paul,

    it seems like you're not really interested in helping us help you.

    Instead of providing the information we asked for multiple times you decide to open new threads with 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]

    December 22, 2010 at 2:54 pm

    #1265715

  • RE: simple Query error

    Instead of using SELECT * you'd need to specify each column and use alias column names for the duplicates (like a.ACCOUNT, b.ACCOUNT, a.COD, c.CODE and maybe some more columns).

    The reason...


    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]

    December 22, 2010 at 2:33 pm

    #1265711

  • RE: Manipulate String

    JStevenson1 (12/22/2010)

    I have several value in a column called test.

    Select Statement: Select Test From Abc

    Output: JonDoe

    Desired Output: 'JonDoe'

    How do I achieve desired output?

    Something like the following code? (assuming all...


    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]

    December 22, 2010 at 2:23 pm

    #1265705

  • RE: Sql query Output in XML format

    Here's a version that will provide the structure as requested based on Waynes sample data and sample code (Thank you, Wayne!!).

    However, due to the DTD declaration you won't be able...


    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]

    December 22, 2010 at 2:06 pm

    #1265689

  • RE: Are the posted questions getting worse?

    May the Holidays be silent and without any release changes you need to take care of!

    My plan for the Holidays (with my kids):

    We have slightly more snow than...


    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]

    December 22, 2010 at 1:14 pm

    #1265668

  • RE: Sql query Output in XML format

    I'll have a look at it within the next hour. Promise.


    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]

    December 22, 2010 at 12:42 pm

    #1265659

  • RE: Help needed with code

    pwalter83 (12/22/2010)

    I have attached all the relevant documents which are being used for this query. Would that be enough ?

    Here's a short SQL puzzle for you:

    SELECT @answer = result FROM...


    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]

    December 22, 2010 at 12:40 pm

    #1265658

  • RE: Help needed with code

    pwalter83 (12/22/2010)

    Hi LutzM,

    What exactly do you need from my side to resolve this issue ?

    ...

    Please read and follow the instructions given in the first article referenced 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]

    December 22, 2010 at 9:59 am

    #1265601

  • RE: Howto: Produce 1 XML dataset from several queries

    sotn (12/22/2010)

    Hi Lutz,

    thanks for the reply.

    I am a little confused as my previous post shows that my tables have completely different field names and number of fields so I cannot...


    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]

    December 22, 2010 at 7:14 am

    #1265505

  • RE: Howto: Produce 1 XML dataset from several queries

    sotn (12/22/2010)

    Any ideas how to produce this format?

    Yes (concept as mentioned before).

    For a coded version please provide ready to use sample data as described in the first link in my...


    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]

    December 22, 2010 at 6:33 am

    #1265470

  • RE: Help needed with code

    pwalter83,

    please stop reposting the same stuff over and over again.

    You've been asked multiple times to post some additional information and you've been pointed at a link multiple times that will...


    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]

    December 22, 2010 at 4:24 am

    #1265424

  • RE: count no of months n days

    Here's a rather complicated example:

    DECLARE

    @startdate DATETIME,

    @days INT,

    @enddate DATETIME,

    @startyear SMALLINT,

    @startmonth TINYINT,

    @startday TINYINT,

    @endyear SMALLINT,

    @endmonth TINYINT,

    @endday TINYINT

    SELECT @days=149, @startdate='20100825'

    SELECT @enddate=DATEADD(dd,@days,@startdate)

    SELECT

    @startyear =YEAR(@startdate),

    @startmonth =MONTH(@startdate),

    @startday =DAY(@startdate),

    @endyear =YEAR(@enddate),

    @endmonth =MONTH(@enddate),

    @endday =DAY(@enddate)

    SELECT

    @startdate,

    @enddate,

    CASE

    WHEN @startyear <> @endyear...


    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]

    December 21, 2010 at 4:34 pm

    #1265322

Viewing 15 posts - 2,356 through 2,370 (of 5,502 total)