Viewing 15 posts - 211 through 225 (of 6,676 total)
Here is an example - modifying Jeff Moden's code:
--===== This could be a parameter that you pass to an iTVF (Inline Table Valued Function)
DECLARE @pJSON NVARCHAR(MAX) =...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 19, 2023 at 9:14 pm
You may want to validate the return value from OPENJSON - I believe it returns an NVARCHAR and that could have a significant impact on performance.
Damn! Awesome catch,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 19, 2023 at 8:41 pm
You may want to validate the return value from OPENJSON - I believe it returns an NVARCHAR and that could have a significant impact on performance.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 19, 2023 at 7:45 pm
As I responded on SQL team forum:
You don't need to remove the database from the AG to shrink the log. You should just issue DBCC SHRINKFILE and follow that up...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 19, 2023 at 7:39 pm
I am with Grant - I don't see any reason to be splitting a table. No matter what - all development groups will still need access to the original table...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 18, 2023 at 9:06 pm
Backup and Restore history is kept in the MSDB database and there are plenty of code examples of pulling that information. Instead of trying to pull that information from the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 6, 2023 at 4:59 pm
Heh... you're seriously going to export SSNs to a file in an unencrypted manner along with all that nice PII. What company did you say you work...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 5, 2023 at 2:13 pm
Heh... you're seriously going to export SSNs to a file in an unencrypted manner along with all that nice PII. What company did you say you work for?
Just curious...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 4, 2023 at 4:17 pm
If you are referring to a Failover Cluster Instance (FCI) in the cluster - where that instance has been installed in the cluster using shared storage, then yes - the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 30, 2023 at 2:52 pm
Looks like you have a problem with the storage that needs to be corrected.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 30, 2023 at 2:48 pm
Consider enabling query store and/or setup an extended event to identify long running queries. If the performance is actually related to something in SQL Server - it will almost certainly...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 29, 2023 at 4:31 pm
I don't believe an SPN would be created for those accounts - they are local to that machine only.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 27, 2023 at 5:54 pm
The simplest would be to add a where clause - but I am guessing that you want all voucher's with the 'latest' transaction type available for that voucher.
If that is...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 26, 2023 at 9:37 pm
There are many factors to how long it will take SQL Server to deliver the results to a client - including network time and processing time from the client. If...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 26, 2023 at 9:20 pm
Okay, point taken and thank you for teaching me that. However, this query is very simple. It is literally just select column one column two column 3 from table...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2023 at 4:21 pm
Viewing 15 posts - 211 through 225 (of 6,676 total)