Viewing 15 posts - 451 through 465 (of 6,676 total)
I see you have both distinct and group by in the same query - use one or the other, and since you are not using any aggregate functions then you...
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
September 9, 2022 at 8:00 pm
Here is another method - not dynamic, but easily extensible:
Declare @sampleData table (Name varchar(50), City varchar(50), Zip char(5));
Insert Into @sampleData (Name, City, Zip)
Values ('AAA', 'Dallas',...
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
September 9, 2022 at 7:08 pm
I have this stored procedure that is inserting/updataing a staging tabe and another table. I dont have access to the Azure Data Factory.
(a) I would like to know if i...
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
September 9, 2022 at 4:54 pm
Before going down the path of partitioning - what are you expecting to achieve by doing so? What is the purpose of partitioning - and more to the point, why...
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
September 8, 2022 at 8:28 pm
Do you mean errors which are reported via DBCC CHECKDB?
If so the official line from Microsoft is to restore to your last known good backup.
You may attempt the repair_rebuild...
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
September 8, 2022 at 4:43 pm
It would probably help a...
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
September 7, 2022 at 9:41 pm
Yes, # 8 is what I am seeing from SQL.
Does changing Maxdop & cost of threshold will effect other queries performance? These setting changes require SQL server restart?
The change...
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
September 7, 2022 at 6:08 pm
The Parallelism settings for the server is below
Processors: 8
Cost threshold for Parallelism: 25 Locks: 0 Max Degree of Parallelism:0 Query Wait:-1
For the processors, is that "Physical Core" or...
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
September 6, 2022 at 10:13 pm
If you are seeing blocking where the session_id and blocking_session_id are the same - you are seeing parallelism. You will often see one of the parallel threads blocking other threads...
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
September 6, 2022 at 6:59 pm
In my case the solution was to divide into 2 views, and keep the ID column in the second view just in case of misalignment. Also CSV format 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
September 4, 2022 at 4:30 pm
I would remove the convert from the where clause - it isn't needed.
AND o.created_datetime >= '2020-04-01'
Unless that column is not actually a datetime data type - if that is 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
August 29, 2022 at 8:51 pm
To clarify I am using built in function to read from SQL Audit file but the other team has capability to read from .txt file only, that is 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
August 28, 2022 at 3:39 pm
Instead of using PowerShell, why not make a call to BCP and us the "out" functionality? It's nasty fast. I'll also tell you that if they have SQL Server...
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
August 28, 2022 at 3:01 pm
The import/export process is designed to create tables - you selected the source of the data to be a view and the destination to be a table, that is why...
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
August 20, 2022 at 9:51 pm
That is confusing - how did you 'copy' the view from QA to production? And how would that create a table instead of a view?
You stated you used the code...
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
August 20, 2022 at 9:01 pm
Viewing 15 posts - 451 through 465 (of 6,676 total)