Forum Replies Created

Viewing 15 posts - 3,181 through 3,195 (of 5,109 total)

  • RE: Are the posted questions getting worse?

    Ed Wagner - Friday, September 8, 2017 8:42 AM

    Chris Harshman - Friday, September 8, 2017 6:54 AM

    Thom~

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

  • RE: Can't connect to SQL Server via IP

    This sounds like the problem it network related rather than the SQL Server's fault.  Is there any reason why the machine is not part of a domain? This will likely...

    Thom~

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

  • RE: This may be due to a connection failure, timeout or low disk condition within the database

    How long does the it take for this message to appear once you open the report; is it quite quick, or after a little while? Is SSRS running on the...

    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?

    Grant Fritchey - Friday, September 8, 2017 5:32 AM

    Fellow Threadizens!

    Today is my last day of work before Red Gate makes me take...

    Thom~

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

  • RE: Huge volume of .ldf file causing drive full frequently.

    Arsh - Thursday, September 7, 2017 5:53 AM

    Thom A - Thursday, September 7, 2017 3:23 AM

    Thom~

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

  • RE: Huge volume of .ldf file causing drive full frequently.

    anjang2k - Thursday, September 7, 2017 3:31 AM

    We are using FULL. No we are not doing frequent log backup.Taking backup of...

    Thom~

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

  • RE: Huge volume of .ldf file causing drive full frequently.

    What Recovery Model are using, and if (I assume correctly) you are using FULL, are you doing frequent log backups? How often is "frequent"?

    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?

    Neil Burton - Thursday, September 7, 2017 1:01 AM

    That basically sums it all up.  There is an application being developed (From...

    Thom~

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

  • RE: Query Help

    vijay.singh 46672 - Thursday, September 7, 2017 1:53 AM

    1) Order by the data by Date and Rlst Descending.
    2) Store top 5 values...

    Thom~

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

  • RE: Call a webservice from T SQL

    emanuele 8962 - Thursday, September 7, 2017 1:42 AM

    Thom A - Thursday, September 7, 2017 1:37 AM

    Thom~

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

  • RE: Not at all, but we almost upset

    Jeff Moden - Wednesday, September 6, 2017 8:49 PM

    Looks like the data wasn't the only thing that disappeared.  The OP has now...

    Thom~

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

  • RE: Call a webservice from T SQL

    You can use SSIS to call a web service. You can't do it directly with T-SQL.

    Thom~

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

  • RE: Query Help

    vijay.singh 46672 - Wednesday, September 6, 2017 11:17 PM

    Hi,
    Please find the attached excel and import into DB.  In the attached file for...

    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?

    Chris Harshman - Wednesday, September 6, 2017 9:18 AM

    Thom A - Wednesday, September 6, 2017 2:50 AM

    Thom~

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

  • RE: [SOLVED] Return IDs that are x% higher than the average

    A CTE would be a better option:
    WITH AboveAvg AS (
      SELECT ID, [Open_Time],
                 CASE WHEN [Open_Time] > AVG([Open_Time]) OVER () * 1.5 THEN...

    Thom~

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

Viewing 15 posts - 3,181 through 3,195 (of 5,109 total)