Forum Replies Created

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

  • RE: SSRS Report error - Unable to connect to the remote server. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.106.52.4:80

    duplicate post. no replies please.

    Original post: http://www.sqlservercentral.com/Forums/FindPost1107782.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]

    May 12, 2011 at 12:22 pm

    #1323905

  • RE: SSRS report error --Unable to connect to the remote server. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.106.52.4:80. Can you please help us about this iss

    duplicate post. no replies please.

    Original post: http://www.sqlservercentral.com/Forums/FindPost1107782.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]

    May 12, 2011 at 12:19 pm

    #1323902

  • RE: select case statement

    The issue is that you most probably have a string with a lenght >14 but without a '.' in between. This will lead to substring(server,1, -1) leading to the error...


    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]

    May 10, 2011 at 4:49 pm

    #1322681

  • RE: Function to calculate fiscal days between two dates

    The easiest solution would be a calendar table with (at least) the date and the corresponding fiscal year.

    The query then simply would be

    SELECT COUNT(*)

    FROM dbo.calendar

    WHERE...


    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]

    May 10, 2011 at 1:19 pm

    #1322612

  • RE: How to break down results into percentages

    Based on your sample data, what would be your expected result and what have you tried so far?


    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]

    May 10, 2011 at 1:10 pm

    #1322608

  • RE: Tune a SQL SP with cursors and dynamic SQL

    The subqueries to populate [Regular] and the like most probably will perform a index scan rather than a seek due to the functions involved (RTRIM(TSP.TspCode) = RTRIM(CodCode)).

    Maybe a CROSS APPPLY...


    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]

    May 7, 2011 at 5:55 am

    #1321377

  • RE: Run MS Excel 2007 macro/vba from MS SQL Server 2008

    You eventually also might be able to perform the calculation on the SQL Server side. Depends on the complexity of the calculation.


    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]

    May 6, 2011 at 4:03 pm

    #1321331

  • RE: UPDATE query question

    TheSQLGuru (5/6/2011)

    Maybe I need another cup of coffee, but I don't see how ROW_NUMBER can help with this classic 'running totals' type of scenario. Best bet for that is...


    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]

    May 6, 2011 at 3:18 pm

    #1321321

  • RE: why does my commit not commit and my rollback not rollback?

    Did you try to run it from SSMS directly and as it's posted in here using a new query window?

    It could be there is a transaction open before your BEGIN...


    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]

    May 6, 2011 at 9:35 am

    #1321106

  • RE: Showing headers without records in the dataset

    You might want to use outer joins between semester, grade and students 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]

    May 6, 2011 at 9:26 am

    #1321100

  • RE: Is there any way to run the query more than 8000 character via openquery?

    Is that really the type of query you're running?

    If so, I simply would use

    SELECT TOP 1 [EmployeeKey],[ParentEmployeeKey],[EmployeeNationalIDAlternateKey],[ParentEmployeeNationalIDAlternateKey]

    ,[SalesTerritoryKey],[FirstName],[LastName],[MiddleName],[NameStyle],[Title],[HireDate],[BirthDate],[LoginID]

    ,[EmailAddress],[Phone],[MaritalStatus],[EmergencyContactName],[EmergencyContactPhone],[SalariedFlag]

    ...


    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]

    May 6, 2011 at 9:22 am

    #1321095

  • RE: UPDATE query question

    I'm talking about a clustered index on field8 and a nonclustered index like

    CREATE NONCLUSTERED INDEX ncindx1 ON table1 (field3,field2) include (field1)


    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]

    May 5, 2011 at 12:34 pm

    #1320624

  • RE: UPDATE query question

    Where is your clustered index?

    Also, you could test if it helps to move field2 from include to the actual index.

    Would you please attach the actual execution plan as .slplan file?...


    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]

    May 5, 2011 at 11:56 am

    #1320606

  • RE: Is there any way to run the query more than 8000 character via openquery?

    How would such a parameter string look like?

    Could you attach a fake sample?

    I'm just wondering what kind of query would require more than 8k for parameter...


    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]

    May 5, 2011 at 11:26 am

    #1320583

  • RE: Running as SysAdmin

    Ninja's_RGR'us (5/4/2011)

    kim.etcheson (5/4/2011)

    We bought a vendor package where the vendor hardcoded the db logon and password in the application that we couldn't change on the database or the app wouldn't...


    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]

    May 5, 2011 at 2:18 am

    #1320250

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