Forum Replies Created

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

  • RE: "Out of Memory" Querying MySQL from MSSQL Linked Server

    Did you try use OPENQUERY to force the ORDER BY being performed at the MySQL side before transferring the data?

    What happens if you run that query directly at the MySQL...


    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]

    January 28, 2015 at 3:56 pm

    #1773846

  • RE: Need assistance with SQL Pivot

    Something like this?

    SELECT

    MAX(CASE WHEN name ='Name' THEN data ELSE NULL END) AS Name,

    MAX(CASE WHEN name ='Email' THEN data ELSE NULL END) AS Email,

    MAX(CASE WHEN ...


    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]

    January 28, 2015 at 3:02 pm

    #1773827

  • RE: Getting an error when trying to duplicate some code off of a website. What have I done wrong?

    The description in the original link is somewhat misleading:

    the part related to "create function..." and the following part "While EXISTS..." are both part of the same function.

    The function should look...


    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]

    January 19, 2015 at 2:49 pm

    #1771245

  • RE: Looping through Cursor and executing Stored Procedure. Stored procedure runs only once for one record

    @Lowell: I tend to disagree that design you posted will actually work as expected (beyond the typo FETCH NEXT FROM MynewCursor without moving INTO @item, @oper_num to the end, too):

    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]

    January 19, 2015 at 2:11 pm

    #1771240

  • RE: Clustered Index and Non-Clustered Index

    lokesh.shukla-634965 (1/3/2015)

    Thanks Sujeet, for your nice comments and the link provided.

    But, my 2nd question is still not better understood (How clustered index and non-clustered index are related?).

    Can you elaborate 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]

    January 3, 2015 at 2:58 am

    #1767535

  • RE: Restrict access to Database

    Steve Jones - SSC Editor (1/2/2015)

    Be aware that anyone can spoof the application name in their connection string. In practice, it probably doesn't happen, but just be aware you 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]

    January 2, 2015 at 11:15 am

    #1767453

  • RE: Clustered Index and Non-Clustered Index

    A slight correction regarding the clustered index:

    The sort oder is not physical (in terms of sequential location on a spindle), but logical.

    See Gails article[/url] for a great explanation. (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]

    January 2, 2015 at 9:28 am

    #1767424

  • RE: Automatic reminder emails two business days before event

    Step 1: create a calendar table that also include a column to flag a business day (e.g. tinyint with constraint 0,1). There are numerous blogs on how to build 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 31, 2014 at 8:01 am

    #1767189

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    Here are a few links that might help you to get started with understanding the different data types:

    How Access sees SQL Server data types

    and

    Data Structure Differences (Old,...


    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 29, 2014 at 3:37 pm

    #1766878

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    I've done more than one project where an app originally started with ACCESS only being converted to SQL Server back end and ACCESS as a frontend.

    It's doable but there are...


    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 24, 2014 at 11:12 am

    #1766371

  • RE: How to merge multiple rows into one row

    I'd vote against a denormalized table. Stick with your current design at the table level.

    If needed for an application layer you could use a pivoted view to display it 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 24, 2014 at 9:54 am

    #1766360

  • RE: Are the posted questions getting worse?

    Yeha!!! It's spam time again! :angry: :crying:


    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 24, 2014 at 9:49 am

    #1766358

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    The major question is: How important is this database for your company?

    Will it change anything if, after a year or so, the system crashes and becomes unavailable and/or if 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 24, 2014 at 9:27 am

    #1766355

  • RE: performance optimization of selecting more than 140 columns with over 3000 MB of data

    For the part of your question:

    To send 3GB across a network and process it a the client side takes a while.

    I can't think of any scenario why the display of...


    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 24, 2014 at 8:37 am

    #1766343

  • RE: Date Table

    Stupid error.... :crazy:

    Replace

    DATEADD(yy,x.N,DATEADD(dd,Number,@FY+'0401')) as FDay,

    with

    DATEADD(dd,Number,DATEADD(yy,x.N,@FY+'0401')) as FDay,

    The first line add the year after the number of days are added. This leads to ignoring leap years if the start year...


    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 24, 2014 at 3:17 am

    #1766313

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