Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 3,221 total)

  • RE: Critique: SQL Server Backup and Restore for the Accidental DBA

    Having been in the position you describe, wish I had heard your talk before my hair turned grey. Nice clear description of the position many are thrust into, with...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 11, 2011 at 6:27 pm

    #1310170

  • RE: Are the posted questions getting worse?

    Jeff Moden (4/11/2011)

    WayneS (4/11/2011)

    Jeff, I never did get this. Did you miss my previous post to send it on?

    Apparently so. I'll send it out when I get home tonight....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 11, 2011 at 6:06 pm

    #1310169

  • RE: How to find Row number

    Pink123 (4/11/2011)

    I found the mistake it was the wrong table name ,but this is giving me the rownumber as 1 and showing 1 record .

    How do I get the actual...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 11, 2011 at 8:35 am

    #1309852

  • RE: Total Sums are not correct

    It would help those who want to help you, if you would post the table definition, some sample data and required results from the sample data.

    To do so, please click...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 11, 2011 at 7:58 am

    #1309824

  • RE: Generic User Defined Function to return comma delimited string

    A snippet of code from Jeff Modens article, which can be accessed by clicking on the first link in my signature bloxk

    SELECT 'SELECT ' +...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 10, 2011 at 6:53 pm

    #1309631

  • RE: Are the posted questions getting worse?

    Jeff Moden (4/10/2011)

    bitbucket-25253 (4/10/2011)

    Jeff Moden (4/9/2011)

    Shifting gears real hard, I'm finally done not only testing a fix to the Tally Table delimited string splitter performance problem, but I've also finished...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 10, 2011 at 6:13 pm

    #1309630

  • RE: Are the posted questions getting worse?

    Jeff Moden (4/9/2011)

    Shifting gears real hard, I'm finally done not only testing a fix to the Tally Table delimited string splitter performance problem, but I've also finished the article on...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 10, 2011 at 6:25 am

    #1309604

  • RE: Are the posted questions getting worse?

    Requesting a favor from the denizens of the thread. A fellow member of my user group (ONSIG) is striving to present at meetings such as SQL SAT's and has...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 9, 2011 at 9:45 am

    #1309556

  • RE: Length

    Daniel Pokrývka

    But.. MS says 2 + 2 times the length of the string.. which is not correct in terms of the return value of the function datalength().

    2 + 2...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 9, 2011 at 8:30 am

    #1309543

  • RE: SQL to reorder the table Main_Table by field DteTme

    Read this article on SSC

    Sorting Months By Number (SQL Spackle)

    By Jeff Moden, 2010/11/15

    Here is the link to the article:

    http://www.sqlservercentral.com/articles/T-SQL/71511/

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 8, 2011 at 7:47 pm

    #1309495

  • RE: Length

    kaspencer (4/8/2011)

    Yet another unforgivable mistake by a question setter.

    Let's hang, draw & quarter the lot of 'em.

    Kenneth Spencer

    PS: point back please.

    Now, now ... as one who will have his 39th...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 8, 2011 at 7:42 pm

    #1309493

  • RE: OPENROWSET with parameters...

    Dominic Gagné (4/8/2011)

    Is there any way I can call a storedProc with parameters on a linked server and put the resulting recordset on a local temporary table, like I need...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 8, 2011 at 8:52 am

    #1309232

  • RE: OPENROWSET with parameters...

    OPENROWSET - does NOT accept variables for its arguments.

    Thus you will have to use dynamic sql statements to do what you seem to need to do.

    Use this link:

    http://technet.microsoft.com/en-us/library/ms190312(SQL.90).aspx

    Scroll down to...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 8, 2011 at 7:54 am

    #1309176

  • RE: Length

    Here we go again .... the answer is based on

    NCHAR(n) and based on that the supposed answer is correct

    However (Question text set to Bold and character size altered ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 7, 2011 at 8:45 pm

    #1308921

  • RE: Help with Counting Query

    Thanks for your reply. Now in the spirit of being a community, to help others, would you mind posting your code, so that others may learn how to solve...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    April 7, 2011 at 4:43 pm

    #1308886

Viewing 15 posts - 1,291 through 1,305 (of 3,221 total)