Forum Replies Created

Viewing 15 posts - 1,741 through 1,755 (of 5,109 total)

  • RE: Rollup with Group by

    That query you given won't work as it is, as one it contains at least one syntax error.

    What is the actual results you want here? I think, if...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Read only database + user permission

    NewBornDBA2017 - Friday, August 17, 2018 8:54 PM

    I have a DB which I switched to read only. User couldn't run reports (I...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: conditional update query syntax

    I'm not sure I follow your sample data I'm afraid; is that 2 tables or 3? What is the relationship between the 2/3 tables? What is the expected results here...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSMS and SOS, difference in execution times

    Eirikur Eiriksson - Friday, August 17, 2018 9:45 AM

    Thom A - Friday, August 17, 2018 9:30 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSMS and SOS, difference in execution times

    Eirikur Eiriksson - Friday, August 17, 2018 9:16 AM

    In SOS the fastest queries are roughly 10% slower than in SSMS. I've...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSMS and SOS, difference in execution times

    Eirikur Eiriksson - Friday, August 17, 2018 7:57 AM

    Came a cross a bit of an oddity, execution times  on the same system...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: uninstall report service native

    joujousagem2006 1602 - Friday, August 17, 2018 4:47 AM

    Hello everyone
    I uninstalled the native reporting service component
    but despite that the reportserver base and...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Read Data in Store procedure

    jsshivalik - Friday, August 17, 2018 4:42 AM

    Hi  I want to read data from a table in Stored procedure . Do some...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: The Best Days

    Think one of my best days was in my first full cycle DR test and everything from the DB side of things was up and running by the end of...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: BIDS 2008 - can i insert a column into a comma-delimited flat file after it has been written to?

    You could probably achieve this with a Script task, yes; you could certainly do it with a Script Transformation (but those were introduced with SSDT 2012). Your post, however, seems...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Sergiy - Thursday, August 16, 2018 8:53 AM

    Lynn Pettis - Thursday, August 16, 2018 8:43 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Thursday, August 16, 2018 9:51 AM

    TomThomson - Thursday, August 16, 2018...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: How to a use a temp table as a destination for a dataflow in SSIS

    Phil Parkin - Thursday, August 16, 2018 9:30 AM

    Thom A - Thursday, August 16, 2018 9:21 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: How to a use a temp table as a destination for a dataflow in SSIS

    You could, if you wanted, create the table in tempdb. Although it's not a true "temporary table", it will still only persist for as long as the server is running....

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Why QUOTENAME is important

    Jeff Moden - Thursday, August 16, 2018 6:07 AM

    Thom, thanks again for taking the time to write this article.  It's not only...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 1,741 through 1,755 (of 5,109 total)