Viewing 15 posts - 421 through 435 (of 5,111 total)
What do you mean by "greater than NULL"? In SQL NULL has the lowest value than any other value, regardless of data type, so are you simply after values that...
September 18, 2020 at 10:47 am
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...
September 17, 2020 at 1:43 pm
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...
September 17, 2020 at 9:47 am
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...
September 17, 2020 at 8:56 am
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...
September 14, 2020 at 2:37 pm
it appears you were wrong in this post
No that is what gets me it is not an IDENTITY field on any of theses tables. so I am not seeing...
September 14, 2020 at 2:07 pm
Posting the definition of the Stored Procedure and the table from the original database will very likely answer this question for us.
September 14, 2020 at 1:46 pm
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...
September 14, 2020 at 8:38 am
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...
September 14, 2020 at 7:46 am
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...
September 8, 2020 at 2:07 pm
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,...
September 8, 2020 at 1:14 pm
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...
September 8, 2020 at 12:47 pm
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...
September 8, 2020 at 9:18 am
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...
September 5, 2020 at 6:31 pm
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...
September 4, 2020 at 4:21 pm
Viewing 15 posts - 421 through 435 (of 5,111 total)