Viewing 15 posts - 61 through 75 (of 2,853 total)
I think it really depends on how much the data is going to be changing. Where I work, the data changing in the database is slow. Some of our databases...
July 8, 2025 at 7:22 pm
My opinion - Access is the wrong tool for the job. If you have a SQL Server standard (or higher) license, use SSRS for this instead. Report creator uploads the...
July 8, 2025 at 7:12 pm
First, I'll say I've not done this before, but wanted to give my opinion on how I'd approach this problem.
I'd say test it out. For issue 1, I'd use the...
July 7, 2025 at 3:43 pm
I know you already did this manually, but I'd recommend using something like Visual Studio/ADS (I think this is being retired)/VS Code and GitLab/GitHub. I recommend some self-hosted git so...
July 7, 2025 at 3:06 pm
Do you need real-time data in the secondary database? If not, you could have an SSIS job that pulls data out of the primary and pushes it to the AI...
July 4, 2025 at 6:56 pm
The other fun thing is MOST modern systems have audits of some sort. So even if you try to say it wasn't your fault or you pretend it wasn't or...
July 4, 2025 at 6:02 pm
My opinion - it depends on what they consider "duplicate" and de-duplication.
Are they meaning on the row level or column level? At the column level, if you have a lot...
July 4, 2025 at 5:47 pm
As I mentioned earlier, I have stopped receiving e-mail notifications of replies, for some reason.
The actual procs are not named with numbers! They are named based on the tables...
July 2, 2025 at 8:02 pm
My recommendation is to leave it on. Statistics are used to build execution plans. If the statistics are stale or missing, then execution plans can be inefficient.
The auto-update updates the...
July 2, 2025 at 4:30 pm
I imagine you don't actually have them named like that with numbers, so trying to figure out which one to run first and second is a bit more involved. I...
June 27, 2025 at 10:31 pm
If I am not mistaken, PowerQuery is part of Excel, so it'll be hard to remove excel from your mix.
PQ can be used in many other places,...
June 27, 2025 at 10:27 pm
If I am not mistaken, PowerQuery is part of Excel, so it'll be hard to remove excel from your mix.
But is there any reason you aren't just connecting SSIS to...
June 26, 2025 at 9:09 pm
As another thought, if you want this strictly TSQL, is there any harm in running them all sequentially? Like run getT1 then getT2 then getT3 and so on? It ensures...
June 26, 2025 at 9:05 pm
One risk with SQL Aliases is if you need to change the alias for any reason. SQL upgrades like SQL 2017 to 2022 using a migration upgrade approach means you...
June 26, 2025 at 8:12 pm
Forgot one thing that I don't recommend, but would kind of be an option - xp_cmdshell. While I strongly advise against it, you COULD use xp_cmdshell to export data to...
June 26, 2025 at 5:32 pm
Viewing 15 posts - 61 through 75 (of 2,853 total)