Viewing 15 posts - 6,811 through 6,825 (of 59,070 total)
It would be helpful if you posted the CREATE TABLE statement for the table both before and after each change you make to the table. Also, the devil's in the...
July 4, 2020 at 1:53 pm
It would be real helpful if you were to describe what you mean by "it does not work". What isn't it doing and what, if any, are the error messages?
Also,...
July 4, 2020 at 1:30 pm
See the 2nd link in my signature line below on the information you should provide on performance related problems. Thanks.
Okay thanks I'll follow this guideline going forward. Could...
July 4, 2020 at 2:00 am
Developers think its always DBA's fault bcz the query is running slow . Initially they were pulling data to temp tables which we corrected into physical tables and drop...
July 3, 2020 at 12:15 am
See the 2nd link in my signature line below on the information you should provide on performance related problems. Thanks.
July 2, 2020 at 5:04 pm
Our developers are running a huge select query pulling millions of records for a datawarehouse and when examined the query shown no issues in the Executionplan .
Heh... you've correctly...
July 2, 2020 at 4:58 pm
@as1981 ,
Apologies for missing your question on this.
Yes, it's possible to work it out from historical information as you've said but it's still pretty much of a SWAG simply because...
July 1, 2020 at 7:47 pm
I don't know if it will help in this case but you CAN write a unique index with an "Ignore Duplicates" attribute that will simply not insert duplicates and won't...
June 30, 2020 at 8:49 pm
WHERE SUBSTRING([column],CHARINDEX('^',[column],PATINDEX('%PQ5|1|[0-9]%',[column])),4) = '^^^^'If you look at the following post where the OP finally posted some semblance of the data he's actually trying to filter, you'll...
June 29, 2020 at 3:41 pm
A moment of silence, please.
I heard from his family and Mike Vessey, https://www.sqlservercentral.com/author/mvdba, passed away on 25 Jun 2020. I was pleased to meet Mike and host him...
June 29, 2020 at 3:36 pm
Look at the code... I had to write it without being able to run it. You have the advantage of testing. 😀 Look at the ON clause... see the mistake...
June 27, 2020 at 11:01 pm
well, that is way over my head. I have a lot to learn. I understand the Joins and the Alias but is there a way to do it with...
June 27, 2020 at 10:26 pm
I still don't have test data and don't have the time today to make some but this should be close...
WITH cteShift AS
(
SELECT ShiftStartDT...
June 26, 2020 at 11:14 pm
Understood... back in a few...
June 26, 2020 at 10:11 pm
Just posting some solution that you can think of doensot make you pro and doesnot make ignorant.
When someone posts on forum it means that they can't get through documentation(which...
June 26, 2020 at 7:06 pm
Viewing 15 posts - 6,811 through 6,825 (of 59,070 total)