Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 5,109 total)

  • RE: SSIS Catalog / Connection Managers with Expressions

    doughora - Thursday, July 19, 2018 8:23 AM

    Yeah, I played around with that and know that's an option.

    I know I can get...

    Thom~

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

  • RE: Replacing " with nothing

    machzy - Thursday, July 19, 2018 8:17 AM

    Luis Cazares - Thursday, July 19, 2018 8:06 AM

    Thom~

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

  • RE: SSIS Catalog / Connection Managers with Expressions

    Sounds like what you want to use is a package parameter, rather than a variable. Then, prior to execution, you can define the value of that parameter. That will, however,...

    Thom~

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

  • RE: float error in t-sql scalar function

    Don't use float, it's an inaccurate data type, that suffers rounding problems. If you use an accurate data type, such as decimal(12,10), the error doesn't occur,...

    Thom~

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

  • RE: SQL PATCHING

    rangadeckker - Tuesday, July 17, 2018 4:46 AM

    Hay ..

    This is what in the MS support, actually I mean CU updates...

    Thom~

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

  • RE: Left(null,5) 'anything' is not true?

    Because, when comparing to a NULL (for example 1 = NULL)  the return value is "unknown". Unknown is neither true or false, and hence doesn't meet the criteria. To compare...

    Thom~

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

  • RE: SQL PATCHING

    rangadeckker - Friday, July 13, 2018 9:58 AM

    Actually No impact only if you install CU, not Service pack. CU updates does not...

    Thom~

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

  • RE: what is scenario / sa disabled / Active Directory unavailable

    I completely agree that, if you are in a Mixed Authentication environment that you disable the sa account, and create an AD account with the permissions. I also...

    Thom~

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

  • RE: Starting a CTE

    Sean Lange - Thursday, July 12, 2018 7:15 AM

    Was helping somebody just yesterday on another site and they couldn't for the life...

    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?

    ThomasRushton - Friday, July 13, 2018 4:00 AM

    Thom A - Friday, July 13, 2018 3:28 AM

    Thom~

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

  • RE: dbo.SORT temporary run storage error during DBCC CHECKDB

    AP24 - Friday, July 13, 2018 3:27 AM

    10000MB x 4 Data Files

    AP24 - Friday, July 13,...

    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?

    Interesting, Microsoft appearing to be offering an extra 3 years of Extended Support on SQL Server 2008/2008R2 if you rehost your database in Azure. Says to me that Microsoft are...

    Thom~

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

  • RE: dbo.SORT temporary run storage error during DBCC CHECKDB

    Your below statement doesn't make sense:

    On a NEW SQL 2012 Server the tempdb is 200GB (dedicated temp drive) 4 Data Files-1000mb each

    If  your 4 data files were 1000MB...

    Thom~

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

  • RE: SQL Server fior Windows 7

    Sean Redmond - Thursday, July 12, 2018 10:58 PM

    Windows 7 will be running out of support in a year or two's time....

    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?

    I'm actually a little bit glad we (England) lost last night. I'm  on a cycling holiday this weekend to see the Tour de France. I imagine it would have been...

    Thom~

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

Viewing 15 posts - 1,816 through 1,830 (of 5,109 total)