Viewing 15 posts - 1 through 15 (of 9,634 total)
I think this is a good use case for XE. If you are on SQL 2016+ Query Store may be already doing what you want though, so you could look...
March 1, 2022 at 5:58 pm
The only way to resolve this issue is to take a log backup. The log cannot be shrunk until a backup takes place. Once you do a log backup...
October 7, 2021 at 8:19 pm
If you are migrating to an EC2 VM and you have VPN between your on-prem network and AWS you can do log-shipping and skip the S3 bucket.
How you do it...
September 30, 2021 at 2:15 pm
Can you post the table definition?
Your original post list the columns you want included in your clustered primary key and that looks like a very wide clustering key and best...
Haven't been active in quite a bit here, but hope everyone is well and stayed healthy through 2020.
Glad to see the tone of THE THREAD hasn't changed.
January 6, 2021 at 5:19 pm
There are several uses:
March 31, 2020 at 7:37 pm
We had a person at my old job. She was ALWAYS on the phone. I got curious as to why and so I discreetly "hung around"...
December 6, 2019 at 10:12 pm
p.s. I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies". It there's not a well documented ticket to support the urgency, it doesn't...
December 6, 2019 at 3:06 pm
I don't think it helps that there are many, on certain websites (cough Stack overflow cough) that don't help the situation by answering the questions for these people, just...
December 6, 2019 at 2:15 pm
I don't know where you are located, but you can always reach out to local non-profits to see if they use SQL Server and if they do they are always...
November 15, 2019 at 6:19 pm
I'll be the dissenting voice here. I've used SSIS quite successfully for migrations, data warehouse loads, and file loads into databases. In my opinion, SSIS, particularly since 2012 with the...
October 21, 2019 at 2:46 pm
As has already been shared, while Profiler/SQL Trace has been deprecated, it really means that no new features will be supported by SQL Trace. For instance as soon as you...
October 17, 2019 at 7:10 pm
Ola's scripts are AG-Aware so they should do nothing on a secondary for databases that are in an AG.
August 31, 2019 at 1:41 pm
Thanks. I haven't had the opportunity to trace through all that SSRS is submitting. It looks like this query is being passed as shown without a parameter for the user,...
August 20, 2019 at 9:00 pm
You are not defining the array of jobs properly. You need to replace the curly braces with parenthesis.
$job = @( 'BASELINE_CaptureConfigData', ...
July 25, 2019 at 4:28 pm