Forum Replies Created

Viewing 15 posts - 751 through 765 (of 5,109 total)

  • Reply To: Are the posted questions getting worse?

    Sergiy wrote:

    Isn’t it a kinda shame to have such queries exposed on a specialised site of SQL Server professionals?

    Could we form a group of volunteers who could fix this terrible...

    Thom~

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

    October 4, 2019 at 7:54 am

    #3685917

  • Reply To: Is it a bad idea to create a user-defined stored procedure in SSISDB database?

    Scott In Sydney wrote:

    I've got that script working and have attached it to this post.

    Actually you didn't attach it, but don't. You'll be better off putting the relevant code in a...

    Thom~

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

    October 4, 2019 at 7:51 am

    #3685914

  • Reply To: Are the posted questions getting worse?

    Luis Cazares wrote:

    And it all happened because apparently the CoC specifies that users must be referred using their preferred gender pronouns. Not even gender neutral writing seems to be accepted.

    How does...

    Thom~

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

    October 3, 2019 at 8:02 am

    #3685587

  • Reply To: Are the posted questions getting worse?

    Steve Jones - SSC Editor wrote:

    I wonder if more of us ought to be using UTC or at least datetimeoffset for applications. There are more and more that are crossing time zones and it...

    Thom~

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

    October 2, 2019 at 3:08 pm

    #3685317

  • Reply To: Are the posted questions getting worse?

    Chris Harshman wrote:

    Sean Lange wrote:

    LOL pretty much. It really is shocking how many people still use varchar for dates and sql injection.....

    Ugh... you had to bring up that memory for me!  I...

    Thom~

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

    October 2, 2019 at 2:37 pm

    #3685305

  • Reply To: Are the posted questions getting worse?

    Sean Lange wrote:

    Yeah I am in the same boat. They improved things quite a bit around the same time the traffic around here dropped significantly. Funny how often you and I...

    Thom~

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

    October 2, 2019 at 8:09 am

    #3685224

  • Reply To: * to 1

    You can replace the * with whatever you want (often people will use 1 or NULL yes). It shouldn't, however, have any effect on the performance however.

    Thom~

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

    October 1, 2019 at 8:12 pm

    #3685123

  • Reply To: Are the posted questions getting worse?

    Robert Sterbal wrote:

    SE = Stack Exchange?

    SO = Stack Overflow?

    Yep. Stack Overflow is just one site within the Stack Exchange Community. I think they have well over 100 now.

    Steve Jones - SSC Editor wrote:

    I like SO/SE...

    Thom~

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

    October 1, 2019 at 7:28 pm

    #3685107

  • Reply To: Are the posted questions getting worse?

    Realise that the site is disliked by many (I agree that the community isn't as robust as it is here, or as well knit with many of you having  meets...

    Thom~

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

    October 1, 2019 at 11:33 am

    #3684930

  • Reply To: Determine user SSIS package run as

    A server doesn't run SSMS; SSMS is an application used to Interact with SQL Server (which your server will be running).

    When you run a package from the Agent, it'll be...

    Thom~

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

    September 30, 2019 at 12:53 pm

    #3684527

  • Reply To: Default Error Logs

    Interestingly, that documentation doesn't appear to be correct for the Linux release at all. You cannot Configure the Logs on the Linux version (see below which is Linux vs Windows):

    Thom~

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

    September 30, 2019 at 10:14 am

    #3684498

  • Reply To: Microsoft SQL Server 2008 CTP, November 2007 x64 on Windows 2003 install problem

    johnspetrik12 wrote:

    If you have earlier installed a CTP build of SQL Server 2008 you may also be influenced by this problem so please read this mindfully.

    If you have Visual Studio...

    Thom~

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

    September 20, 2019 at 3:34 pm

    #3681958

  • Reply To: Backup & Restore

    What's the SQL you're running to restore the Backup? Are you using WITH MOVE ... TO syntax (as shown in the documentation here)?

    Thom~

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

    September 20, 2019 at 7:53 am

    #3681709

  • Reply To: how to call same logic using different parameter in if then else stored procedur

    Thanks for the SQL, but what's the problem here? How can we help you?

    Thom~

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

    September 19, 2019 at 4:06 pm

    #3681494

  • Reply To: Using a CTE in a subquery

    drew.allen wrote:

    Also, get rid of the DISTINCT.  UNION already does a distinct, so specifying DISTINCT here just clutters up your code with no benefit.

    Drew

    Good spot Drew.

    Thom~

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

    September 19, 2019 at 3:01 pm

    #3681445

Viewing 15 posts - 751 through 765 (of 5,109 total)