Forum Replies Created

Viewing 15 posts - 271 through 285 (of 5,502 total)

  • RE: i want to have my primary key as output , when i insert a record!

    duplicate post. No replies please.

    Please use the original 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]

    December 28, 2013 at 3:35 am

    #1676200

  • RE: uniqueidentifier as identity field

    I strongly vote for using a stored procedure instead of the direct Insert.

    There are numerous reasons, one of them is to separate the database structure from the application layer. 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]

    December 28, 2013 at 3:33 am

    #1676198

  • RE: i want to have my primary key as out put , when i insert a record!

    You might also want to have a look into the OUTPUT clause.

    This would help to avoid the additional SELECT to get the related Poll_ID.


    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 28, 2013 at 3:27 am

    #1676197

  • RE: Select is Slow

    To me it sounds like a combination of paging and catch-all-queries.

    Therefore, a combination of Gails catch-all article[/url] together with Pauls Optimising Server-Side Paging[/url] should get you startet.


    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 18, 2013 at 12:18 am

    #1674291

  • RE: Put data directly into DataTable or dot net object ?

    Based on your description

    I need to iterate a result set, do some simple processing on it and then write that processed data to a file or even a database.

    I'm...


    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 16, 2013 at 11:44 am

    #1673826

  • RE: Put data directly into DataTable or dot net object ?

    Why not doing all the data manipulation inside the 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]

    December 16, 2013 at 11:20 am

    #1673821

  • RE: Will SQL Server 2014 Support to Read BLOB (Byte Array)

    can you provide a test scenario so we can better understand what you're trying to do?


    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 15, 2013 at 10:27 am

    #1673547

  • RE: Stored procedure excution plan reuse

    As to my knowledge you cannot overrule each and every situation where SQL Server need to recompile a sproc.

    There are numerous situations where SQL Server may "decide" to recompile 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]

    December 15, 2013 at 8:25 am

    #1673534

  • RE: What are the Pros and Cons of SSRS subscriptions?

    The answer is rather simple: it depends.

    If there's a dedicated report server doing nothing but providing reports and there's a business oriented security model implemented (e.g. all reports are based...


    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 15, 2013 at 8:18 am

    #1673533

  • RE: Entering Value by the User

    please note that the very same question (just slightly rephrased) can be found at


    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 15, 2013 at 8:11 am

    #1673532

  • RE: sp_send_dbmail attachments

    You're talking about a proxy account being local admin on the machine holding the file.

    So I'd guess you're talking about a SQL agent job. Or am I missing something?

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

    December 15, 2013 at 8:06 am

    #1673531

  • RE: Select is Slow

    yuvipoy (12/14/2013)

    ...where he can scroll through the records of 1 million rows... .

    [sarcasm ON]

    If the company can afford to pay someone to scroll through one million rows, they'll definitely have...


    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 15, 2013 at 7:55 am

    #1673530

  • RE: Put data directly into DataTable or dot net object ?

    What you've described so far is HOW you do your corrent task. But not, WHAT this task really is.

    If you'd describe the task you're faced with, we might 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 15, 2013 at 7:42 am

    #1673525

  • RE: DatabaseMail

    "It's not working" doesn't really help us to help you in any way.

    What's the exact error message you receive?


    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 15, 2013 at 7:38 am

    #1673524

  • RE: Avoiding Large Number of db Columns in SQL Server - Database Redesign

    If you need to know the auto-generated identity value of the rows that has been added you could use the OUTPUT clause within your first INSERT statement together 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 5, 2013 at 11:51 am

    #1671269

Viewing 15 posts - 271 through 285 (of 5,502 total)