Viewing 15 posts - 451 through 465 (of 2,857 total)
I am not sure how you ruled out "other tasks". SQL creating a dump is caused by something and the original dump you indicated to me REALLY looks like it...
October 26, 2023 at 5:51 pm
My opinion, turning on the legacy cardinality estimator is more of a band-aid solution and it will fail in a future upgrade to SQL server as Microsoft isn't going to...
October 26, 2023 at 3:52 pm
The error tells you exactly what is wrong. The CMS can't be in the registered server list. You will need to edit the CMS list to remove the "my new...
October 26, 2023 at 3:30 pm
Moving physical hardware to virtual is easy in something like VMWare using a process called P2V. It stands for "Physical to Virtual" and it is for moving physical hardware to...
October 26, 2023 at 2:19 pm
Not a solution, but is there a reason you need to print it from the web (ssrs)? In general, I try to avoid printing from the web and prefer printing...
October 25, 2023 at 9:11 pm
I agree with Phil here on the process. BUT I would strongly suggest you do NOT make changes to production systems until you verify the changes on a test system.
So...
October 25, 2023 at 2:56 pm
I would have to agree with Grant here - SQL doesn't work great with storing files. It can do it, but you run into snags around performance.
My question to you...
October 25, 2023 at 2:39 pm
To add to what Jeff said, provide us some sample code for what you have tried too. Looking at it though I do have a question about the results -...
October 2, 2023 at 4:43 pm
Like most things in the tech-world - authentication is required AND something you would want set up. You don't want just any random person who can access your SSRS server...
October 2, 2023 at 4:21 pm
My opinion, this is a horrible way to store your data. Why wouldn't you store the data inputs as their own bits of data?
What I mean is why would your...
September 29, 2023 at 2:24 pm
Probably a dumb question, but is there anything interesting in the windows event logs apart from the "application" log? What I mean is, is there anything interesting under System or...
September 28, 2023 at 5:17 pm
Something to note about Ken's reply, you will want to make sure that the "evaluation" license allows you to do what you are trying to do. I know the visual...
September 20, 2023 at 4:23 pm
I would take Jeff's advice here. Plus, the question about if logical or physical reads are more important to performance tuning can be found by doing a google for "performance...
September 20, 2023 at 2:12 pm
Apart from the advice above, I'd check all of the disks and any place that the backup file sat for any period of time to make sure that you aren't...
September 19, 2023 at 10:07 pm
I think the easiest way to do it would be to script out all of the stored procedures that do cross-database communication, drop them, generate the bacpacs, import the bacpacs,...
September 18, 2023 at 4:28 pm
Viewing 15 posts - 451 through 465 (of 2,857 total)