Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 5,502 total)

  • RE: Date conversion problem

    Something like this?

    DECLARE @t VARCHAR(40)

    SET @t='Thu Aug 5 12:14:49 GMT-0400 2010'

    SELECT CAST(LEFT(STUFF(@t,1,4,''),6) + ' ' + RIGHT(@t,4) + ' '+ LEFT(RIGHT(@t,22),8) AS DATETIME)

    As a side note: the time zone information...


    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]

    June 15, 2011 at 12:58 pm

    #1339244

  • RE: query for continuous period

    You might want to have a look at the following blog for a better performing alternative:

    http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/sql-and-contiguous-data-ranges.aspx


    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]

    June 15, 2011 at 12:23 pm

    #1339209

  • RE: SQL server management studio express ver 9.00.2047.00

    I don't think it's an issue of the SQL Server version.

    A quick google search returned this link (among others).

    Did you try to connect to the database using SQL Server Management...


    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]

    June 14, 2011 at 3:23 pm

    #1338691

  • RE: Filling in the inbetweeners

    I'd say add another post to this thread. To pen another thread regarding the same issue doesn't make that much sense and if you'd simply edit your first post folks...


    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]

    June 13, 2011 at 12:14 pm

    #1337963

  • RE: Filling in the inbetweeners

    You may have noticed that there's no response yet.

    One possible reason is the way the question is posted: some of us simply will skip a post if we have to...


    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]

    June 13, 2011 at 10:41 am

    #1337901

  • RE: Stored Proc Benchmarking

    And what is your question (assuming there is one)?


    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]

    June 13, 2011 at 10:36 am

    #1337896

  • RE: Sql "incremental" Backups

    GilaMonster (6/10/2011)

    LutzM (6/10/2011)

    Some folks refer the transaction log backup as an incremental log backup though....

    I can call a horse a car, doesn't make it one. Incremental backups != transaction log...


    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]

    June 10, 2011 at 11:13 am

    #1337156

  • RE: Sql Differential Backups

    A differential backup only holds the "information" (data, DDL, sprocs and the like) that changed since the last full or file backup. "Changed" basically means that the related transaction completed...


    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]

    June 10, 2011 at 11:05 am

    #1337150

  • RE: Sql "incremental" Backups

    There is no "incremental" database backup. It's called "differential" backup.

    Some folks refer the transaction log backup as an incremental log backup though....

    Rest of the answer: see your other post 😉


    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]

    June 10, 2011 at 10:49 am

    #1337129

  • RE: Using CTE to do multiple Updates to table

    Ouch. My fault. That's what's happening if I start posting untested code...

    Go for the 2nd version I posted (using the CTE and CrossTab approach).

    If you're dealing with a multi-mill table...


    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]

    June 9, 2011 at 5:06 pm

    #1336775

  • RE: Using CTE to do multiple Updates to table

    Glad I could help 😀

    Did you verify the actual exection plan of the current solution to see if there might be an index to even speed it up further?

    Regarding 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]

    June 9, 2011 at 3:06 pm

    #1336741

  • RE: Using CTE to do multiple Updates to table

    Here are two possible scenarios. But since I don't have anything to test against regarding correct results and performance (e.g. comparing execution plans), you'd need to test both and compare.

    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]

    June 9, 2011 at 1:48 pm

    #1336701

  • RE: Are the posted questions getting worse?

    GilaMonster (6/9/2011)

    I post too much.

    Congrats, Gail!!

    And thank you for continuously sharing your knowledge!


    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]

    June 9, 2011 at 1:06 pm

    #1336662

  • RE: Indexed Views

    My question is that Should we use the indexed views or not.

    Maybe. Maybe not. Depends on various items (e.g. business process, table size, hardware, numberof calls etc.).

    What are the pros...


    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]

    June 8, 2011 at 2:11 pm

    #1335944

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (6/8/2011)

    Roy Ernest (6/8/2011)

    Does going down the stairs and way to the back of the office towards the beach to take a smoke break count for this? 🙂

    That's not...


    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]

    June 8, 2011 at 12:15 pm

    #1335870

Viewing 15 posts - 1,396 through 1,410 (of 5,502 total)