Forum Replies Created

Viewing 15 posts - 856 through 870 (of 5,502 total)

  • RE: Can someone tell me how to write this query? Thanks

    Maybe one reason for not getting an answer yet is the holiday in the U.S. ....

    Another reason might be that "timestamp" refers to a "unique binary number within a database"...


    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]

    November 24, 2011 at 12:59 pm

    #1412777

  • RE: Hi , How to check how many servers are there and information at a time in one command

    You might want to have a look at Quests Discovery Wizard[/url].


    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]

    November 23, 2011 at 2:42 pm

    #1412495

  • RE: Using T-SQL to manipulate Excel files in a SQL Table

    Revenant (11/22/2011)

    jdrintnt (11/22/2011)

    . . .

    Can someone point me to an article or white-paper with more info on reading Excel XLSX files into SQL Server, and writing them back out again...


    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]

    November 22, 2011 at 11:28 pm

    #1411950

  • RE: Using T-SQL to manipulate Excel files in a SQL Table

    To repeat what I stated before:

    To load an Excel XML file into SQL Server you could use a linked server, OPENROWSET or XML bulk load. Which one to use depends...


    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]

    November 22, 2011 at 4:45 pm

    #1411909

  • RE: Enumerating column names

    krypto69 (11/22/2011)

    ...

    Is there a way in SQL to have as part of my query the column names enumerated (numbered in order)?

    Simple answer: no. And that's just because there is no...


    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]

    November 22, 2011 at 2:06 pm

    #1411810

  • RE: Using T-SQL to manipulate Excel files in a SQL Table

    Can you provide an example of what you're trying to accomplish?

    (E.g. sample of the normalized table and the final Excel result including an explanation of the transformation rules).

    To load an...


    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]

    November 22, 2011 at 1:45 pm

    #1411791

  • RE: Using T-SQL to manipulate Excel files in a SQL Table

    If the major issue is the export time into Excel you might look into changing this method before completely rewriting the code:

    Do you have some sort of WHILE loops that...


    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]

    November 22, 2011 at 11:49 am

    #1411731

  • RE: Are the posted questions getting worse?

    Evil Kraig F (11/15/2011)

    Ninja's_RGR'us (11/15/2011)

    Someone can cover for me here... need to go!

    ttp://www.sqlservercentral.com/Forums/Topic1206207-1549-1.aspx

    Linkie no workie

    Try this one: (included the leading "h")

    http://www.sqlservercentral.com/Forums/Topic1206207-1549-1.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]

    November 15, 2011 at 12:05 pm

    #1408110

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/14/2011)

    Steve Jones - SSC Editor (11/14/2011)

    Gianluca Sartori (11/14/2011)

    Congrats Jason for winning T-SQL challenge 63!

    +1, congrats

    Danke

    Herzlichen Glückwunsch! 😛

    When did they start to allow solutions other than a single query?

    (It's been...


    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]

    November 14, 2011 at 12:26 pm

    #1407481

  • RE: view time out

    Are the databases on the same instance or will it query data off a different instance/server?

    It seems like the view needs some tuning (or even using a divide'n'conquer approach).

    Can you...


    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]

    November 13, 2011 at 3:24 pm

    #1406877

  • RE: Problem connecting Access 2010 to SQL express 2008 via ODBC

    Can you connect to the database using Management Studio and logon as the test user you're trying to use with ACCESS? (First step: figure out if it's a SQL permission...


    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]

    November 12, 2011 at 12:38 pm

    #1406745

  • RE: tempdb 35 GB using by query statement- Help

    It seems like there's no clustered index on the table.

    Based on the information provided so far I recommend to make cmmac the clustered index.

    After that, rerun the query and 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]

    November 12, 2011 at 3:07 am

    #1406656

  • RE: Permissions on tables

    Look up sp_helprotect in BOL. It should return what you're looking for. But keep in mind that it "does not return information about securables that are introduced in SQL Server...


    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]

    November 11, 2011 at 1:52 pm

    #1406587

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/11/2011)

    What other Threadizins are participating in the DBA in Space contest? Looking for launch buddies!

    Done. Care to return the favor? -> buddies

    TIA 😎

    As a side note: that...


    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]

    November 11, 2011 at 1:26 pm

    #1406579

  • RE: DEADLOCK problem in our production DB

    You might want to have a look at Bart Duncans blog for a description on how to troubleshoot deadlocks.


    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]

    November 8, 2011 at 2:32 pm

    #1404855

Viewing 15 posts - 856 through 870 (of 5,502 total)