Forum Replies Created

Viewing 15 posts - 421 through 435 (of 5,109 total)

  • Reply To: Conditional Formatting with SSRS

    Parker Smith wrote:

    As a practical note, I recommend not leaning too heavily on color to provide meaning - color-blindness is more common than you think! Bold, italic, and underline provide more...

    Thom~

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

    September 17, 2020 at 1:43 pm

    #3789161

  • Reply To: How to Pivot values stored as rows not columns

    Using the sample data from above (with a couple of correction), you can use a cross tab to achieve what you're after:

    SELECT MAX(CASE B.ColumnName WHEN 'ID' THEN...

    Thom~

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

    September 17, 2020 at 9:47 am

    #3789077

  • Reply To: SSIS 2008 to SSIS 2016 Upgarde

    If you are asking can you open, and upgrade packages in VS 2017 that were created in BIDS, then yes, you can.

    There has been a wealth of changes since SSDT...

    Thom~

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

    September 17, 2020 at 8:56 am

    #3789060

  • Reply To: Ssis memory Advice

    frederico_fonseca wrote:

    and is SSIS running packages through SSIS Catalog, filesystem or msdb? 32 bit or 64 bit?

    Certainly won't be SSISDB, it wasn't available back in SQL Server 2008, and it's...

    Thom~

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

    September 14, 2020 at 2:37 pm

    #3788332

  • Reply To: Question on a stored procedure

    it appears you were wrong in this post

    itmasterw 60042 wrote:

    No that is what gets me it is not an IDENTITY field on any of theses tables. so I am not seeing...

    Thom~

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

    September 14, 2020 at 2:07 pm

    #3788315

  • Reply To: Question on a stored procedure

    Posting the definition of the Stored Procedure and the table from the original database will very likely answer this question for us.

    Thom~

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

    September 14, 2020 at 1:46 pm

    #3788300

  • Reply To: Need help with following weird syntax

    My Personal question is why is the query using NOLOCK against every table, and why is there an TOP clause when there's no ORDER BY? That query is really likely...

    Thom~

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

    September 14, 2020 at 8:38 am

    #3788205

  • Reply To: Retrieving the total number of records in a SQL instance

    Jeff Moden wrote:

    tarr94 wrote:

    Hi Jeff,

    I was asked to pull this information because our cyber insurance company wants an approximation of the total number of rows across all SQL instances.  I imagine...

    Thom~

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

    September 14, 2020 at 7:46 am

    #3788196

  • Reply To: How can I improve its query speed?

    AhTu_SQL2k+ wrote:

    Many thanks for your advice. After added "Order by" to those "Top 1" subqueries, its speed has improved dramatically. The original query speed was 2 mins and now has...

    Thom~

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

    September 8, 2020 at 2:07 pm

    #3786996

  • Reply To: How can I improve its query speed?

    Sergiy wrote:

    Actually, only 3 out of 7 have TOP 1.

    looks like lousy attempt to eliminate "subquery returned more than 1 row" error when occurred.

    well, the whole thing looks lousy.

    You're right,...

    Thom~

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

    September 8, 2020 at 1:14 pm

    #3786966

  • Reply To: How can I improve its query speed?

    Sergiy wrote:

    and why all those "apply"s? Is JOIN outlawed or something?

    All their queries in their APPLY's have a TOP 1 (without an ORDER BY) so that would explain the...

    Thom~

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

    September 8, 2020 at 12:47 pm

    #3786955

  • Reply To: How can I improve its query speed?

    Getting the query plan will really help us help you here. Can you post the query plan for us please? You can either attach it to your post, or if...

    Thom~

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

    September 8, 2020 at 9:18 am

    #3786902

  • Reply To: SQL query question

    In regards to points 1 and 3, an Index will be useless to the RDBMS is you're using something like WHERE Column1 = ISNULL(@Param1, Column1). You need to use proper...

    Thom~

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

    September 5, 2020 at 6:31 pm

    #3786609

  • Reply To: Retrieving the total number of records in a SQL instance

    If you're happy with approximations, then you can use one of the techniques outlined in the article How to count the number of rows in a table in SQL...

    Thom~

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

    September 4, 2020 at 4:21 pm

    #3786450

  • Reply To: Retrieving the total number of records in a SQL instance

    Do you want an accurate count, or are you happy with an approximation?

    Thom~

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

    September 4, 2020 at 4:06 pm

    #3786446

Viewing 15 posts - 421 through 435 (of 5,109 total)