Viewing 15 posts - 91 through 105 (of 2,863 total)
As far as I know SSIS cannot be scripted. SSIS is it's own thing. The export method you are using is designed to be an infrequent export option. If you...
June 26, 2025 at 1:58 pm
A lot to unpack here and not entirely sure what you are trying to achieve, but will do my best to answer.
First, if you are deleting 30 million rows, you...
June 25, 2025 at 5:11 pm
The third one is a fun one - open source dependencies. We have a tool that often has "free" plugins available for it but after a few years those free...
June 25, 2025 at 4:49 pm
Just to confirm, you get that error when trying to PREVIEW the report on your local computer, correct? If so, are you using the correct VS version for the SSDT...
June 25, 2025 at 4:35 pm
I've personally never used between and it is because of this exact QOTD - I can never remember for certain if it is inclusive, exclusive, or a mix and I'd...
June 24, 2025 at 3:14 pm
I have also used heaps when the data has no real business value but someone requested the data to be captured because it may be needed one day by someone....
June 24, 2025 at 2:44 pm
My big takeaway from your article was this bit:
But perhaps the most valuable insight was this: before touching MAXDOP, fix the query. In our case, adding a missing index and...
June 23, 2025 at 8:50 pm
With the ad hoc queries as needed, a good monitoring tool should be able to capture some of those too. RedGate Monitor (formerly SQL Monitor) allows you to capture custom...
June 23, 2025 at 7:04 pm
My advice - don't trust random people on a forum - trust the source. Check the Microsoft Docs:
Upgrading to 2022 requires a min version of 2012 SP4.
Now, that being said,...
June 23, 2025 at 6:56 pm
Multiple tools means more systems to administer and more tools to patch which also means more man-hours to keep your environment up to date.
I much prefer to get all of...
June 20, 2025 at 10:05 pm
Merge is generally a slow operation. I think if you are wanting fastest performance, your best bet is to grab all of the delta's that are going to be INSERTs...
June 20, 2025 at 9:48 pm
You say that he doesn't have cases where he would have 3 or more values needed for calculating the average, but that is current state. What happens in 5 years?...
June 19, 2025 at 9:42 pm
Without seeing your data (or sample or DDL or DML), I'm just guessing here but I see this as a multiple problem thing.
First you want to know if you need...
June 19, 2025 at 6:51 pm
My advice - sanitize the data before import. Use Excel to get the dates into one standard format (manual approach) if it isn't too time consuming. If it is too...
June 19, 2025 at 6:20 pm
Just want to add that even with 1 big server, I still like to have a minimum of 2. That way you get failover. If the server/VM needs a reboot,...
June 16, 2025 at 10:27 pm
Viewing 15 posts - 91 through 105 (of 2,863 total)