Viewing 15 posts - 1,126 through 1,140 (of 2,917 total)
I agree with ZZartin and even have a sample script that replicates this behavior:
CREATE TABLE #tmpTable (id INT)
GO
SET STATISTICS IO ON
INSERT INTO [#tmpTable]
(
[id]
)
VALUES
(
0-- id - int
)
INSERT INTO...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 14, 2021 at 7:21 pm
There are a few things I'd check.
In no particular order:
I'd try to create a new job, run it, and see if it logs the job history. It could be something...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 14, 2021 at 7:09 pm
ok, so step 1 from what I had was to get all of the job status's within the timeframe. The query you have handles that, but I'd pull out some...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 14, 2021 at 5:37 pm
That approach works if you are storing it in a table. Just add that as a column to the table.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 10:03 pm
It depends entirely on the approach you want to take and how you are planning on storing the data permanently.
Is this data going into a table or is it generated...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 9:36 pm
As for generating a checksum, this is entirely possible, but it depends on how you want to handle it and what you plan to do with it.
If I understand the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 9:14 pm
First thing I'd be curious about is with the wait stats for PAGEIOLATCH_SH being over 2 million, is that for that one job OR since the instance started?
Quick google on...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 7:33 pm
Sorry, my query had a typo in it - I missed giving the quantifier for the part number in the CTE.
This one should work better:
DECLARE @MaskChar CHAR(1)...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 6:22 pm
It is definitely possible, but does become more challenging based on what you have in your original query. What would probably be easier would be something more like this:
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 4:37 pm
I expect that auto-scaling would make the AWS space grow, but it shouldn't make TEMPDB grow past the limits you put in place.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 3:53 pm
Does this work:
SELECT
[finalDatapc].[familyid]
, [finalDatapc].[PartNumber]
, [finalDatapcMask].[MaskNumber]
FROM[getfinaldatapc] AS [finalDatapc]
JOIN[getfinaldatapcmask] AS [finalDatapcMask]
ON [finalDatapcMask].[familyid] = [finalDatapc].[familyid]
AND
(
LEFT([finalDatapc].[PartNumber], LEN([finalDatapc].[PartNumber]) - 1) = LEFT([finalDatapcMask].[MaskNumber], LEN([finalDatapcMask].[MaskNumber]) - 1)
AND RIGHT([finalDatapc].[PartNumber], 1)NOT LIKE...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 3:49 pm
Are you able to capture the execution plan for these? That could help determine what is actually happening. Do the queries run just as slow if you run them in...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 3:30 pm
I don't have ALWAYS ON configured on any of my instances as we have a different tool for handling failover.
We also have some 3rd party tools that don't support windows...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 2:45 pm
My guess here is that you didn't configure TEMPDB correctly because if you set a MAX SIZE on TEMPDB, that's as big as it will go.
Even the AWS documentation indicates...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 2:31 pm
Also, Microsoft has some documentation on what to try:
The important tip they offer is:
If the last attempt did not start the external program, verify that the Database Mail External Program...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 2:22 pm
Viewing 15 posts - 1,126 through 1,140 (of 2,917 total)