Forum Replies Created

Viewing 15 posts - 826 through 840 (of 5,502 total)

  • RE: Filter Large table using small one

    No, it's not clear yet.

    We still need a definition of "first occurence" as Cadavre already pointed out.

    The following requirement is more than vague:

    I want to add the Path from Smalltable...


    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 3, 2011 at 5:33 am

    #1416281

  • RE: sql query

    Please share what you've tried so far and where you get stuck.


    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 3, 2011 at 5:12 am

    #1416278

  • RE: How to password protect your database on other person's machine and safeguard sql database from windows login

    There is no way whatsoever to 100% secure a database so that NOONE can "re-engineer" it.

    Usually, someone with server based administrative privileges can add a new user. Or the backup...


    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 3, 2011 at 4:30 am

    #1416272

  • RE: Syntax - Open Query - JOIN Linked Server Table with SQL Server Table

    You might not even need a dynamic SQL.

    Did you try the "EXECUTE(query with parameter) AT LinkedServer" approach? You might need to store the returned data in an indexed temp 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]

    December 3, 2011 at 3:09 am

    #1416263

  • RE: sql query

    Did you try the FULL OUTER JOIN syntax?


    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 3, 2011 at 3:02 am

    #1416262

  • RE: service broker

    There are two sources I can recommend for descriptions of SSSB troulbeshooting:

    Rusanus blog[/url] (not limited to the article this link points to) and

    Johans (aka ALZDBA) article[/url].

    Those two should help 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]

    December 3, 2011 at 2:59 am

    #1416261

  • RE: writing a query with joins

    You may have noticed that (by the time I'm writing this reply) almost 50 people did read your post. But noone answered.

    The main reason most probably is the incomplete information.

    In...


    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 3, 2011 at 2:53 am

    #1416260

  • RE: A Welcome Intruder

    I've participated in intrusion/penetration tests, too.

    We thought we were in a good shape until the person we got in to perform the test found a piece of software on our...


    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 1, 2011 at 11:41 pm

    #1415702

  • RE: Access 2010 to SQL 2008 R2 ODBC Error

    tfifield (12/1/2011)

    As a further comment on what Lutz posted. An updatable query in Access may not be updatable when converted to a view on the SQL Server side. ...


    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 1, 2011 at 12:16 pm

    #1415506

  • RE: Help Stored Procedure

    First of all: don't "Dude" me. This is a professional forum and not a kids chatroom.

    Regarding the error:

    Change ORDER BY DESC to ORDER BY ASC in cte_next_id_part


    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 30, 2011 at 2:54 pm

    #1414965

  • RE: Help Stored Procedure

    Hi,

    attached is one way to solve this "puzzle" (assuming I understand the requirement correctly).

    As a side note: please note how I posted the sample data in a ready to use...


    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 30, 2011 at 1:56 pm

    #1414929

  • RE: Access 2010 to SQL 2008 R2 ODBC Error

    There are several possible reasons for this error message:

    1) When using the ACCESS Wizard to link the table, did you mark the identity columns for each table? If not, it...


    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 29, 2011 at 7:22 am

    #1414067

  • RE: Access 2010 to SQL 2008 R2 ODBC Error

    Then it seems like there hass been a connection to SQL Server data before and the front end still using this "old" connection. Maybe it's even a connection to a...


    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 28, 2011 at 12:42 pm

    #1413609

  • RE: table performance

    I strongly vote against the NOLOCK hint!! It's not a "magic run-faster" option. For moredetails about the concequences search this site or google for "nolock hint dirty reads".

    My guess would...


    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 27, 2011 at 8:14 am

    #1413174

  • RE: alter table alter column question regarding how many columns can be altered in 1

    If it's a performance issue you might consider to recreate the table with the proper collation and copy the data into the new table (as already suggested). Rename the 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]

    November 27, 2011 at 7:54 am

    #1413173

Viewing 15 posts - 826 through 840 (of 5,502 total)